| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
serial |
10 |
|
√ |
nextval('topics_id_seq'::regclass) |
|
|
| title |
varchar |
255 |
|
|
|
|
|
| last_posted_at |
timestamp |
29,6 |
√ |
|
null |
|
|
| created_at |
timestamp |
29,6 |
|
|
|
|
|
| updated_at |
timestamp |
29,6 |
|
|
|
|
|
| views |
int4 |
10 |
|
|
0 |
|
|
| posts_count |
int4 |
10 |
|
|
0 |
|
|
| user_id |
int4 |
10 |
√ |
|
null |
|
|
| last_post_user_id |
int4 |
10 |
|
|
|
|
|
| reply_count |
int4 |
10 |
|
|
0 |
|
|
| featured_user1_id |
int4 |
10 |
√ |
|
null |
|
|
| featured_user2_id |
int4 |
10 |
√ |
|
null |
|
|
| featured_user3_id |
int4 |
10 |
√ |
|
null |
|
|
| avg_time |
int4 |
10 |
√ |
|
null |
|
|
| deleted_at |
timestamp |
29,6 |
√ |
|
null |
|
|
| highest_post_number |
int4 |
10 |
|
|
0 |
|
|
| image_url |
varchar |
255 |
√ |
|
null |
|
|
| off_topic_count |
int4 |
10 |
|
|
0 |
|
|
| like_count |
int4 |
10 |
|
|
0 |
|
|
| incoming_link_count |
int4 |
10 |
|
|
0 |
|
|
| bookmark_count |
int4 |
10 |
|
|
0 |
|
|
| category_id |
int4 |
10 |
√ |
|
null |
|
|
| visible |
bool |
1 |
|
|
true |
|
|
| moderator_posts_count |
int4 |
10 |
|
|
0 |
|
|
| closed |
bool |
1 |
|
|
false |
|
|
| archived |
bool |
1 |
|
|
false |
|
|
| bumped_at |
timestamp |
29,6 |
|
|
|
|
|
| has_summary |
bool |
1 |
|
|
false |
|
|
| vote_count |
int4 |
10 |
|
|
0 |
|
|
| archetype |
varchar |
255 |
|
|
'regular'::character varying |
|
|
| featured_user4_id |
int4 |
10 |
√ |
|
null |
|
|
| notify_moderators_count |
int4 |
10 |
|
|
0 |
|
|
| spam_count |
int4 |
10 |
|
|
0 |
|
|
| illegal_count |
int4 |
10 |
|
|
0 |
|
|
| inappropriate_count |
int4 |
10 |
|
|
0 |
|
|
| pinned_at |
timestamp |
29,6 |
√ |
|
null |
|
|
| score |
float8 |
17,17 |
√ |
|
null |
|
|
| percent_rank |
float8 |
17,17 |
|
|
1.0 |
|
|
| notify_user_count |
int4 |
10 |
|
|
0 |
|
|
| subtype |
varchar |
255 |
√ |
|
null |
|
|
| slug |
varchar |
255 |
√ |
|
null |
|
|
| auto_close_at |
timestamp |
29,6 |
√ |
|
null |
|
|
| auto_close_user_id |
int4 |
10 |
√ |
|
null |
|
|
| auto_close_started_at |
timestamp |
29,6 |
√ |
|
null |
|
|
| deleted_by_id |
int4 |
10 |
√ |
|
null |
|
|
| participant_count |
int4 |
10 |
√ |
|
1 |
|
|
| word_count |
int4 |
10 |
√ |
|
null |
|
|
| excerpt |
varchar |
1000 |
√ |
|
null |
|
|
| pinned_globally |
bool |
1 |
|
|
false |
|
|
| auto_close_based_on_last_post |
bool |
1 |
√ |
|
false |
|
|
| auto_close_hours |
float8 |
17,17 |
√ |
|
null |
|
|
Table contained 22 rows at Fri Mar 27 12:26 PDT 2015
|