Table: Contact_Address
Columns
NameTypeConstraintsDescription
contact_address_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
contact_KEYintNOT NULLKey to a Contact record.
contact_address_type_KEYintNOT NULLKey to a Contact Address Type record.
address_1nvarchar (40)NOT NULLFirst line of address.
address_2nvarchar (40)NOT NULLSecond line of address.
citynvarchar (40)NOT NULLCity.
state_abbreviationnvarchar (2)NOT NULLState.
postal_codenvarchar (10)NOT NULLZipCode / postal code.
countynvarchar (25)NOT NULLCounty.
countrynvarchar (25)NOT NULLCountry.
create_date_utcdatetimeNOT NULL
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
address_3nvarchar (128)NOT NULLThird line of address.
Primary key
NameColumnsDescription
PK_Contact_Address$contact_address_KEYcontact_address_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Contact_Address$contact_KEY$contact_address_type_KEYcontact_KEY, contact_address_type_KEYEach Contact can only have one of each type of addresss.
Indexes
NameColumnsDescription
IX_Contact_Address$contact_address_type_KEYcontact_address_type_KEYIndex supports foreign key FK_Contact_Address__Contact_Address_Type__contact_address_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact_Address__Contact__contact_KEYcontact_KEYContact

Schema diagram