36
edits
Table llx user: Difference between revisions
Synchro avec le schema de DB présent en version 3.2
(→Table) |
(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 | ||
| | | 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 | | 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 | ||
| | | | ||
| | | comments | ||
|- | |- | ||
| datelastlogin | | datelastlogin | ||
| datetime | | datetime | ||
| YES | | YES | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| last login date | | last login date | ||
|- | |- | ||
| | | datepreviouslogin | ||
| datetime | | datetime | ||
| YES | | YES | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| | | 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 | ||
|} | |} | ||