Table llx socpeople
Jump to navigation
Jump to search
+---------------------+--------------+------+-----+-------------------+----------------+ | 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 | | +---------------------+--------------+------+-----+-------------------+----------------+