Table: dbo.Signoff_Type
This table will be contain the data representing a signoff type
Columns
NameTypeConstraintsDescription
signoff_type_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (100)NOT NULLContains the text for the signoff type
is_activebit (1)NOT NULLBoolean that tells us whether or not the signoff will be filtered out of various areas of the Engagement Workspace
signoff_role_KEYint (4)NOT NULLForeign key to the Signoff_Role table
hot_key_KEYint (4)Foreign key to the Hot_Key table. A null value indicates the hot key was not assigned to the signoff type. Assignments are unique across rows
sequence_numberint (4)NOT NULLUsed to keep track of the user-defined display order for signoff types. The value is required to be unique. When ordering signoff types, they should be ordered across the sequence_number column and then the signoff_type_KEy column.
Primary key
NameColumnsDescription
PK_Signoff_Typesignoff_type_KEY
Unique constraints
NameColumnsDescription
UK_Signoff_Type$descriptiondescription
Foreign keys
NameColumnsReferenced tableDescription
FK_Signoff_Type__Hot_Key__hot_key_KEYhot_key_KEYHot_Key (hot_key_KEY)
FK_Signoff_Type__Signoff_Role__signoff_role_KEYsignoff_role_KEYSignoff_Role (signoff_role_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Firm__Signoff_Type__workpapers_protect__signoff_type_KEYworkpapers_protect__signoff_type_KEYFirm
FK_Engagement_Tree_Column_Selector__Signoff_Type__signoff_type_KEYsignoff_type_KEYEngagement_Tree_Column_Selector
FK_Workpaper_Signoff__Signoff_Type__signoff_type_KEYsignoff_type_KEYWorkpaper_Signoff

Schema diagram