WebGUI assets
asset
| assetId |
varchar(22) |
NO |
PRI |
|
|
| parentId |
varchar(22) |
NO |
MUL |
|
|
| lineage |
varchar(255) |
NO |
UNI |
|
|
| state |
varchar(35) |
NO |
MUL |
|
|
| className |
varchar(255) |
NO |
MUL |
|
|
| creationDate |
bigint(20) |
NO |
|
997995720 |
|
| createdBy |
varchar(22) |
NO |
|
3 |
|
| stateChanged |
varchar(22) |
NO |
|
997995720 |
|
| stateChangedBy |
varchar(22) |
NO |
|
3 |
|
| isLockedBy |
varchar(22) |
YES |
|
|
|
| isSystem |
int(11) |
NO |
|
0 |
|
| lastExportedAs |
varchar(255) |
YES |
|
|
|
assetData
| assetId |
varchar(22) |
NO |
PRI |
|
|
| revisionDate |
bigint(20) |
NO |
PRI |
0 |
|
| revisedBy |
varchar(22) |
NO |
|
|
|
| tagId |
varchar(22) |
NO |
|
|
|
| status |
varchar(35) |
NO |
|
pending |
|
| title |
varchar(255) |
NO |
|
untitled |
|
| menuTitle |
varchar(255) |
NO |
|
untitled |
|
| url |
varchar(255) |
NO |
MUL |
|
|
| ownerUserId |
varchar(22) |
NO |
|
|
|
| groupIdView |
varchar(22) |
NO |
|
|
|
| groupIdEdit |
varchar(22) |
NO |
|
|
|
| synopsis |
text |
YES |
|
|
|
| newWindow |
int(11) |
NO |
|
0 |
|
| isHidden |
int(11) |
NO |
|
0 |
|
| isPackage |
int(11) |
NO |
|
0 |
|
| isPrototype |
int(11) |
NO |
|
0 |
|
| encryptPage |
int(11) |
NO |
|
0 |
|
| assetSize |
int(11) |
NO |
|
0 |
|
| extraHeadTags |
text |
YES |
|
|
|
| skipNotification |
int(11) |
NO |
|
0 |
|
| isExportable |
int(11) |
NO |
|
1 |
|
| inheritUrlFromParent |
int(11) |
NO |
|
0 |
|
| lastModified |
bigint(20) |
YES |
|
|
|
| extraHeadTagsPacked |
longtext |
YES |
|
|
|
| usePackedHeadTags |
int(1) |
YES |
|
|
|