| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| messageid |
int8 |
19 |
|
|
|
|
|
| authorid |
int8 |
19 |
|
|
|
|
|
| rootid |
int8 |
19 |
|
|
|
|
|
| roottype |
int4 |
10 |
|
|
|
|
|
| containerid |
int8 |
19 |
|
|
|
|
|
| containertype |
int4 |
10 |
|
|
|
|
|
| itemid |
int8 |
19 |
√ |
|
null |
|
|
| itemtype |
int4 |
10 |
√ |
|
null |
|
|
| parentid |
int8 |
19 |
√ |
|
null |
|
|
| parenttype |
int4 |
10 |
√ |
|
null |
|
|
| contenttype |
varchar |
100 |
|
|
|
|
|
| authoraddress |
varchar |
100 |
|
|
|
|
|
| ccaddresses |
text |
2147483647 |
√ |
|
null |
|
|
| subject |
varchar |
255 |
|
|
|
|
|
| actiontype |
varchar |
100 |
|
|
|
|
|
| tags |
text |
2147483647 |
√ |
|
null |
|
|
| metadata |
text |
2147483647 |
√ |
|
null |
|
|
| containerlink |
varchar |
1000 |
√ |
|
null |
|
|
| containerlabel |
varchar |
1000 |
√ |
|
null |
|
|
| authorlink |
varchar |
1000 |
√ |
|
null |
|
|
| authorlabel |
varchar |
1000 |
√ |
|
null |
|
|
| itemlink |
varchar |
1000 |
√ |
|
null |
|
|
| itemlabel |
varchar |
1000 |
√ |
|
null |
|
|
| content |
text |
2147483647 |
|
|
|
|
|
| creationdate |
int8 |
19 |
|
|
|
|
|
Table contained 83 rows at Fri Jan 13 13:20 PST 2017
|
