Tables [dbo].[DOCWORKS_Signature]
Signatures applied to Documents
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_DOCWORKS_Signature: SignedByID\SignatureDTTM\DocumentIDIndexes XAK1Dockworks_SignatureDocumentIDForeign Keys FK_DOCWORKS_Signature_DocumentID_Document_DocumentID: [dbo].[Document].DocumentIDDocumentID[dbo].[uniqueid]9NOT NULLDocument UniqueID - Links to Document.DocumentiD
Cluster Primary Key PK_DOCWORKS_Signature: SignedByID\SignatureDTTM\DocumentIDSignedByID[dbo].[uniqueid]9NOT NULLUser to whom the signature belongs. Link to IDX_User.ID
Cluster Primary Key PK_DOCWORKS_Signature: SignedByID\SignatureDTTM\DocumentIDSignatureDTTMdatetime8NOT NULLDatetime of the signature
PostSignatureStatusvarchar(255)255NOT NULLDocument Status After Signing
PreSignatureStatusvarchar(255)255NULL allowedDocument Status Prior to Signing
HigherisBetterRankingint4NOT NULLSignature Authority Level
ReqHigherisBetterRankingint4NOT NULLRequired Authority Level
signaturetypevarchar(255)255NULL allowedText Indicating Signature type (ex . Author)
ZoneAbbrvarchar(32)32NULL allowedTimezone abbreviation. No longer used
Foreign Keys FK_DOCWORKS_Signature_TimeZoneID_Time_Zone_ID: [dbo].[Time_Zone].TimeZoneIDTimeZoneIDint4NULL allowedTime Zone. Link to Time_Zone.ID