Table llx user

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search

En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档可在页面上找到:Table SQL

Content/Contenu/Contenido

En verysmall.png Contains the users, together with their login and password. This is a mandatory table.

Fr verysmall.png Contient la listes des utilisateurs avec leur login et leur mot de passe. C'est une table essentielle.

Es verysmall.png Contiene la lista de usuarios con su login y su contraseña. Es una tabla esencial.

Structure

Table

Field Type Null Key Default Extra Description
rowid integer NO PRI auto_increment Technical index
entity int(11) NO 1 See page Field Multi company id. (llx_entity->rowid)
ref_ext varchar(30) NO See page Field ref_ext.
ref_int varchar(50) YES NULL
datec datetime YES NULL creation date
tms timestamp NO Current date Date of last modification. See page Field Tms.
login varchar(24) NO MUL user login
pass varchar(32) YES NULL user password
pass_crypted varchar(128) YES NULL user crypted password
pass_temp varchar(32) YES NULL temporary password when asked for forget password
civilite varchar(6) YES NULL
name varchar(50) YES NULL user name
firstname varchar(50) YES NULL user firstname
office_phone varchar(20) YES NULL office phone
office_fax varchar(20) YES NULL office fax
user_mobile varchar(20) YES NULL mobile phone
email varchar(255) YES NULL e-mail
signature text YES NULL This field contains text that is added into default suggested email when you click on a button "Send by mail" and is also used to replace tag "__SIGNATURE__" into emails templates when using mass emailing module.
admin smallint(6) YES 0 user with administrator rights?
webcal_login varchar(25) YES NULL login user for webcal
phenix_login varchar(25) YES NULL login user for phenix
phenix_pass varchar(128) YES NULL password user for phenix
module_comm smallint(6) YES 1 user with access to commercial module?
module_compta smallint(6) YES 1 user with access to financial module?
fk_societe int(11) YES MUL NULL ID of society (llx_societe->rowid)
fk_socpeople int(11) YES UNI NULL ID of contact (llx_socpeople->rowid)
fk_member int(11) YES UNI NULL ID of member (llx_adherent->rowid)
note text YES NULL comments
datelastlogin datetime YES NULL last login date
datepreviouslogin datetime YES NULL previous login date
egroupware_id int(11) YES NULL ID of egroupware
ldap_sid varchar(255) YES NULL ID of LDAP
openid varchar(255) YES NULL
statut tinyint(4) YES 1 status of user
photo varchar(255) YES NULL filename or url of photo
lang varchar(6) YES NULL user lang interface