Table: dbo.Connect_Alert
This table stores alerts from CS Connect
Columns
NameTypeConstraintsDescription
recorded_event_KEYint (4)NOT NULLRecorded Event key.
productnvarchar (60)NOT NULLProduct description.
classificationnvarchar (60)NOT NULLProduct classification.
connect_alert_type_KEYint (4)NOT NULLAlert type.
begin_datesmalldatetime (4)NOT NULLDate to begin showing the alert.
expiration_datesmalldatetime (4)Date to stop showing the alert.
connect_event_idint (4)NOT NULLCS Connects unique alert id.
Primary key
NameColumnsDescription
PK_Connect_Alert$recorded_event_KEYrecorded_event_KEY
Unique constraints
NameColumnsDescription
UK_Connect_Alert$connect_event_idconnect_event_id
Foreign keys
NameColumnsReferenced tableDescription
FK_Connect_Alert__Connect_Alert_Type__connect_alert_type_KEYconnect_alert_type_KEYConnect_Alert_Type (connect_alert_type_KEY)
FK_Connect_Alert__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event (recorded_event_KEY)

Schema diagram