| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| congress_id |
int4 |
10 |
√ |
|
null |
|
|
| congtype_id |
bpchar |
1 |
√ |
|
null |
|
| congtype.congtype_id
|
Implied Constraint R |
|
| state_id |
bpchar |
2 |
√ |
|
null |
|
| state.state_id
|
Implied Constraint R |
|
| congstatus_id |
int4 |
10 |
√ |
|
null |
|
|
| conglevel_id |
bpchar |
1 |
√ |
|
null |
|
|
| congstage_id |
int2 |
5 |
√ |
|
null |
|
|
| congoutcome_id |
int2 |
5 |
√ |
|
null |
|
|
| congofficialtitle_id |
int4 |
10 |
√ |
|
null |
|
|
| congtitle_id |
int4 |
10 |
√ |
|
null |
|
|
| conghighlight_id |
int4 |
10 |
√ |
|
null |
|
|
| congsynopsis_id |
int4 |
10 |
√ |
|
null |
|
|
| congcategory_id |
int4 |
10 |
√ |
|
null |
|
|
| congofficialsynopsis_id |
int4 |
10 |
√ |
|
null |
|
|
| congtext_id |
int4 |
10 |
√ |
|
null |
|
|
| congress_release_id |
int2 |
5 |
√ |
|
null |
|
|
| congstatus_release_id |
int2 |
5 |
√ |
|
null |
|
|
| billnumber |
varchar |
2147483647 |
√ |
|
null |
|
|
| statename |
varchar |
2147483647 |
√ |
|
null |
|
|
| url |
varchar |
2147483647 |
√ |
|
null |
|
|
| rank |
int2 |
5 |
√ |
|
null |
|
|
| statusdate |
date |
13 |
√ |
|
null |
|
|
| rollnumber |
int2 |
5 |
√ |
|
null |
|
|
| level |
varchar |
2147483647 |
√ |
|
null |
|
|
| stage |
varchar |
2147483647 |
√ |
|
null |
|
|
| outcome |
varchar |
2147483647 |
√ |
|
null |
|
|
| yea |
int2 |
5 |
√ |
|
null |
|
|
| nay |
int2 |
5 |
√ |
|
null |
|
|
| voicevote |
bool |
1 |
√ |
|
null |
|
|
| keyvote |
bool |
1 |
√ |
|
null |
|
|
| congress_note |
varchar |
2147483647 |
√ |
|
null |
|
|
| congstatus_note |
varchar |
2147483647 |
√ |
|
null |
|
|
| officialtitle |
text |
2147483647 |
√ |
|
null |
|
|
| title |
varchar |
2147483647 |
√ |
|
null |
|
|
| highlight |
text |
2147483647 |
√ |
|
null |
|
|
| synopsis |
text |
2147483647 |
√ |
|
null |
|
|
| officialsynopsis |
text |
2147483647 |
√ |
|
null |
|
|
Analyzed at Tue Jan 03 04:46 MST 2017
|
