Table llx user: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
m (→‎Table: some fields have been updated)
Line 7: Line 7:
[[Category:Básico]]
[[Category:Básico]]
{{ListOfTables}}
{{ListOfTables}}
= Content/Contenu/Contenido =
=Content/Contenu/Contenido=


{{flag_en}} Contains the users, together with their login and password. This is a mandatory table.
{{flag_en}}
Contains the users, together with their login and password. This is a mandatory table.


{{flag_fr}} Contient la listes des utilisateurs avec leur login et leur mot de passe. C'est une table essentielle.
{{flag_fr}}
Contient la listes des utilisateurs avec leur login et leur mot de passe. C'est une table essentielle.


{{flag_sp}} Contiene la lista de usuarios con su login y su contraseña. Es una tabla esencial.
{{flag_sp}}
Contiene la lista de usuarios con su login y su contraseña. Es una tabla esencial.


= Structure =
=Structure=
== Table ==
==Table==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
  |style="background-color: #e9e9ef"| <b>Field</b>
  | style="background-color: #e9e9ef" |<b>Field</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
  | style="background-color: #e9e9ef" |<b>Type</b>
  |style="background-color: #e9e9ef"| <b>Null</b>
  | style="background-color: #e9e9ef" |<b>Null</b>
  |style="background-color: #e9e9ef"| <b>Key</b>
  | style="background-color: #e9e9ef" |<b>Key</b>
  |style="background-color: #e9e9ef"| <b>Default</b>
  | style="background-color: #e9e9ef" |<b>Default</b>
  |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>
{{FieldRowid}}
{{FieldRowid}}
{{FieldEntity}}
{{FieldEntity}}
{{FieldRefExt}}
{{FieldRefExt}}
|-
|-
| ref_int
|ref_int
| varchar(50)
|varchar(50)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
|  
|
|-
|-
| datec
|datec
| datetime
|datetime
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| creation date
|creation date
{{FieldTms}}
{{FieldTms}}
|-
|-
| login
|login
| varchar(24)
|varchar(24)
| NO
|NO
| MUL
|MUL
|  
|
|  
|
| user login
|user login
|-
|-
| pass
|pass
| varchar(32)
|varchar(32)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| user password
|user password
|-
|-
| pass_crypted
|pass_crypted
| varchar(128)
|varchar(128)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| user crypted password
|user crypted password
|-
|-
| pass_temp
|pass_temp
| varchar(32)
|varchar(32)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| temporary password when asked for forget password
|temporary password when asked for forget password
|-
|-
| civilite
|civilite
| varchar(6)
|varchar(6)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
|  
|
|-
|-
| name
|lastname
| varchar(50)
|varchar(50)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| user name
|user name (field updated to lastname instead of name)
|-
|-
| firstname
|firstname
| varchar(50)
|varchar(50)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| user firstname
|user firstname
|-
|-
| office_phone
|office_phone
| varchar(20)
|varchar(20)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| office phone
|office phone
|-
|-
| office_fax
|office_fax
| varchar(20)
|varchar(20)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| office fax
|office fax
|-
|-
| user_mobile
|user_mobile
| varchar(20)
|varchar(20)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| mobile phone
|mobile phone
|-
|-
| email
|email
| varchar(255)
|varchar(255)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| e-mail
|e-mail
|-
|-
| signature
|signature
| text
|text
| YES
|YES
|  
|
| NULL
|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.
|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
|admin
| smallint(6)
|smallint(6)
| YES
|YES
|  
|
| 0
|0
|  
|
| user with administrator rights?
|user with administrator rights?
|-
|-
| webcal_login
|webcal_login
| varchar(25)
|varchar(25)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| login user for webcal
|login user for webcal
|-
|-
| phenix_login
|phenix_login
| varchar(25)
|varchar(25)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| login user for phenix
|login user for phenix
|-
|-
| phenix_pass
|phenix_pass
| varchar(128)
|varchar(128)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| password user for phenix
|password user for phenix
|-
|-
| module_comm
|module_comm
| smallint(6)
|smallint(6)
| YES
|YES
|  
|
| 1
|1
|  
|
| user with access to commercial module?
|user with access to commercial module?
|-
|-
| module_compta
|module_compta
| smallint(6)
|smallint(6)
| YES
|YES
|  
|
| 1
|1
|  
|
| 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)
| YES
|YES
| UNI
|UNI
| NULL
|NULL
|  
|
| 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)
| YES
|YES
| UNI
|UNI
| NULL
|NULL
|  
|
| ID of member ([[Table_llx_adherent|llx_adherent]]->rowid)  
|ID of member ([[Table_llx_adherent|llx_adherent]]->rowid)
|-
|-
| note
|note
| text
|text
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| comments
|comments
|-
|-
| datelastlogin
|datelastlogin
| datetime
|datetime
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| last login date
|last login date
|-
|-
| datepreviouslogin
|datepreviouslogin
| datetime
|datetime
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| previous login date
|previous login date
|-
|-
| egroupware_id
|egroupware_id
| int(11)
|int(11)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| ID of egroupware
|ID of egroupware
|-
|-
| ldap_sid
|ldap_sid
| varchar(255)
|varchar(255)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| ID of LDAP
|ID of LDAP
|-
|-
| openid
|openid
| varchar(255)
|varchar(255)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
|  
|
|-
|-
| statut
|statut
| tinyint(4)
|tinyint(4)
| YES
|YES
|  
|
| 1
|1
|  
|
| status of user
|status of user
|-
|-
| photo
|photo
| varchar(255)
|varchar(255)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| filename or url of photo
|filename or url of photo
|-
|-
| lang
|lang
| varchar(6)
|varchar(6)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| user lang interface
|user lang interface
|}&nbsp;
|}&nbsp;

Revision as of 13:40, 31 December 2020


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 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
lastname varchar(50) YES NULL user name (field updated to lastname instead of 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

 

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