| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
serial |
10 |
|
√ |
nextval('badges_id_seq'::regclass) |
|
|
| name |
varchar |
255 |
|
|
|
|
|
| description |
text |
2147483647 |
√ |
|
null |
|
|
| badge_type_id |
int4 |
10 |
|
|
|
|
|
| grant_count |
int4 |
10 |
|
|
0 |
|
|
| created_at |
timestamp |
29,6 |
|
|
|
|
|
| updated_at |
timestamp |
29,6 |
|
|
|
|
|
| allow_title |
bool |
1 |
|
|
false |
|
|
| multiple_grant |
bool |
1 |
|
|
false |
|
|
| icon |
varchar |
255 |
√ |
|
'fa-certificate'::character varying |
|
|
| listable |
bool |
1 |
√ |
|
true |
|
|
| target_posts |
bool |
1 |
√ |
|
false |
|
|
| query |
text |
2147483647 |
√ |
|
null |
|
|
| enabled |
bool |
1 |
|
|
true |
|
|
| auto_revoke |
bool |
1 |
|
|
true |
|
|
| badge_grouping_id |
int4 |
10 |
|
|
5 |
|
|
| trigger |
int4 |
10 |
√ |
|
null |
|
|
| show_posts |
bool |
1 |
|
|
false |
|
|
| system |
bool |
1 |
|
|
false |
|
|
| image |
varchar |
255 |
√ |
|
null |
|
|
| long_description |
text |
2147483647 |
√ |
|
null |
|
|
Table contained 24 rows at Fri Mar 27 12:26 PDT 2015
|