Table llx extrafields
Jump to navigation
Jump to search
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 |