Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
|||||||||||
| language_id | VARCHAR | 36 | √ | null |
|
|
||||||||||
| customform_id | VARCHAR | 36 | √ | null |
|
|
||||||||||
| sort | INT | 10 | null |
|
|
|||||||||||
| field | VARCHAR | 255 | null |
|
|
|||||||||||
| fieldTitle | VARCHAR | 255 | √ | null |
|
|
||||||||||
| fieldType | VARCHAR | 255 | √ | null |
|
|
||||||||||
| readonly | BIT | 1 | null |
|
|
|||||||||||
| collectionGroup | VARCHAR | 255 | √ | null |
|
|
||||||||||
| customValue | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| valueOptions | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| requiredField | BIT | 1 | null |
|
|
|||||||||||
| uniqField | BIT | 1 | null |
|
|
|||||||||||
| requiredFieldErrorCustomMessage | VARCHAR | 255 | √ | null |
|
|
||||||||||
| uniqFieldErrorCustomMessage | VARCHAR | 255 | √ | null |
|
|
||||||||||
| validationExpression | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| validationErrorCustomMessage | VARCHAR | 255 | √ | null |
|
|
||||||||||
| clientChangeEvent | VARCHAR | 255 | √ | null |
|
|
||||||||||
| serverChangeEvent | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| cssRule | VARCHAR | 255 | √ | null |
|
|
||||||||||
| cssInlineStyle | VARCHAR | 255 | √ | null |
|
|
||||||||||
| entityTwigFilter | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| entityDqlFilter | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| requiredFieldByCondition | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| visibleFieldByCondition | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| canAddItem | BIT | 1 | null |
|
|
|||||||||||
| canRemoveItem | BIT | 1 | null |
|
|
|||||||||||
| collectionDqlFilter | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| collectionTwigFilter | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| hint | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| ident | VARCHAR | 255 | √ | null |
|
|
||||||||||
| clientChangeAction | VARCHAR | 255 | √ | null |
|
|
||||||||||
| serverChangeAction | VARCHAR | 255 | √ | null |
|
|
||||||||||
| additionalLabelClass | VARCHAR | 255 | √ | null |
|
|
||||||||||
| additionalInputFieldClass | VARCHAR | 255 | √ | null |
|
|
||||||||||
| overridenRowClass | VARCHAR | 255 | √ | null |
|
|
||||||||||
| overridenLabelClass | VARCHAR | 255 | √ | null |
|
|
||||||||||
| overridenInputFieldClass | VARCHAR | 255 | √ | null |
|
|
||||||||||
| entitySortBy | VARCHAR | 255 | √ | null |
|
|
||||||||||
| entitySortDirection | VARCHAR | 255 | √ | null |
|
|
||||||||||
| dqlValueOptions | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| createdByUser_id | INT | 10 | √ | null |
|
|
||||||||||
| fieldTypeParameter | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| allowedUploadExtensions | VARCHAR | 255 | √ | null |
|
|
||||||||||
| addFieldByCondition | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| readonlyFieldByCondition | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| htmlAttributes | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| overridedEntityDqlFilter | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| searchOperator | VARCHAR | 20 | √ | null |
|
|
||||||||||
| gridGroupingOperator | VARCHAR | 20 | √ | null |
|
|
||||||||||
| singleItemCollectionGroup | VARCHAR | 255 | √ | null |
|
|
||||||||||
| logAction | BIT | 1 | null |
|
|
|||||||||||
| searchHtml | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||
| inverseCollectionGroup | BIT | 1 | null |
|
|
|||||||||||
| useAsTemplate | BIT | 1 | null |
|
|
|||||||||||
| removeItemAdditionalCondition | VARCHAR | 255 | √ | null |
|
|
||||||||||
| groupingOperator | VARCHAR | 20 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| ident_idx | Performance | Asc | ident |
| IDX_59E3935082F1BAF4 | Performance | Asc | language_id |
| IDX_59E393509268A8FA | Performance | Asc | customform_id |
| IDX_59E39350E1F44B34 | Performance | Asc | createdByUser_id |