| 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 | |