Table: Contact_Email
Columns
NameTypeConstraintsDescription
contact_email_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_email_type_KEYintNOT NULLKey to a Contact Email Type record.
emailnvarchar (320)NOT NULLE-mail address.
create_date_utcdatetimeNOT NULL
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
display_asnvarchar (320)NOT NULL
Primary key
NameColumnsDescription
PK_Contact_Email$contact_email_KEYcontact_email_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Contact_Email$contact_KEY$contact_email_type_KEYcontact_KEY, contact_email_type_KEYEach Contact can only have one of each type of e-mail address.
Indexes
NameColumnsDescription
IX_Contact_Email$contact_email_type_KEYcontact_email_type_KEYIndex supports foreign key FK_Contact_Email__Contact_Email_Type__contact_email_type_KEY
IX_Contact_Email$email@contact_KEYemail, contact_KEYThis index supports looking up contacts based on email address, mainly for email indexing.
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact_Email__Contact__contact_KEYcontact_KEYContact
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Monitored_Event_Action__Contact_Email__contact_email_KEYcontact_email_KEYMonitored_Event_Action
FK_Recorded_Event_Notification__Contact_Email__contact_email_KEYcontact_email_KEYRecorded_Event_Notificationon delete set null;

Schema diagram