Table llx user: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
(Synchro avec le schema de DB présent en version 3.2)
Line 25: Line 25:
  |style="background-color: #e9e9ef"| <b>Extra</b>
  |style="background-color: #e9e9ef"| <b>Extra</b>
  |style="background-color: #e9e9ef"| <b>Description</b>
  |style="background-color: #e9e9ef"| <b>Description</b>
|-  
|-
| rowid  
| rowid
| int(11)  
| int(11)
| NO
| NO
| PRI
| PRI
|  
|  
| auto_increment  
| auto_increment
| technical index
| technical index
{{FieldEntity}}
{{FieldEntity}}
{{FieldRefExt}}
{{FieldRefExt}}
|-
| ref_int
| varchar(50)
| YES
|
| NULL
|
|
|-
|-
| datec
| datec
| datetime
| datetime
| YES  
| YES
|  
|  
| NULL  
| NULL
|  
|  
| creation date
| creation date
Line 48: Line 56:
| varchar(24)
| varchar(24)
| NO
| NO
| UNI
| MUL
|  
|  
|  
|  
Line 76: Line 84:
|  
|  
| temporary password when asked for forget password
| temporary password when asked for forget password
|-
| civilite
| varchar(6)
| YES
|
| NULL
|
|
|-
|-
| name
| name
Line 124: Line 140:
|  
|  
| e-mail
| e-mail
|-
| signature
| text
| YES
|
| NULL
|
|
|-
|-
| admin
| admin
Line 132: Line 156:
|  
|  
| user with administrator rights?
| user with administrator rights?
|-
| webcal_login
| varchar(25)
| YES
|
| NULL
|
| login user for webcal
|-
|-
| webcal_login
| webcal_login
Line 181: Line 197:
| user with access to financial module?
| user with access to financial module?
|-
|-
| fk_societe
| fk_societe
| int(11)  
| int(11)
| YES  
| YES
| MUL
| MUL
| NULL  
| NULL
|  
|  
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
|-  
|-
| fk_socpeople
| fk_socpeople
| int(11)
| int(11)
Line 196: Line 212:
|  
|  
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)  
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)  
|-  
|-
| fk_member
| fk_member
| int(11)
| int(11)
Line 211: Line 227:
| NULL
| NULL
|  
|  
| comentary
| comments
|-
|-
| datelastlogin
| datelastlogin
| datetime
| datetime
| YES  
| YES
|  
|  
| NULL  
| NULL
|  
|  
| last login date
| last login date
|-
|-
| datepreviuslogin
| datepreviouslogin
| datetime
| datetime
| YES  
| YES
|  
|  
| NULL  
| NULL
|  
|  
| previus login date
| previous login date
|-  
|-
| egroupware_id
| egroupware_id
| int(11)
| int(11)
Line 236: Line 252:
|  
|  
| ID of egroupware
| ID of egroupware
|-  
|-
| ldap_sid
| ldap_sid
| varchar(255)
| varchar(255)
Line 244: Line 260:
|  
|  
| ID of LDAP
| ID of LDAP
|-
| openid
| varchar(255)
| YES
|
| NULL
|
|
|-
|-
| statut
| statut
Line 252: Line 276:
|  
|  
| status of user
| status of user
|-  
|-
| photo
| photo
| varchar(255)
| varchar(255)
Line 260: Line 284:
|  
|  
| filename or url of photo
| filename or url of photo
|-  
|-
| lang
| lang
| varchar(6)
| varchar(6)
Line 268: Line 292:
|  
|  
| user lang interface
| user lang interface
|}&nbsp;
== Keys ==
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| <b>Key</b>
|style="background-color: #e9e9ef"| <b>Type</b>
|style="background-color: #e9e9ef"| <b>Fields</b>
|-
| PRIMARY
| PRIMARY
| rowid
|-
| uk_user_login
| UNIQUE
| login,entity
|-
| uk_user_fk_socpeople
| UNIQUE
| fk_socpeople
|-
| uk_user_fk_member
| UNIQUE
| fk_member
|-
| uk_user_fk_societe
| MULTIPLE
| fk_societe
|}&nbsp;
|}&nbsp;

Revision as of 17:21, 8 January 2013


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

Table

Field Type Null Key Default Extra Description
rowid int(11) 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
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

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_user&oldid=28362"