| id |
int(11)
|
|
|
|
| asset_id |
int(10)
|
|
|
|
| parent_id |
int(10)
|
|
|
|
| lft |
int(11)
|
|
|
|
| rgt |
int(11)
|
|
|
|
| level |
int(10)
|
|
|
|
| path |
varchar(400)
|
utf8mb4_unicode_ci
|
|
|
| extension |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| title |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| alias |
varchar(400)
|
utf8mb4_bin
|
|
|
| note |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| description |
mediumtext
|
utf8mb4_unicode_ci
|
|
|
| published |
tinyint(4)
|
|
|
|
| checked_out |
int(10)
|
|
|
|
| checked_out_time |
datetime
|
|
|
|
| access |
int(10)
|
|
|
|
| params |
text
|
utf8mb4_unicode_ci
|
|
|
| metadesc |
varchar(1024)
|
utf8mb4_unicode_ci
|
|
|
| metakey |
varchar(1024)
|
utf8mb4_unicode_ci
|
|
|
| metadata |
varchar(2048)
|
utf8mb4_unicode_ci
|
|
|
| created_user_id |
int(10)
|
|
|
|
| created_time |
datetime
|
|
|
|
| modified_user_id |
int(10)
|
|
|
|
| modified_time |
datetime
|
|
|
|
| hits |
int(10)
|
|
|
|
| language |
char(7)
|
utf8mb4_unicode_ci
|
|
|
| version |
int(10)
|
|
|
|