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 |