Table discourse.public.top_topics 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
id serial 10  √  nextval('top_topics_id_seq'::regclass)
topic_id int4 10  √  null
yearly_posts_count int4 10 0
yearly_views_count int4 10 0
yearly_likes_count int4 10 0
monthly_posts_count int4 10 0
monthly_views_count int4 10 0
monthly_likes_count int4 10 0
weekly_posts_count int4 10 0
weekly_views_count int4 10 0
weekly_likes_count int4 10 0
daily_posts_count int4 10 0
daily_views_count int4 10 0
daily_likes_count int4 10 0
yearly_score float8 17,17  √  0
monthly_score float8 17,17  √  0
weekly_score float8 17,17  √  0
daily_score float8 17,17  √  0
all_score float8 17,17  √  0
daily_op_likes_count int4 10 0
weekly_op_likes_count int4 10 0
monthly_op_likes_count int4 10 0
yearly_op_likes_count int4 10 0

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc top_topics_pkey  
daily_likes_count Performance Desc index_top_topics_on_daily_likes_count  
daily_op_likes_count Performance Asc index_top_topics_on_daily_op_likes_count  
daily_posts_count Performance Desc index_top_topics_on_daily_posts_count  
daily_views_count Performance Desc index_top_topics_on_daily_views_count  
monthly_likes_count Performance Desc index_top_topics_on_monthly_likes_count  
monthly_op_likes_count Performance Asc index_top_topics_on_monthly_op_likes_count  
monthly_posts_count Performance Desc index_top_topics_on_monthly_posts_count  
monthly_views_count Performance Desc index_top_topics_on_monthly_views_count  
topic_id Must be unique Asc index_top_topics_on_topic_id This unique column is also nullable
weekly_likes_count Performance Desc index_top_topics_on_weekly_likes_count  
weekly_op_likes_count Performance Asc index_top_topics_on_weekly_op_likes_count  
weekly_posts_count Performance Desc index_top_topics_on_weekly_posts_count  
weekly_views_count Performance Desc index_top_topics_on_weekly_views_count  
yearly_likes_count Performance Desc index_top_topics_on_yearly_likes_count  
yearly_op_likes_count Performance Asc index_top_topics_on_yearly_op_likes_count  
yearly_posts_count Performance Desc index_top_topics_on_yearly_posts_count  
yearly_views_count Performance Desc index_top_topics_on_yearly_views_count