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