Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ID | INT | 10 | √ | null |
|
|
||||
| Form | INT | 10 | null |
|
|
|||||
| Name | VARCHAR | 200 | null |
|
|
|||||
| Sort | INT | 10 | null |
|
|
|||||
| NoBreak | INT | 10 | null |
|
|
|||||
| FType | INT | 10 | null |
|
|
|||||
| Section | VARCHAR | 30 | null |
|
|
|||||
| UnEditable | INT | 10 | null |
|
|
|||||
| Collapsed | INT | 10 | null |
|
|
|||||
| Fill | TEXT | 65535 | null |
|
|
|||||
| LtGuid | VARCHAR | 36 | null |
|
|
|||||
| IsPassword | BIT | 1 | 0 |
|
|
|||||
| IsEncrypted | BIT | 1 | 0 |
|
|
|||||
| IsHidden | BIT | 1 | 0 |
|
|
|||||
| IsRestricted | BIT | 1 | 0 |
|
|
|||||
| ViewPermissions | VARCHAR | 1028 | √ | null |
|
|
||||
| EditPermissions | VARCHAR | 1028 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | ID |
| LtGuid | Performance | Asc | LtGuid |
| Names | Must be unique | Asc/Asc | Form + Name |
| Section_idx | Performance | Asc | Section |
| Sort | Performance | Asc | Sort |
Relationships
Close relationships within degrees of separation
