Table: dbo.Workpaper_Signoff
This table will record all of the signoffs a particular workpaper contains.
Columns
Name | Type | Constraints | Description
workpaper_signoff_KEY | int (4) | NOT NULL | Primary Key. This will specify one signoff for a workpaper.
workpaper_KEY | int (4) | NOT NULL | This is a foreign key to the Workpaper table. This specifies which workpaper this signoff belongs to.
signoff_date | smalldatetime (4) | NOT NULL | The date this particular signoff was made.
signoff_type_KEY | int (4) | NOT NULL | Specifies the type for this particular signoff.
staff_id | nvarchar (22) | NOT NULL | The staff id for the creator of this particular signoff record.
first_name | nvarchar (60) | NOT NULL | The first name for the creator of this particular signoff record.
last_name | nvarchar (60) | NOT NULL | The last name for the creator of this particular signoff record.

Primary key
Name | Columns | Description
PK_Workpaper_Signoff | workpaper_signoff_KEY |
Unique constraints
Name | Columns | Description
UK_Workpaper_Signoff$workpaper_KEY$signoff_type_KEY | workpaper_KEY, signoff_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Workpaper_Signoff__Signoff_Type__signoff_type_KEY | signoff_type_KEY | Signoff_Type (signoff_type_KEY) |
FK_Workpaper_Signoff__Workpaper__workpaper_KEY | workpaper_KEY | Workpaper (workpaper_KEY) |