| rowid |
int(11)
|
|
|
|
| ref |
varchar(128)
|
utf8_unicode_ci
|
|
|
| fk_soc |
int(11)
|
|
|
|
| fk_actioncomm |
int(11)
|
|
|
|
| fk_project |
int(11)
|
|
|
|
| fk_invoice |
int(11)
|
|
|
|
| email |
varchar(128)
|
utf8_unicode_ci
|
|
|
| email_company |
varchar(128)
|
utf8_unicode_ci
|
|
|
| firstname |
varchar(100)
|
utf8_unicode_ci
|
|
|
| lastname |
varchar(100)
|
utf8_unicode_ci
|
|
|
| date_subscription |
datetime
|
|
|
|
| amount |
double
|
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| date_creation |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| fk_user_creat |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| last_main_doc |
varchar(255)
|
utf8_unicode_ci
|
|
|
| ip |
varchar(250)
|
utf8_unicode_ci
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| model_pdf |
varchar(255)
|
utf8_unicode_ci
|
|
|
| status |
smallint(6)
|
|
|
|
