| id | mediumint(8) unsigned |
|
|
|
| module | varchar(30) |
|
|
|
| field | varchar(50) |
|
|
|
| type | varchar(20) |
|
|
varchar
|
| length | varchar(10) |
|
|
|
| name | varchar(50) |
|
|
|
| control | varchar(20) |
|
|
|
| options | text |
|
|
|
| default | varchar(100) |
|
|
|
| rules | varchar(255) |
|
|
|
| placeholder | varchar(100) |
|
|
|
| canExport | enum | -- |
|
0
|
| canSearch | enum | -- |
|
0
|
| isKey | enum | -- |
|
0
|
| isValue | enum | -- |
|
0
|
| order | smallint(5) unsigned |
|
|
|
| buildin | tinyint(1) unsigned |
|
|
|
| desc | text |
|
|
|
| readonly | enum | -- |
|
0
|
| createdBy | varchar(30) |
|
|
|
| createdDate | datetime |
|
|
|
| editedBy | varchar(30) |
|
|
|
| editedDate | datetime |
|
|
|
