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 (50) | 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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Contact_Address__Contact__contact_KEY | contact_KEY | Contact (contact_KEY) |
FK_Contact_Address__Contact_Address_Type__contact_address_type_KEY | contact_address_type_KEY | Contact_Address_Type (contact_address_type_KEY) |
FK_Contact_Address__Location_Search_Accuracy_Type__location_search_accuracy_type_KEY | location_search_accuracy_type_KEY | Location_Search_Accuracy_Type (location_search_accuracy_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Contact_Address_N_Address__Contact_Address__contact_address_KEY | contact_address_KEY | Contact_Address_N_Address |
FK_Contact_Address_Payroll_Information__Contact_Address__contact_address_KEY | contact_address_KEY | Contact_Address_Payroll_Information |
FK_Contact_Address_Ste_Location_Code_History__Contact_Address__contact_address_KEY | contact_address_KEY | Contact_Address_Ste_Location_Code_History |
FK_Ohio_Jedd_Tax__Contact_Address__contact_address_KEY | contact_address_KEY | Ohio_Jedd_Tax |