Table: dbo.Notification_Generalized_Type
This table stores identifiers for the different types of general scenarios that result in notifications. This combined with a notification category identifies a specific scenario. e.g Check SSN validation vs. Employee SSN validation
Columns
NameTypeConstraintsDescription
notification_generalized_type_KEYtinyint (1)NOT NULLThe primary key used for identifying general scenarios.
descriptionnvarchar (200)NOT NULLThe description of scenario that can trigger notifications.
Primary key
NameColumnsDescription
PK_Notification_Generalized_Typenotification_generalized_type_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Notification_Type__Notification_Generalized_Type__notification_generalized_type_KEYnotification_generalized_type_KEYNotification_Type

Schema diagram