Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| DefaultValue | Unknown | 0 | null |
|
|
Default value - Default value assigned to the field |
|||||
| FieldDesc | varchar | 200 | √ | null |
|
|
Description field - Detailed description or explanation of Fields information |
||||
| FieldID | Unknown | 0 | null |
|
|
Primary key - Fields unique identifier for each field definition |
|||||
| FieldName | varchar | 50 | √ | null |
|
|
Field name - Name of the data field |
||||
| FieldSize | Unknown | 0 | null |
|
|
Field size - Maximum size or length of the field |
|||||
| FieldType | Unknown | 0 | null |
|
|
Field type - Data type of the field (Text, Number, Date, etc.) |
|||||
| IsRequired | Unknown | 0 | null |
|
|
Required flag - Whether this field is mandatory |
|||||
| pkFieldID | int identity | 4 | √ | null |
|
|
Primary key - Fields unique identifier for each record |
||||
| ValidationRules | Unknown | 0 | null |
|
|
Validation rules - Business rules for field validation |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Fields | Primary key | Asc | pkFieldID |