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