| rowid | int(11) |
|
|
|
| ref | varchar(30) |
|
|
|
| entity | int(11) |
|
|
1
|
| tms | timestamp |
|
|
current_timestamp()
|
| fk_statut | smallint(6) |
|
|
0
|
| datedon | datetime |
|
|
2026-09-26 21:29:40.000000
|
| amount | double(24,8) |
|
|
0.00000000
|
| fk_payment | int(11) |
|
|
|
| paid | smallint(6) |
|
|
0
|
| fk_soc | int(11) |
|
|
|
| firstname | varchar(50) |
|
|
|
| lastname | varchar(50) |
|
|
|
| societe | varchar(50) |
|
|
|
| address | text |
|
|
|
| zip | varchar(30) |
|
|
|
| town | varchar(50) |
|
|
|
| country | varchar(50) |
|
|
|
| fk_country | int(11) |
|
|
|
| email | varchar(255) |
|
|
|
| phone | varchar(24) |
|
|
|
| phone_mobile | varchar(24) |
|
|
|
| public | smallint(6) |
|
|
1
|
| fk_projet | int(11) |
|
|
|
| datec | datetime |
|
|
2026-09-26 21:29:40.000000
|
| fk_user_author | int(11) |
|
|
|
| fk_user_modif | int(11) |
|
|
|
| date_valid | datetime |
|
|
2026-09-26 21:29:40.000000
|
| fk_user_valid | int(11) |
|
|
|
| note_private | text |
|
|
|
| note_public | text |
|
|
|
| model_pdf | varchar(255) |
|
|
|
| import_key | varchar(14) |
|
|
|
| extraparams | varchar(255) |
|
|
|