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
Name | Type | Constraints | Description
notification_generalized_type_KEY | tinyint (1) | NOT NULL | The primary key used for identifying general scenarios.
description | nvarchar (200) | NOT NULL | The description of scenario that can trigger notifications.

Primary key
Name | Columns | Description
PK_Notification_Generalized_Type | notification_generalized_type_KEY |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Notification_Type__Notification_Generalized_Type__notification_generalized_type_KEY | notification_generalized_type_KEY | Notification_Type |