FormSignatures


Description

Form signature configurations managing digital signature requirements and settings for electronic forms with attestation and validation controls. This table defines signature requirements, signature types, attestation content, and validation rules for forms to support electronic signature compliance, document integrity, and regulatory 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 form signature configuration
SignatureTypeID int 4 null
SignatureTypes.pkSignatureTypeId FK_FormDigitalSignatures_SignatureTypes R

Signature type reference - Links to SignatureTypes table for the type of signature required
FormDesignID int 4 null
FormDesigns.ID FK_FormDigitalSignatures_FormDesigns R

Form design reference - Links to form design that requires this signature
Status int 4 null

Configuration status - Status of the signature configuration (Active, Inactive, etc.)
Description nvarchar 1000 √ null

Signature description - Description of the signature requirement and purpose
CreatedDate datetime 16,3 null

Creation date - Date when the signature configuration was created
CreatedBy int 4 null

Created by user - UserID of the person who created this configuration
ModifiedDate datetime 16,3 √ null

Last modification date - Date when the configuration was last modified
ModifiedBy int 4 √ null

Modified by user - UserID of the person who last modified this configuration
DeletedDate datetime 16,3 √ null

Deletion date - Date when the configuration was deleted (soft delete)
DeletedBy int 4 √ null

Deleted by user - UserID of the person who deleted this configuration
IsHideTypeSignature bit 1 ((0))

Hide signature type - Boolean flag to hide the signature type from users
IsRememberSignature bit 1 ((0))

Remember signature - Boolean flag to remember user’s signature for future use
Order int 4 √ null

Display order - Order in which signature appears on the form
RequiredBeforeSaving bit 1 ((0))

Required before save - Boolean flag indicating signature is required before form can be saved
HideSignature bit 1 ((0))

Hide signature - Boolean flag to hide the signature field from display
RequireAttestation bit 1 ((0))

Require attestation - Boolean flag indicating attestation is required with signature
AttestationContent varchar 2147483647 √ null

Attestation content - Text content for attestation statement that user must agree to
ShowSignatureWarning bit 1 ((0))

Show warning - Boolean flag to display warning messages about signature requirements
ForceSignMissingSignature bit 1 ((0))

Force missing signature - Boolean flag to force signature when missing
OnlySignCreatedForm bit 1 √ null

Only sign created forms - Boolean flag to allow signatures only on newly created forms
Initials bit 1 √ null

Allow initials - Boolean flag to allow initials instead of full signature

Indexes

Constraint Name Type Sort Column(s)
PK_FormDigitalSignature Primary key Asc ID
IX_FormSignatures_FormDesignID_SignatureTypeID Performance Asc/Asc/Asc FormDesignID + SignatureTypeID + DeletedDate

Relationships

Close relationships within degrees of separation