Table: dbo.Signoff_Role
This table will be used to keep track of the different roles for a signoff
Columns
NameTypeConstraintsDescription
signoff_role_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (50)NOT NULLContains the different signoff roles
Primary key
NameColumnsDescription
PK_Signoff_Rolesignoff_role_KEY
Unique constraints
NameColumnsDescription
UK_Signoff_Role$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Signoff_Type__Signoff_Role__signoff_role_KEYsignoff_role_KEYSignoff_Type

Schema diagram