Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FieldMappings | Unknown | 0 | null |
|
|
Field mappings - Mapping of scanned fields to database fields |
|||||||||||
| FormName | Unknown | 0 | null |
|
|
Form name - Name of the scan form |
|||||||||||
| FormTemplate | Unknown | 0 | null |
|
|
Form template - Template definition for the scan form |
|||||||||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this scan form is currently available |
|||||||||||
| OCRRules | Unknown | 0 | null |
|
|
OCR rules - Rules for optical character recognition processing |
|||||||||||
| ScanFormID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||||||||
| ScanFormName | varchar | 50 | √ | null |
|
|
Name field - Descriptive name or identifier for ScanForms records |
||||||||||
| ScanFormDesc | varchar | 500 | √ | null |
|
|
Description field - Detailed description or explanation of ScanForms information |
||||||||||
| ScanFormCategory | varchar | 50 | √ | null |
|
|
Text field - ScanFormCategory text information for ScanForms records |
||||||||||
| display_sp | varchar | 50 | √ | null |
|
|
Text field - display_sp text information for ScanForms records |
||||||||||
| update_sp | varchar | 50 | √ | null |
|
|
Date/time field - Date and time when up_sp occurred or was recorded |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ScanForms__778AC167 | Primary key | Asc | ScanFormID |