Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AuthenticationMethod | Unknown | 0 | null |
|
|
Authentication method - Method used to authenticate the signer |
|||||
| ID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| IPAddress | Unknown | 0 | null |
|
|
IP address - IP address from which the signature was applied |
|||||
| IsValid | Unknown | 0 | null |
|
|
Valid flag - Whether the signature is currently valid |
|||||
| SignatureTypeID | int | 4 | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|||||
| FormDesignID | int | 4 | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|||||
| Status | int | 4 | null |
|
|
Status indicator - Current operational status or state of FormSignatures records |
|||||
| Description | nvarchar | 1000 | √ | null |
|
|
Description field - Detailed description or explanation of FormSignatures information |
||||
| CreatedDate | datetime | 16,3 | null |
|
|
Date/time field - Date and time when created occurred or was recorded |
|||||
| CreatedBy | int | 4 | null |
|
|
Numeric value - Quantity, count, or numeric measurement for FormSignatures records |
|||||
| fkFormID | Unknown | 0 | null |
|
|
Form reference - Reference to the signed form |
|||||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when modified occurred or was recorded |
||||
| ModifiedBy | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for FormSignatures records |
||||
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when deleted occurred or was recorded |
||||
| DeletedBy | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for FormSignatures records |
||||
| SignatureData | Unknown | 0 | null |
|
|
Signature data - Encrypted signature information |
|||||
| SignatureDate | Unknown | 0 | null |
|
|
Signature date - Date and time when the form was signed |
|||||
| SignatureId | Unknown | 0 | null |
|
|
Primary key - FormSignatures unique identifier for each signature record |
|||||
| SignatureType | Unknown | 0 | null |
|
|
Signature type - Type of signature (Electronic, Digital, etc.) |
|||||
| SignerName | Unknown | 0 | null |
|
|
Signer name - Name of the person who signed the form |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FormDigitalSignature | Primary key | Asc | ID |