| id |
bigint(20)
|
|
|
|
| idParent |
bigint(20)
|
|
|
|
| level |
int(11)
|
|
|
|
| cacheMode |
enum('platform', 'user', 'none')
|
utf8mb4_unicode_ci
|
|
|
| itemNo |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| itemNoOrd |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| searchContext |
longtext
|
utf8mb4_unicode_ci
|
|
|
| isLocalCounting |
smallint(6)
|
|
|
|
| isExportCleanupHTML |
smallint(6)
|
|
|
|
| realTableName |
char(255)
|
utf8mb4_unicode_ci
|
|
|
| name |
char(255)
|
utf8mb4_unicode_ci
|
|
|
| descr |
longtext
|
utf8mb4_unicode_ci
|
|
|
| queryInit |
longtext
|
utf8mb4_unicode_ci
|
|
|
| query |
longtext
|
utf8mb4_unicode_ci
|
|
|
| queryFieldSelect |
longtext
|
utf8mb4_unicode_ci
|
|
|
| queryEnd |
longtext
|
utf8mb4_unicode_ci
|
|
|
| isVisible |
smallint(5)
|
|
|
|
| dependencies |
char(255)
|
utf8mb4_unicode_ci
|
|
|
| indateCreated |
bigint(20)
|
|
|
|
| indateModified |
bigint(20)
|
|
|
|
| idUserAccessCreated |
bigint(20)
|
|
|
|
| idUserAccessModified |
bigint(20)
|
|
|
|
| idLogAccess |
bigint(20)
|
|
|
|
| ord |
int(11)
|
|
|
|
| idGroups |
char(255)
|
utf8mb4_unicode_ci
|
|
|
| isTemporary |
int(11)
|
|
|
|
| isExecutable |
int(11)
|
|
|
|
| obs |
longtext
|
utf8mb4_unicode_ci
|
|
|
| template |
longtext
|
utf8mb4_unicode_ci
|
|
|
| properties |
longtext
|
utf8mb4_unicode_ci
|
|
|
| isDeleted |
smallint(6)
|
|
|
|