+---------------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+--------------+------+-----+-------------------+----------------+
| rowid | int(11) | NO | PRI | NULL | auto_increment |
| datec | datetime | YES | | NULL | |
| tms | timestamp | NO | | CURRENT_TIMESTAMP | |
| fk_soc | int(11) | YES | MUL | NULL | |
| civilite | varchar(6) | YES | | NULL | |
| name | varchar(50) | YES | | NULL | |
| firstname | varchar(50) | YES | | NULL | |
| address | varchar(255) | YES | | NULL | |
| cp | varchar(25) | YES | | NULL | |
| ville | varchar(255) | YES | | NULL | |
| fk_pays | int(11) | YES | | 0 | |
| birthday | date | YES | | NULL | |
| poste | varchar(80) | YES | | NULL | |
| phone | varchar(30) | YES | | NULL | |
| phone_perso | varchar(30) | YES | | NULL | |
| phone_mobile | varchar(30) | YES | | NULL | |
| fax | varchar(30) | YES | | NULL | |
| email | varchar(255) | YES | | NULL | |
| jabberid | varchar(255) | YES | | NULL | |
| fk_user_creat | int(11) | YES | MUL | 0 | |
| fk_user_modif | int(11) | YES | | NULL | |
| note | text | YES | | NULL | |
+---------------------+--------------+------+-----+-------------------+----------------+