| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| 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
|