| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| office_address_id |
serial |
10 |
|
√ |
nextval('office_address_id_seq'::regclass) |
|
|
| office_candidate_id |
int4 |
10 |
|
|
|
|
|
| addresstype_id |
int2 |
5 |
|
|
|
|
| addresstype.addresstype_id
|
office_address__addresstype_id_fk R |
|
| phone1 |
varchar |
2147483647 |
√ |
|
null |
|
|
| phone2 |
varchar |
2147483647 |
√ |
|
null |
|
|
| fax1 |
varchar |
2147483647 |
√ |
|
null |
|
|
| fax2 |
varchar |
2147483647 |
√ |
|
null |
|
|
| address |
varchar |
2147483647 |
√ |
|
null |
|
|
| city |
varchar |
2147483647 |
√ |
|
null |
|
|
| state |
bpchar |
2 |
√ |
|
null |
|
| state.state_id
|
office_address__state_fk R |
|
| zip |
varchar |
2147483647 |
√ |
|
null |
|
|
| tollfree |
varchar |
2147483647 |
√ |
|
null |
|
|
| ttyd |
varchar |
2147483647 |
√ |
|
null |
|
|
| contactname |
varchar |
2147483647 |
√ |
|
null |
|
|
| contacttitle |
varchar |
2147483647 |
√ |
|
null |
|
|
| note |
text |
2147483647 |
√ |
|
null |
|
|
| rank |
int2 |
5 |
√ |
|
null |
|
|
| npataddress |
bool |
1 |
|
|
false |
|
|
Table contained 106,920 rows at Tue Jan 03 04:46 MST 2017
|
