Table: dbo.Contact_Email | |||
Columns | |||
Name | Type | Constraints | Description |
contact_email_KEY | int (4) | NOT NULL | Database assigned primary key for this table. |
contact_KEY | int (4) | NOT NULL | Key to a Contact record. |
contact_email_type_KEY | int (4) | NOT NULL | Key to a Contact Email Type record. |
nvarchar (640) | NOT NULL | E-mail address. |
Primary key | |||
Name | Columns | Description | |
PK_Contact_Email | contact_email_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Contact_Email$contact_KEY$contact_email_type_KEY | contact_KEY, contact_email_type_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Contact_Email__Contact__contact_KEY | contact_KEY | Contact (contact_KEY) | |
FK_Contact_Email__Contact_Email_Type__contact_email_type_KEY | contact_email_type_KEY | Contact_Email_Type (contact_email_type_KEY) |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Recorded_Event_Notification__Contact_Email__contact_email_KEY | contact_email_KEY | Recorded_Event_Notification |