| rowid |
int(11)
|
|
|
|
| ref |
varchar(30)
|
utf8_unicode_ci
|
|
|
| ref_ext |
varchar(255)
|
utf8_unicode_ci
|
|
|
| entity |
int(11)
|
|
|
|
| fk_user |
int(11)
|
|
|
|
| fk_user_create |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| fk_type |
int(11)
|
|
|
|
| date_create |
datetime
|
|
|
|
| description |
varchar(255)
|
utf8_unicode_ci
|
|
|
| date_debut |
date
|
|
|
|
| date_fin |
date
|
|
|
|
| halfday |
int(11)
|
|
|
|
| nb_open_day |
double(24,8)
|
|
|
|
| statut |
int(11)
|
|
|
|
| fk_validator |
int(11)
|
|
|
|
| date_valid |
datetime
|
|
|
|
| fk_user_valid |
int(11)
|
|
|
|
| date_approval |
datetime
|
|
|
|
| fk_user_approve |
int(11)
|
|
|
|
| date_refuse |
datetime
|
|
|
|
| fk_user_refuse |
int(11)
|
|
|
|
| date_cancel |
datetime
|
|
|
|
| fk_user_cancel |
int(11)
|
|
|
|
| detail_refuse |
varchar(250)
|
utf8_unicode_ci
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| tms |
timestamp
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
