Table: Contact_Address
Columns
Name | Type | Constraints | Description
contact_address_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
contact_KEY | int | NOT NULL | Key to a Contact record.
contact_address_type_KEY | int | NOT NULL | Key to a Contact Address Type record.
address_1 | nvarchar (40) | NOT NULL | First line of address.
address_2 | nvarchar (40) | NOT NULL | Second line of address.
city | nvarchar (25) | NOT NULL | City.
state_abbreviation | nvarchar (2) | NOT NULL | State.
postal_code | nvarchar (10) | NOT NULL | ZipCode / postal code.
county | nvarchar (25) | NOT NULL | County.
country | nvarchar (25) | NOT NULL | Country.
create_date | datetime | NOT NULL |
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |

Primary key
Name | Columns | Description
PK_Contact_Address$contact_address_KEY | contact_address_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Contact_Address__contact_KEY__contact_address_type_KEY | contact_KEY, contact_address_type_KEY | Each Contact can only have one of each type of addresss.
Indexes
Name | Columns | Description
IX_Contact_Address$contact_address_type_KEY | contact_address_type_KEY | Index supports foreign key FK_Contact_Address__Contact_Address_Type__contact_address_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Contact_Address__Contact__contact_KEY | contact_KEY | Contact |
FK_Contact_Address__Contact_Address_Type__contact_address_type_KEY | contact_address_type_KEY | Contact_Address_Type |