Table: Contact_Phone
Columns
NameTypeConstraintsDescription
contact_phone_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_phone_type_KEYintNOT NULLKey to a Contact Phone Type record.
phonenvarchar (30)NOT NULLPhone number.
extensionnvarchar (5)NOT NULLExtension.
create_date_utcdatetimeNOT NULL
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
Primary key
NameColumnsDescription
PK_Contact_Phone$contact_phone_KEYcontact_phone_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Contact_Phone$contact_KEY$contact_phone_type_KEYcontact_KEY, contact_phone_type_KEYEach Contact can only have one of each type of phone number.
Indexes
NameColumnsDescription
IX_Contact_Phone$contact_phone_type_KEYcontact_phone_type_KEYIndex supports foreign key FK_Contact_Phone__Contact_Phone_Type__contact_phone_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact_Phone__Contact__contact_KEYcontact_KEYContact

Schema diagram