Tables [dbo].[SIGNOFFS]
Documents that has been signed off.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Indexes IX_SIGNOFFS_FILECABINETFileCabinetint4NOT NULL((0))0 = Image is not in a File Cabinet. >0 = ID of file cabinet image is in (ties to File_Cabinets.code
UserCodeint4NOT NULLLink to sec_users.UserCode
SignOffDatedatetime8NOT NULLDate Image was signed off
Indexes IX_SIGNOFFS_DOCUMENTIDDocumentIDint4NOT NULLLink to Doc_Header.DocumentID or one of the dynamically created File Cabinet tables DocumentID (ie FCH0000001.DocumentID)
Primary Key PK_SIGNOFFS: SignOffIDSignOffIDint4NOT NULLKey to the SIGNOFFS table. Uses System.NextSignOffID to increment.