| rowid |
int(11)
|
|
|
|
| ref |
varchar(30)
|
utf8_unicode_ci
|
|
|
| entity |
int(11)
|
|
|
|
| ref_ext |
varchar(128)
|
utf8_unicode_ci
|
|
|
| gender |
varchar(10)
|
utf8_unicode_ci
|
|
|
| civility |
varchar(6)
|
utf8_unicode_ci
|
|
|
| lastname |
varchar(50)
|
utf8_unicode_ci
|
|
|
| firstname |
varchar(50)
|
utf8_unicode_ci
|
|
|
| login |
varchar(50)
|
utf8_unicode_ci
|
|
|
| pass |
varchar(50)
|
utf8_unicode_ci
|
|
|
| pass_crypted |
varchar(128)
|
utf8_unicode_ci
|
|
|
| fk_adherent_type |
int(11)
|
|
|
 Fremdschlüsselwerte ansehen
|
| morphy |
varchar(3)
|
utf8_unicode_ci
|
|
|
| societe |
varchar(128)
|
utf8_unicode_ci
|
|
|
| fk_soc |
int(11)
|
|
|
|
| address |
text
|
utf8_unicode_ci
|
|
|
| zip |
varchar(30)
|
utf8_unicode_ci
|
|
|
| town |
varchar(50)
|
utf8_unicode_ci
|
|
|
| state_id |
int(11)
|
|
|
|
| country |
int(11)
|
|
|
|
| email |
varchar(255)
|
utf8_unicode_ci
|
|
|
| url |
varchar(255)
|
utf8_unicode_ci
|
|
|
| socialnetworks |
text
|
utf8_unicode_ci
|
|
|
| phone |
varchar(30)
|
utf8_unicode_ci
|
|
|
| phone_perso |
varchar(30)
|
utf8_unicode_ci
|
|
|
| phone_mobile |
varchar(30)
|
utf8_unicode_ci
|
|
|
| birth |
date
|
|
|
|
| birth_place |
varchar(64)
|
utf8_unicode_ci
|
|
|
| photo |
varchar(255)
|
utf8_unicode_ci
|
|
|
| statut |
smallint(6)
|
|
|
|
| public |
smallint(6)
|
|
|
|
| datefin |
datetime
|
|
|
|
| default_lang |
varchar(6)
|
utf8_unicode_ci
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| model_pdf |
varchar(255)
|
utf8_unicode_ci
|
|
|
| datevalid |
datetime
|
|
|
|
| datec |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_mod |
int(11)
|
|
|
|
| fk_user_valid |
int(11)
|
|
|
|
| canvas |
varchar(32)
|
utf8_unicode_ci
|
|
|
| ip |
varchar(250)
|
utf8_unicode_ci
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
