| Table: dbo.Connect_Alert | |||
| This table stores alerts from CS Connect | |||
| Columns | |||
| Name | Type | Constraints | Description |
| recorded_event_KEY | int (4) | NOT NULL | Recorded Event key. |
| product | nvarchar (60) | NOT NULL | Product description. |
| classification | nvarchar (60) | NOT NULL | Product classification. |
| connect_alert_type_KEY | int (4) | NOT NULL | Alert type. |
| begin_date | smalldatetime (4) | NOT NULL | Date to begin showing the alert. |
| expiration_date | smalldatetime (4) | Date to stop showing the alert. | |
| connect_event_id | int (4) | NOT NULL | CS Connects unique alert id. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Connect_Alert$recorded_event_KEY | recorded_event_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Connect_Alert$connect_event_id | connect_event_id | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Connect_Alert__Connect_Alert_Type__connect_alert_type_KEY | connect_alert_type_KEY | Connect_Alert_Type (connect_alert_type_KEY) | |
| FK_Connect_Alert__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event (recorded_event_KEY) | |