|
rowid
|
int
|
|
|
|
|
ref
|
varchar(30)
|
|
|
|
|
tms
|
timestamp
|
|
|
CURRENT_TIMESTAMP
|
|
datec
|
datetime
|
|
|
|
|
fk_user
|
int
|
|
|
|
|
datep
|
date
|
|
|
|
|
datev
|
date
|
|
|
|
|
salary
|
double(24,8)
|
|
|
|
|
amount
|
double(24,8)
|
|
|
0.00000000
|
|
fk_projet
|
int
|
|
|
|
|
fk_typepayment
|
int
|
|
|
|
|
num_payment
|
varchar(50)
|
|
|
|
|
label
|
varchar(255)
|
|
|
|
|
datesp
|
date
|
|
|
|
|
dateep
|
date
|
|
|
|
|
entity
|
int
|
|
|
1
|
|
note
|
text
|
|
|
|
|
fk_bank
|
int
|
|
|
|
|
fk_user_author
|
int
|
|
|
|
|
fk_user_modif
|
int
|
|
|
|