Table discourse.public.top_topics | Generated by SchemaSpy |
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 |