| Name | Data type | Not Null? | Primary key? | Default | Comment |
|---|---|---|---|---|---|
| id | integer | Yes | Yes | nextval('zip_codes_id_seq'::regclass) | Unique identifier |
| code | character varying(16) | No | No | U.S.A. Zip code | |
| state | character varying(2) | No | No | State for record | |
| city | character varying(45) | No | No | City for record |
| Name | Type | Definition | Comment |
|---|---|---|---|
| zip_codes_pkey | Primary key | (id) |