| rowid |
int(11)
|
|
|
|
| entity |
int(11)
|
|
|
|
| datec |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| label |
varchar(80)
|
utf8_unicode_ci
|
|
|
| fk_bank |
int(11)
|
|
|
|
| capital |
double(24,8)
|
|
|
|
| insurance_amount |
double(24,8)
|
|
|
|
| datestart |
date
|
|
|
|
| dateend |
date
|
|
|
|
| nbterm |
double
|
|
|
|
| rate |
double
|
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| capital_position |
double(24,8)
|
|
|
|
| date_position |
date
|
|
|
|
| paid |
smallint(6)
|
|
|
|
| accountancy_account_capital |
varchar(32)
|
utf8_unicode_ci
|
|
|
| accountancy_account_insurance |
varchar(32)
|
utf8_unicode_ci
|
|
|
| accountancy_account_interest |
varchar(32)
|
utf8_unicode_ci
|
|
|
| fk_projet |
int(11)
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| active |
tinyint(4)
|
|
|
|
