Table: dbo.Hot_Key
This table will be used to keep track of the hot keys for the system
Columns
NameTypeConstraintsDescription
hot_key_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (20)NOT NULLContains the different hot key descriptions
Primary key
NameColumnsDescription
PK_Hot_Keyhot_key_KEY
Unique constraints
NameColumnsDescription
UK_Hot_Key$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Signoff_Type__Hot_Key__hot_key_KEYhot_key_KEYSignoff_Type

Schema diagram