| rowid |
int(11)
|
|
|
|
| entity |
int(11)
|
|
|
|
| ref_employee |
varchar(50)
|
utf8_unicode_ci
|
|
|
| ref_ext |
varchar(50)
|
utf8_unicode_ci
|
|
|
| admin |
smallint(6)
|
|
|
|
| employee |
tinyint(4)
|
|
|
|
| fk_establishment |
int(11)
|
|
|
|
| datec |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| fk_user_creat |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| login |
varchar(50)
|
utf8_unicode_ci
|
|
|
| pass_encoding |
varchar(24)
|
utf8_unicode_ci
|
|
|
| pass |
varchar(128)
|
utf8_unicode_ci
|
|
|
| pass_crypted |
varchar(128)
|
utf8_unicode_ci
|
|
|
| pass_temp |
varchar(128)
|
utf8_unicode_ci
|
|
|
| api_key |
varchar(128)
|
utf8_unicode_ci
|
|
|
| gender |
varchar(10)
|
utf8_unicode_ci
|
|
|
| civility |
varchar(6)
|
utf8_unicode_ci
|
|
|
| lastname |
varchar(50)
|
utf8_unicode_ci
|
|
|
| firstname |
varchar(50)
|
utf8_unicode_ci
|
|
|
| address |
varchar(255)
|
utf8_unicode_ci
|
|
|
| zip |
varchar(25)
|
utf8_unicode_ci
|
|
|
| town |
varchar(50)
|
utf8_unicode_ci
|
|
|
| fk_state |
int(11)
|
|
|
|
| fk_country |
int(11)
|
|
|
|
| birth |
date
|
|
|
|
| birth_place |
varchar(64)
|
utf8_unicode_ci
|
|
|
| job |
varchar(128)
|
utf8_unicode_ci
|
|
|
| office_phone |
varchar(30)
|
utf8_unicode_ci
|
|
|
| office_fax |
varchar(30)
|
utf8_unicode_ci
|
|
|
| user_mobile |
varchar(30)
|
utf8_unicode_ci
|
|
|
| personal_mobile |
varchar(30)
|
utf8_unicode_ci
|
|
|
| email |
varchar(255)
|
utf8_unicode_ci
|
|
|
| personal_email |
varchar(255)
|
utf8_unicode_ci
|
|
|
| email_oauth2 |
varchar(255)
|
utf8_unicode_ci
|
|
|
| signature |
longtext
|
utf8_unicode_ci
|
|
|
| socialnetworks |
text
|
utf8_unicode_ci
|
|
|
| fk_soc |
int(11)
|
|
|
|
| fk_socpeople |
int(11)
|
|
|
|
| fk_member |
int(11)
|
|
|
|
| fk_user |
int(11)
|
|
|
|
| fk_user_expense_validator |
int(11)
|
|
|
|
| fk_user_holiday_validator |
int(11)
|
|
|
|
| national_registration_number |
varchar(50)
|
utf8_unicode_ci
|
|
|
| idpers1 |
varchar(128)
|
utf8_unicode_ci
|
|
|
| idpers2 |
varchar(128)
|
utf8_unicode_ci
|
|
|
| idpers3 |
varchar(128)
|
utf8_unicode_ci
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| model_pdf |
varchar(255)
|
utf8_unicode_ci
|
|
|
| last_main_doc |
varchar(255)
|
utf8_unicode_ci
|
|
|
| datelastlogin |
datetime
|
|
|
|
| datepreviouslogin |
datetime
|
|
|
|
| datelastpassvalidation |
datetime
|
|
|
|
| datestartvalidity |
datetime
|
|
|
|
| dateendvalidity |
datetime
|
|
|
|
| flagdelsessionsbefore |
datetime
|
|
|
|
| iplastlogin |
varchar(250)
|
utf8_unicode_ci
|
|
|
| ippreviouslogin |
varchar(250)
|
utf8_unicode_ci
|
|
|
| ldap_sid |
varchar(255)
|
utf8_unicode_ci
|
|
|
| openid |
varchar(255)
|
utf8_unicode_ci
|
|
|
| statut |
tinyint(4)
|
|
|
|
| photo |
varchar(255)
|
utf8_unicode_ci
|
|
|
| lang |
varchar(6)
|
utf8_unicode_ci
|
|
|
| color |
varchar(6)
|
utf8_unicode_ci
|
|
|
| barcode |
varchar(255)
|
utf8_unicode_ci
|
|
|
| fk_barcode_type |
int(11)
|
|
|
|
| accountancy_code_user_general |
varchar(32)
|
utf8_unicode_ci
|
|
|
| accountancy_code |
varchar(32)
|
utf8_unicode_ci
|
|
|
| nb_holiday |
int(11)
|
|
|
|
| thm |
double(24,8)
|
|
|
|
| tjm |
double(24,8)
|
|
|
|
| access_hours |
varchar(128)
|
utf8_unicode_ci
|
|
|
| salary |
double(24,8)
|
|
|
|
| salaryextra |
double(24,8)
|
|
|
|
| dateemployment |
date
|
|
|
|
| dateemploymentend |
date
|
|
|
|
| weeklyhours |
double(16,8)
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| default_range |
int(11)
|
|
|
|
| default_c_exp_tax_cat |
int(11)
|
|
|
|
| fk_warehouse |
int(11)
|
|
|
|
