This table will record all of the signoffs a particular workpaper contains. |
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. |