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
Name | Type | Constraints | Description
notification_type_KEY | tinyint (1) | NOT NULL | The primary key used for identifying specific scenarios.
description | nvarchar (200) | NOT NULL | The description of the specific scenario.
notification_category_type_KEY | tinyint (1) | NOT NULL | Reference to the category of the scenario.
notification_generalized_type_KEY | tinyint (1) | NOT NULL | Reference 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
Name | Columns | Description
PK_Notification_Type | notification_type_KEY |
Unique constraints
Name | Columns | Description
UK_Notification_Type$notification_category_type_KEY$notification_generalized_type_KEY | notification_category_type_KEY, notification_generalized_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Notification_Type__Notification_Category_Type__notification_category_type_KEY | notification_category_type_KEY | Notification_Category_Type (notification_category_type_KEY) |
FK_Notification_Type__Notification_Generalized_Type__notification_generalized_type_KEY | notification_generalized_type_KEY | Notification_Generalized_Type (notification_generalized_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Firm_Notification_Information__Notification_Type__notification_type_KEY | notification_type_KEY | Firm_Notification_Information |
FK_Firm_Notification_Information__Notification_Type__parent__notification_type_KEY | parent__notification_type_KEY | Firm_Notification_Information |
FK_Notification_Queue__Notification_Type__notification_type_KEY | notification_type_KEY | Notification_Queue |