Table: dbo.Signoff_Type
This table will be contain the data representing a signoff type
Columns
Name | Type | Constraints | Description
signoff_type_KEY | int (4) | NOT NULL | Primary key
description | nvarchar (100) | NOT NULL | Contains the text for the signoff type
is_active | bit (1) | NOT NULL | Boolean that tells us whether or not the signoff will be filtered out of various areas of the Engagement Workspace
signoff_role_KEY | int (4) | NOT NULL | Foreign key to the Signoff_Role table
hot_key_KEY | int (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_number | int (4) | NOT NULL | Used 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
Name | Columns | Description
PK_Signoff_Type | signoff_type_KEY |
Unique constraints
Name | Columns | Description
UK_Signoff_Type$description | description |

Foreign keys
Name | Columns | Referenced table | Description
FK_Signoff_Type__Hot_Key__hot_key_KEY | hot_key_KEY | Hot_Key (hot_key_KEY) |
FK_Signoff_Type__Signoff_Role__signoff_role_KEY | signoff_role_KEY | Signoff_Role (signoff_role_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Firm__Signoff_Type__workpapers_protect__signoff_type_KEY | workpapers_protect__signoff_type_KEY | Firm |
FK_Engagement_Tree_Column_Selector__Signoff_Type__signoff_type_KEY | signoff_type_KEY | Engagement_Tree_Column_Selector |
FK_Workpaper_Signoff__Signoff_Type__signoff_type_KEY | signoff_type_KEY | Workpaper_Signoff |