Table llx user: Difference between revisions

Jump to navigation Jump to search

Table llx user (view source)

Revision as of 13:40, 31 December 2020

176 bytes removed ,  5 years ago
m
→‎Table: some fields have been updated
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;
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/49266"

Navigation menu