Table discourse.public.categories 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('categories_id_seq'::regclass)
name varchar 50
color varchar 6 'AB9364'::character varying
topic_id int4 10  √  null
topic_count int4 10 0
created_at timestamp 29,6
updated_at timestamp 29,6
user_id int4 10
topics_year int4 10  √  0
topics_month int4 10  √  0
topics_week int4 10  √  0
slug varchar 255
description text 2147483647  √  null
text_color varchar 6 'FFFFFF'::character varying
read_restricted bool 1 false
auto_close_hours float8 17,17  √  null
post_count int4 10 0
latest_post_id int4 10  √  null
latest_topic_id int4 10  √  null
position int4 10  √  null
parent_category_id int4 10  √  null
posts_year int4 10  √  0
posts_month int4 10  √  0
posts_week int4 10  √  0
email_in varchar 255  √  null
email_in_allow_strangers bool 1  √  false
topics_day int4 10  √  0
posts_day int4 10  √  0
logo_url varchar 255  √  null
background_url varchar 255  √  null
allow_badges bool 1 true
name_lower varchar 50
auto_close_based_on_last_post bool 1  √  false

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc categories_pkey  
email_in Must be unique Asc index_categories_on_email_in This unique column is also nullable
topic_count Performance Asc index_categories_on_topic_count  
name Must be unique Asc unique_index_categories_on_name