ZIPCITYSTATE
Stores city and state information for zip codes.
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| POSTCODE | nvarchar(12) | Default = '' | Contains the zip code. | |
| CITY | nvarchar(50) | Default = '' | Contains the city. |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| STATEID | uniqueidentifier | STATE.LOCALID | Contains a foreign key to the STATE table. | |
| COUNTRYID | uniqueidentifier | COUNTRY.LOCALID | Contains a foreign key to the COUNTRY table. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_ZIPCITYSTATE_POSTCODE | POSTCODE | |||
| IX_ZIPCITYSTATE_STATEID | STATEID | |||
| PK_ZIPCITYSTATE | ID | yes | yes | yes |