| rowid |
int(11)
|
|
|
|
| entity |
int(11)
|
|
|
|
| ref |
varchar(255)
|
utf8_unicode_ci
|
|
|
| asset_number |
varchar(255)
|
utf8_unicode_ci
|
|
|
| description |
text
|
utf8_unicode_ci
|
|
|
| fk_code_type_resource |
varchar(32)
|
utf8_unicode_ci
|
|
|
| address |
varchar(255)
|
utf8_unicode_ci
|
|
|
| zip |
varchar(25)
|
utf8_unicode_ci
|
|
|
| town |
varchar(50)
|
utf8_unicode_ci
|
|
|
| photo_filename |
varchar(255)
|
utf8_unicode_ci
|
|
|
| max_users |
int(11)
|
|
|
|
| phone |
varchar(30)
|
utf8_unicode_ci
|
|
|
| email |
varchar(255)
|
utf8_unicode_ci
|
|
|
| url |
varchar(255)
|
utf8_unicode_ci
|
|
|
| datec |
datetime
|
|
|
|
| date_valid |
datetime
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| fk_user_valid |
int(11)
|
|
|
|
| fk_statut |
smallint(6)
|
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
| fk_country |
int(11)
|
|
|
 Fremdschlüsselwerte ansehen
|
| fk_state |
int(11)
|
|
|
|
| tms |
timestamp
|
|
|
|
