Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FieldName | Unknown | 0 | null |
|
|
Field name - Name of the user field |
||
| formatID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| formatDescrip | varchar | 50 | √ | null |
|
|
Description field - Detailed description or explanation of UserFieldFormat information |
|
| FormatPattern | Unknown | 0 | null |
|
|
Format pattern - Pattern or template for formatting |
||
| FormatType | Unknown | 0 | null |
|
|
Format type - Type of formatting (Date, Currency, etc.) |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this format is currently applied |
||
| ValidationRules | Unknown | 0 | null |
|
|
Validation rules - Rules for validating field input |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__UserFieldFormat__6BB9E75F | Primary key | Asc | formatID |