FormSignatures

Certificate information - Digital certificate data for certificate-based signatures

Primary key - Unique identifier for each form signature, auto-incrementing integer

Signature type reference - Reference to signature type configuration

Form design reference - Reference to the form design requiring this signature

Signature status - Current status of the signature configuration

Signature description - Description of the signature requirement or purpose

Creation timestamp - When the signature configuration was created

Creator user ID - Reference to user who created the signature configuration

Deletion timestamp - When the signature configuration was deleted

Deletion user - User who deleted the signature configuration

Submission reference - Reference to the form submission being signed

Location data - GPS coordinates where signature was captured

Modification timestamp - When the signature configuration was last modified

Modifier user ID - Reference to user who last modified the signature configuration

Remember signature flag - Boolean indicating if signature should be remembered

Hide type signature - Boolean indicating if typed signatures should be hidden

Verification status - Boolean indicating if signature has been verified

Signature order - Order in which this signature should be collected

Required before saving - Boolean indicating if signature is required before saving

Hide signature flag - Boolean indicating if signature should be hidden in display

Require attestation flag - Boolean indicating if attestation is required

Attestation content - Content of attestation statement for the signature

Show warning flag - Boolean indicating if signature warnings should be displayed

Force sign flag - Boolean indicating if missing signatures should be forced

Sign created form only - Boolean indicating if signature applies only to created forms

Initials requirement - Boolean indicating if initials are required

IP address - Network IP address from which signature was captured

Digital signature - Encoded digital signature data

Signature timestamp - When the signature was captured

Signature type - Type of digital signature (Electronic, Biometric, Certificate-based)

Signer email - Email address of the signer for verification

Signer name - Name of the person who provided the signature

Signer role - Role or title of the person signing the form

User agent - Browser or device information for audit purposes

Verification timestamp - When the signature was verified