| 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 | |