SignatureInitials


Description

Digital signature initials managing electronic initials and signature metadata for form submissions and document authentication. This table stores signature initials including form submission associations, signature types, creation tracking, and deletion audit trails to support electronic signature workflows, document validation, and compliance with digital signature requirements for healthcare documentation.

Columns

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

Primary key - Unique identifier for each signature initials record
FormSubmissionId int 4 √ null

Form submission reference - Links to the form submission that was signed with these initials
SignatureTypeId int 4 null

Signature type reference - Links to SignatureTypes table for the type of signature
DateCreated datetime 16,3 √ null

Creation date - Date when the signature initials were created
CreatedBy int 4 √ null

Created by user - UserID of the person who created the signature initials
DeletedBy int 4 √ null

Deleted by user - UserID of the person who deleted the signature initials
DeletedDate datetime 16,3 √ null

Deletion date - Date when the signature initials were deleted
Initials ntext 1073741823 √ null

Initials data - Text or encoded data representing the user’s initials

Indexes

Constraint Name Type Sort Column(s)
PK__Signatur__3214EC27E74CD898 Primary key Asc ID

Relationships

Close relationships within degrees of separation