| rowid |
int(11)
|
|
|
|
| ref |
varchar(255)
|
utf8_unicode_ci
|
|
|
| datec |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| entity |
int(11)
|
|
|
|
| fk_project |
int(11)
|
|
|
|
| description |
text
|
utf8_unicode_ci
|
|
|
| lieu |
varchar(64)
|
utf8_unicode_ci
|
|
|
| address |
varchar(255)
|
utf8_unicode_ci
|
|
|
| zip |
varchar(10)
|
utf8_unicode_ci
|
|
|
| town |
varchar(50)
|
utf8_unicode_ci
|
|
|
| fk_departement |
int(11)
|
|
|
|
| fk_pays |
int(11)
|
|
|
|
| phone |
varchar(30)
|
utf8_unicode_ci
|
|
|
| fax |
varchar(30)
|
utf8_unicode_ci
|
|
|
| barcode |
varchar(180)
|
utf8_unicode_ci
|
|
|
| fk_barcode_type |
int(11)
|
|
|
|
| warehouse_usage |
int(11)
|
|
|
|
| statut |
tinyint(4)
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| model_pdf |
varchar(255)
|
utf8_unicode_ci
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| fk_parent |
int(11)
|
|
|
|
