Table: dbo.Contact_Phone
Columns
NameTypeConstraintsDescription
contact_phone_KEYint (4)NOT NULLDatabase assigned primary key for this table.
contact_KEYint (4)NOT NULLKey to a Contact record.
contact_phone_type_KEYint (4)NOT NULLKey to a Contact Phone Type record.
phonenvarchar (50)NOT NULLPhone number.
extensionnvarchar (10)NOT NULLExtension.
Primary key
NameColumnsDescription
PK_Contact_Phonecontact_phone_KEY
Unique constraints
NameColumnsDescription
UK_Contact_Phone$contact_KEY$contact_phone_type_KEYcontact_KEY, contact_phone_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact_Phone__Contact__contact_KEYcontact_KEYContact (contact_KEY)
FK_Contact_Phone__Contact_Phone_Type__contact_phone_type_KEYcontact_phone_type_KEYContact_Phone_Type (contact_phone_type_KEY)

Schema diagram