31,028
edits
Table llx extrafields: Difference between revisions
Jump to navigation
Jump to search
no edit summary
m (moved Table llx extra fields to Table llx extrafields) |
No edit summary |
||
| Line 27: | Line 27: | ||
| | | | ||
| auto_increment | | auto_increment | ||
| | | Technical id | ||
|- | |||
| name | |||
| varchar(64) | |||
| NO | |||
| UNI | |||
| | |||
| | |||
| Name of field | |||
|- | |- | ||
| entity | | entity | ||
| Line 38: | Line 45: | ||
| multi company id | | multi company id | ||
|- | |- | ||
| | | elementtype | ||
| varchar(64) | | varchar(64) | ||
| NO | | NO | ||
| Line 44: | Line 51: | ||
| | | | ||
| | | | ||
| | | For which element this extra fields is for | ||
{{FieldTms}} | |||
|- | |- | ||
| | | label | ||
| varchar(64) | | varchar(64) | ||
| NO | | NO | ||
| | | | ||
| | | | ||
| | | | ||
| | | Label of field | ||
|- | |- | ||
| | | type | ||
| varchar( | | varchar(8) | ||
| NO | | NO | ||
| | | | ||
| | | | ||
| | | | ||
| | | Type/format of field | ||
|- | |- | ||
| | | size | ||
| | | int(11) | ||
| | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| | | Max size of field | ||
|- | |- | ||
| | | fieldunique | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| Line 84: | Line 84: | ||
| NULL | | NULL | ||
| | | | ||
| | | 1 if field value must be unique | ||
|- | |- | ||
| | | fieldrequired | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| Line 92: | Line 92: | ||
| NULL | | NULL | ||
| | | | ||
| | | 1 if field value is mandatory | ||
|- | |||
| perms | |||
| varchar(255) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| 1 if field value is mandatory | |||
|- | |- | ||
| | | pos | ||
| | | int(11) | ||
| YES | | YES | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| | | Position of extra field among other extra field | ||
|- | |- | ||
| | | alwayseditable | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| Line 108: | Line 116: | ||
| NULL | | NULL | ||
| | | | ||
| 1=The field can be edited whatever is status of object | |||
|- | |||
| param | |||
| text | |||
| YES | |||
| | | | ||
| NULL | |||
| | |||
| Parameters to define possible values of field | |||
|- | |- | ||
| ishidden | | ishidden | ||
| Line 116: | Line 132: | ||
| 0 | | 0 | ||
| | | | ||
| | | The extra field is not visible by user | ||
|} | |} | ||