Table: dbo.Contact_Address
Columns
NameTypeConstraintsDescription
contact_address_KEYint (4)NOT NULLDatabase assigned primary key for this table.
contact_KEYint (4)NOT NULLKey to a Contact record.
contact_address_type_KEYint (4)NOT NULLKey to a Contact Address Type record.
address_1nvarchar (100)NOT NULLFirst line of address.
address_2nvarchar (100)NOT NULLSecond line of address.
citynvarchar (60)NOT NULLCity.
state_abbreviationnvarchar (4)NOT NULLState.
postal_codenvarchar (20)NOT NULLZipCode / postal code.
countynvarchar (50)NOT NULLCounty.
countrynvarchar (50)NOT NULLCountry.
location_search_accuracy_type_KEYint (4)NOT NULLAccuracy level of a location search
lcs_normalized_addressnvarchar (400)NOT NULLPipe separated normalized address returned by a location search.
latitudenvarchar (50)NOT NULLLatitude of location.
longitudenvarchar (50)NOT NULLLongitude of location.
Primary key
NameColumnsDescription
PK_Contact_Addresscontact_address_KEY
Unique constraints
NameColumnsDescription
UK_Contact_Address$contact_KEY$contact_address_type_KEYcontact_KEY, contact_address_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact_Address__Contact__contact_KEYcontact_KEYContact (contact_KEY)
FK_Contact_Address__Contact_Address_Type__contact_address_type_KEYcontact_address_type_KEYContact_Address_Type (contact_address_type_KEY)
FK_Contact_Address__Location_Search_Accuracy_Type__location_search_accuracy_type_KEYlocation_search_accuracy_type_KEYLocation_Search_Accuracy_Type (location_search_accuracy_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Contact_Address_N_Address__Contact_Address__contact_address_KEYcontact_address_KEYContact_Address_N_Address
FK_Contact_Address_Payroll_Information__Contact_Address__contact_address_KEYcontact_address_KEYContact_Address_Payroll_Information
FK_Contact_Address_Ste_Location_Code_History__Contact_Address__contact_address_KEYcontact_address_KEYContact_Address_Ste_Location_Code_History
FK_Ohio_Jedd_Tax__Contact_Address__contact_address_KEYcontact_address_KEYOhio_Jedd_Tax

Schema diagram