Table discourse.public.topic_views Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
topic_id int4 10
viewed_at date 13
user_id int4 10  √  null
ip_address inet 2147483647

Table contained 25 rows at Fri Mar 27 12:26 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
topic_id + viewed_at Performance Asc/Asc index_topic_views_on_topic_id_and_viewed_at
viewed_at + topic_id Performance Asc/Asc index_topic_views_on_viewed_at_and_topic_id
ip_address + topic_id Must be unique Asc/Asc ip_address_topic_id_topic_views
user_id + topic_id Must be unique Asc/Asc user_id_topic_id_topic_views