| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| committee_id |
serial |
10 |
|
√ |
nextval('committee_id_seq'::regclass) |
|
|
| parent_id |
int4 |
10 |
|
|
|
|
|
| state_id |
bpchar |
2 |
|
|
|
|
| state.state_id
|
committee__state_id_fk R |
|
| committeetype_id |
bpchar |
1 |
|
|
|
|
|
| name |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| address1 |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| address2 |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| zip |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| phone |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| fax |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| email |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| url |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| staffcontact |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| jurisdiction |
text |
2147483647 |
|
|
''::text |
|
|
| city |
varchar |
2147483647 |
|
|
''::character varying |
|
|
| state |
bpchar |
2 |
√ |
|
null |
|
|
| active |
bool |
1 |
|
|
true |
|
|
| special |
bool |
1 |
√ |
|
null |
|
|
Table contained 3,400 rows at Tue Jan 03 04:46 MST 2017
|
