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.
email | 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 |