View discourse.public.badge_posts 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 int4 10  √  null
user_id int4 10  √  null
topic_id int4 10  √  null
post_number int4 10  √  null
raw text 2147483647  √  null
cooked text 2147483647  √  null
created_at timestamp 29,6  √  null
updated_at timestamp 29,6  √  null
reply_to_post_number int4 10  √  null
reply_count int4 10  √  null
quote_count int4 10  √  null
deleted_at timestamp 29,6  √  null
off_topic_count int4 10  √  null
like_count int4 10  √  null
incoming_link_count int4 10  √  null
bookmark_count int4 10  √  null
avg_time int4 10  √  null
score float8 17,17  √  null
reads int4 10  √  null
post_type int4 10  √  null
vote_count int4 10  √  null
sort_order int4 10  √  null
last_editor_id int4 10  √  null
hidden bool 1  √  null
hidden_reason_id int4 10  √  null
notify_moderators_count int4 10  √  null
spam_count int4 10  √  null
illegal_count int4 10  √  null
inappropriate_count int4 10  √  null
last_version_at timestamp 29,6  √  null
user_deleted bool 1  √  null
reply_to_user_id int4 10  √  null
percent_rank float8 17,17  √  null
notify_user_count int4 10  √  null
like_score int4 10  √  null
deleted_by_id int4 10  √  null
edit_reason varchar 255  √  null
word_count int4 10  √  null
version int4 10  √  null
cook_method int4 10  √  null
wiki bool 1  √  null
baked_at timestamp 29,6  √  null
baked_version int4 10  √  null
hidden_at timestamp 29,6  √  null
self_edits int4 10  √  null
reply_quoted bool 1  √  null

Analyzed at Fri Mar 27 12:26 PDT 2015