Table: dbo.Notification_Type
This table stores identifiers for the different types of specific scenarios that result in notifications. e.g Check SSN validation vs. Employee SSN validation.
Columns
NameTypeConstraintsDescription
notification_type_KEYtinyint (1)NOT NULLThe primary key used for identifying specific scenarios.
descriptionnvarchar (200)NOT NULLThe description of the specific scenario.
notification_category_type_KEYtinyint (1)NOT NULLReference to the category of the scenario.
notification_generalized_type_KEYtinyint (1)NOT NULLReference to the generalized scenario. This could be SSN validation, but this alone does not uniquely identify the specific scenario as it may pertain to employee SSN or check SSN validation.
Primary key
NameColumnsDescription
PK_Notification_Typenotification_type_KEY
Unique constraints
NameColumnsDescription
UK_Notification_Type$notification_category_type_KEY$notification_generalized_type_KEYnotification_category_type_KEY, notification_generalized_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Notification_Type__Notification_Category_Type__notification_category_type_KEYnotification_category_type_KEYNotification_Category_Type (notification_category_type_KEY)
FK_Notification_Type__Notification_Generalized_Type__notification_generalized_type_KEYnotification_generalized_type_KEYNotification_Generalized_Type (notification_generalized_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Firm_Notification_Information__Notification_Type__notification_type_KEYnotification_type_KEYFirm_Notification_Information
FK_Firm_Notification_Information__Notification_Type__parent__notification_type_KEYparent__notification_type_KEYFirm_Notification_Information
FK_Notification_Queue__Notification_Type__notification_type_KEYnotification_type_KEYNotification_Queue

Schema diagram