Dolibarr ERP CRM Wiki

Table llx user: Difference between revisions

Page

Table llx user (view source)

Revision as of 07:11, 21 September 2009

2,265 bytes added ,  17 years ago
→‎Structure
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
|}
|}
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/15816"