DocumentSigns


Description

Document digital signatures tracking digital signatures applied to documents for approval and authentication. This table manages document signing with user tracking and date stamps to support document approval workflows, electronic signatures, and audit trails for healthcare document management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkDocSignID int identity 4 √ null

Primary key - Unique identifier for each document signature
fkDocumentID int 4 null
documents.docID FK_DocumentSigns_documents R

Document reference - Links to documents table for the signed document
fkUserID int 4 null
AccessUser.UserID FK_DocumentSigns_AccessUser R

User reference - Links to AccessUser table for the person who signed
DateSigned smalldatetime 16 (getdate())

Signature date - Date and time when the document was signed
pkDocumentSignID Unknown 0 null

Primary key - Unique identifier for each document signature
SignatureDate Unknown 0 null

Signature date - Date and time when the document was signed
SignatureType Unknown 0 null

Signature type - Type of signature (Electronic, Digital, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK_DocumentSigns Primary key Asc pkDocSignID

Relationships

Close relationships within degrees of separation