Table llx user: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
Line 32: Line 32:
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
| datec
| datetime
| YES
|
| NULL
|
| creation date
|-
| tms
| timestamp
| YES
|
| CURRENT_TIMESTAMP
|
| last update date
|-
| login
| varchar(24)
| NO
|
|
|
| user login
|-
| entity
| int(11)
|  
|
| 1
|
| multi company id
|-
| 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
|-
| 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
|-
| admin
| smallint(6)
| YES
|
| 0
|
| user with administrator rights?
|-
| webcal_login
| varchar(25)
| YES
|
| NULL
|
| login user for webcal
|-
| 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_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
|
| NULL
|
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
|-
| fk_socpeople
| int(11)
| YES
|
| NULL
|
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)
|-
| fk_member
| int(11)
| YES
|
| NULL
|
| ID of member ([[Table_llx_adherent|llx_adherent]]->rowid)
|-
| note
| text
| YES
|
| NULL
|
| comentary
|-
| datelastlogin
| datetime
| YES
|
| NULL
|
| last login date
|-
| datepreviuslogin
| datetime
| YES
|
| NULL
|
| previus login date
|-
| egroupware_id
| int(11)
| YES
|
| NULL
|
| ID of egroupware
|-
| ldap_sid
| varchar(255)
| YES
|
| NULL
|
| ID of LDAP
|-
| statut
| tinyint(4)
| YES
|
| 1
|
| status of user
|-
| lang
| varchar(6)
| YES
|
| NULL
|
| user lang interface
|}
|}

Revision as of 07:11, 21 September 2009


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

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png

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

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
datec datetime YES NULL creation date
tms timestamp YES CURRENT_TIMESTAMP last update date
login varchar(24) NO user login
entity int(11)   1 multi company id
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
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
admin smallint(6) YES 0 user with administrator rights?
webcal_login varchar(25) YES NULL login user for webcal
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_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 NULL ID of society (llx_societe->rowid)
fk_socpeople int(11) YES NULL ID of contact (llx_socpeople->rowid)
fk_member int(11) YES NULL ID of member (llx_adherent->rowid)
note text YES NULL comentary
datelastlogin datetime YES NULL last login date
datepreviuslogin datetime YES NULL previus login date
egroupware_id int(11) YES NULL ID of egroupware
ldap_sid varchar(255) YES NULL ID of LDAP
statut tinyint(4) YES 1 status of user
lang varchar(6) YES NULL user lang interface
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_user&oldid=15816"