Table llx socpeople
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL
Contenu
Contains the people or generic contacts linked to third parties or not (customers, suppliers...).
Contient les contacts physiques (personnes, ou adresses génériques de personnes) liés ou non au tiers (clients, fournisseurs...)
Contiene los contactos físicos (personas) de las empresas (clientes, proveedores...).
Structure
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | PRI | NULL | auto_increment | technical index | |
| datec | datetime | YES | NULL | creation date | ||
| tms | timestamp | NO | CURRENT_TIMESTAMP | timestamp (date last modified) | ||
| fk_soc | int(11) | YES | MUL | NULL | foreign key to llx_societe | |
| civilite | varchar(6) | YES | NULL | civility (in text eg Mr, Mrs,...) | ||
| name | varchar(50) | YES | NULL | last name | ||
| firstname | varchar(50) | YES | NULL | first name | ||
| address | varchar(255) | YES | NULL | address | ||
| cp | varchar(25) | YES | NULL | postcode | ||
| ville | varchar(255) | YES | NULL | city | ||
| fk_pays | int(11) | YES | 0 | foreign key to llx_c_pays | ||
| birthday | date | YES | NULL | anniversary/date of birth | ||
| poste | varchar(80) | YES | NULL | function within the company | ||
| phone | varchar(30) | YES | NULL | telephone | ||
| phone_perso | varchar(30) | YES | NULL | personal telephone | ||
| phone_mobile | varchar(30) | YES | NULL | mobile phone (GSM) | ||
| fax | varchar(30) | YES | NULL | fax | ||
| varchar(255) | YES | NULL | ||||
| jabberid | varchar(255) | YES | NULL | identifier on the Jabber network (could be another network) | ||
| fk_user_creat | int(11) | YES | MUL | 0 | foreign key to llx_user (user who created this contact) | |
| fk_user_modif | int(11) | YES | NULL | foreign key to llx_user (user who changed this contact) | ||
| note | text | YES | NULL | note |