| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 POSTCODE |
nvarchar(12) | Default = '' | Contains the zip code. | |
| CITY |
nvarchar(50) | Default = '' | Contains the city. |
| 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. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_ZIPCITYSTATE_POSTCODE |
POSTCODE | |||
| IX_ZIPCITYSTATE_STATEID |
STATEID | |||
| PK_ZIPCITYSTATE |
ID |  |
|
|