Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkSignatureTypeId | int identity | 4 | √ | null |
|
|
Type classification - Category or classification type for SignatureTypes records |
||||
| SignatureType | varchar | 50 | null |
|
|
Signature type name - Name of the signature type (Electronic, Digital, Biometric, etc.) |
|||||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when this signature type was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by - Reference to the user who created this signature type |
||||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
Modified date - Date when this signature type was last modified |
||||
| ModifiedBy | int | 4 | √ | null |
|
|
Modified by - Reference to the user who last modified this signature type |
||||
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deleted date - Date when this signature type was deleted (soft delete) |
||||
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by - Reference to the user who deleted this signature type |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_SignatureTypes | Primary key | Asc | pkSignatureTypeId |