| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| addr2zip_id |
varchar |
2147483647 |
|
|
|
|
|
| zip5 |
int4 |
10 |
√ |
|
null |
|
|
| zip4_low |
int2 |
5 |
√ |
|
null |
|
|
| zip4_high |
int2 |
5 |
√ |
|
null |
|
|
| street_direction |
varchar |
2147483647 |
√ |
|
null |
|
|
| street_name |
varchar |
2147483647 |
√ |
|
null |
|
|
| street_suffix |
varchar |
2147483647 |
√ |
|
null |
|
|
| street_post_direction |
varchar |
2147483647 |
√ |
|
null |
|
|
| primary_address_low |
varchar |
2147483647 |
√ |
|
null |
|
|
| primary_address_high |
varchar |
2147483647 |
√ |
|
null |
|
|
| primary_address_parity |
varchar |
2147483647 |
√ |
|
null |
|
|
| building_or_firm_name |
varchar |
2147483647 |
√ |
|
null |
|
|
| secondary_address |
varchar |
2147483647 |
√ |
|
null |
|
|
| secondary_address_low |
varchar |
2147483647 |
√ |
|
null |
|
|
| secondary_address_high |
varchar |
2147483647 |
√ |
|
null |
|
|
| secondary_address_parity |
bpchar |
1 |
√ |
|
null |
|
|
| state_id |
bpchar |
2 |
√ |
|
null |
|
| state.state_id
|
Implied Constraint R |
|
| county_code |
int2 |
5 |
√ |
|
null |
|
|
| municipality_key |
varchar |
2147483647 |
√ |
|
null |
|
|
| urbanization_key |
varchar |
2147483647 |
√ |
|
null |
|
|
| record_type |
bpchar |
1 |
√ |
|
null |
|
|
Table contained 44,991,615 rows at Tue Jan 03 04:46 MST 2017
|
