Table: dbo.Contact_Email
Columns
NameTypeConstraintsDescription
contact_email_KEYint (4)NOT NULLDatabase assigned primary key for this table.
contact_KEYint (4)NOT NULLKey to a Contact record.
contact_email_type_KEYint (4)NOT NULLKey to a Contact Email Type record.
emailnvarchar (640)NOT NULLE-mail address.
Primary key
NameColumnsDescription
PK_Contact_Emailcontact_email_KEY
Unique constraints
NameColumnsDescription
UK_Contact_Email$contact_KEY$contact_email_type_KEYcontact_KEY, contact_email_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact_Email__Contact__contact_KEYcontact_KEYContact (contact_KEY)
FK_Contact_Email__Contact_Email_Type__contact_email_type_KEYcontact_email_type_KEYContact_Email_Type (contact_email_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Recorded_Event_Notification__Contact_Email__contact_email_KEYcontact_email_KEYRecorded_Event_Notification

Schema diagram