Table: dbo.Workpaper_Signoff
This table will record all of the signoffs a particular workpaper contains.
Columns
NameTypeConstraintsDescription
workpaper_signoff_KEYint (4)NOT NULLPrimary Key. This will specify one signoff for a workpaper.
workpaper_KEYint (4)NOT NULLThis is a foreign key to the Workpaper table. This specifies which workpaper this signoff belongs to.
signoff_datesmalldatetime (4)NOT NULLThe date this particular signoff was made.
signoff_type_KEYint (4)NOT NULLSpecifies the type for this particular signoff.
staff_idnvarchar (22)NOT NULLThe staff id for the creator of this particular signoff record.
first_namenvarchar (60)NOT NULLThe first name for the creator of this particular signoff record.
last_namenvarchar (60)NOT NULLThe last name for the creator of this particular signoff record.
Primary key
NameColumnsDescription
PK_Workpaper_Signoffworkpaper_signoff_KEY
Unique constraints
NameColumnsDescription
UK_Workpaper_Signoff$workpaper_KEY$signoff_type_KEYworkpaper_KEY, signoff_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Workpaper_Signoff__Signoff_Type__signoff_type_KEYsignoff_type_KEYSignoff_Type (signoff_type_KEY)
FK_Workpaper_Signoff__Workpaper__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)

Schema diagram