Table llx extrafields
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL
Content/Contenu/Contenido
Contains the extra fields.
Contient des extra champs.
Contiene los campos adicionales.
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | Technical id | |
| name | varchar(64) | NO | UNI | Name of field | ||
| entity | int(11) | NO | 1 | See page Field Multi company id. (llx_entity->rowid) | ||
| elementtype | varchar(64) | NO | For which element this extra fields is for | |||
| tms | timestamp | NO | Current date | Date of last modification. See page Field Tms. | ||
| label | varchar(64) | NO | Label of field | |||
| type | varchar(8) | NO | Type/format of field | |||
| size | int(11) | YES | NULL | Max size of field | ||
| fieldunique | int(11) | YES | NULL | 1 if field value must be unique | ||
| fieldrequired | int(11) | YES | NULL | 1 if field value is mandatory | ||
| perms | varchar(255) | YES | NULL | 1 if field value is mandatory | ||
| pos | int(11) | YES | NULL | Position of extra field among other extra field | ||
| alwayseditable | int(11) | YES | NULL | 1=The field can be edited whatever is status of object | ||
| param | text | YES | NULL | Parameters to define possible values of field | ||
| ishidden | int(11) | YES | 0 | The extra field is not visible by user |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| uk_extrafields_name | UNIQUE | name,entity,elementtype |