| Table: dbo.Contact_Address | |||
| Columns | |||
| Name | Type | Constraints | Description |
| contact_address_KEY | int (4) | NOT NULL | Database assigned primary key for this table. |
| contact_KEY | int (4) | NOT NULL | Key to a Contact record. |
| contact_address_type_KEY | int (4) | NOT NULL | Key to a Contact Address Type record. |
| address_1 | nvarchar (100) | NOT NULL | First line of address. |
| address_2 | nvarchar (100) | NOT NULL | Second line of address. |
| city | nvarchar (60) | NOT NULL | City. |
| state_abbreviation | nvarchar (4) | NOT NULL | State. |
| postal_code | nvarchar (20) | NOT NULL | ZipCode / postal code. |
| county | nvarchar (70) | NOT NULL | County. |
| country | nvarchar (50) | NOT NULL | Country. |
| location_search_accuracy_type_KEY | int (4) | NOT NULL | Accuracy level of a location search |
| lcs_normalized_address | nvarchar (400) | NOT NULL | Pipe separated normalized address returned by a location search. |
| latitude | nvarchar (50) | NOT NULL | Latitude of location. |
| longitude | nvarchar (50) | NOT NULL | Longitude of location. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Contact_Address | contact_address_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Contact_Address$contact_KEY$contact_address_type_KEY | contact_KEY, contact_address_type_KEY | ||