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