Table: dbo.Signoff_Role | |||
This table will be used to keep track of the different roles for a signoff | |||
Columns | |||
Name | Type | Constraints | Description |
signoff_role_KEY | int (4) | NOT NULL | Primary key |
description | nvarchar (50) | NOT NULL | Contains the different signoff roles |
Primary key | |||
Name | Columns | Description | |
PK_Signoff_Role | signoff_role_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Signoff_Role$description | description |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Signoff_Type__Signoff_Role__signoff_role_KEY | signoff_role_KEY | Signoff_Type |