Table llx socpeople: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 37: | Line 37: | ||
| NULL | | NULL | ||
| | | | ||
| date | | creation date | ||
|- | |- | ||
| tms | | tms | ||
| Line 45: | Line 45: | ||
| CURRENT_TIMESTAMP | | CURRENT_TIMESTAMP | ||
| | | | ||
| timestamp (date | | timestamp (date last modified) | ||
|- | |- | ||
| fk_soc | | fk_soc | ||
| Line 53: | Line 53: | ||
| NULL | | NULL | ||
| | | | ||
| | | foreign key to llx_societe | ||
|- | |- | ||
| civilite | | civilite | ||
| Line 61: | Line 61: | ||
| NULL | | NULL | ||
| | | | ||
| | | civility (in text eg Mr, Mrs,...) | ||
|- | |- | ||
| name | | name | ||
| Line 69: | Line 69: | ||
| NULL | | NULL | ||
| | | | ||
| | | last name | ||
|- | |- | ||
| firstname | | firstname | ||
| Line 77: | Line 77: | ||
| NULL | | NULL | ||
| | | | ||
| | | first name | ||
|- | |- | ||
| address | | address | ||
| Line 85: | Line 85: | ||
| NULL | | NULL | ||
| | | | ||
| | | address | ||
|- | |- | ||
| cp | | cp | ||
| Line 93: | Line 93: | ||
| NULL | | NULL | ||
| | | | ||
| | | postcode | ||
|- | |- | ||
| ville | | ville | ||
| Line 101: | Line 101: | ||
| NULL | | NULL | ||
| | | | ||
| | | city | ||
|- | |- | ||
| fk_pays | | fk_pays | ||
| Line 109: | Line 109: | ||
| 0 | | 0 | ||
| | | | ||
| | | foreign key to llx_c_pays | ||
|- | |- | ||
| birthday | | birthday | ||
| Line 117: | Line 117: | ||
| NULL | | NULL | ||
| | | | ||
| | | anniversary/date of birth | ||
|- | |- | ||
| poste | | poste | ||
| Line 125: | Line 125: | ||
| NULL | | NULL | ||
| | | | ||
| | | function within the company | ||
|- | |- | ||
| phone | | phone | ||
| Line 133: | Line 133: | ||
| NULL | | NULL | ||
| | | | ||
| | | telephone | ||
|- | |- | ||
| phone_perso | | phone_perso | ||
| Line 141: | Line 141: | ||
| NULL | | NULL | ||
| | | | ||
| | | personal telephone | ||
|- | |- | ||
| phone_mobile | | phone_mobile | ||
| Line 149: | Line 149: | ||
| NULL | | NULL | ||
| | | | ||
| | | mobile phone (GSM) | ||
|- | |- | ||
| fax | | fax | ||
| Line 173: | Line 173: | ||
| NULL | | NULL | ||
| | | | ||
| | | identifier on the Jabber network (could be another network) | ||
|- | |- | ||
| fk_user_creat | | fk_user_creat | ||
| Line 181: | Line 181: | ||
| 0 | | 0 | ||
| | | | ||
| | | foreign key to llx_user (user who created this contact) | ||
|- | |- | ||
| fk_user_modif | | fk_user_modif | ||
| Line 189: | Line 189: | ||
| NULL | | NULL | ||
| | | | ||
| | | foreign key to llx_user (user who changed this contact) | ||
|- | |- | ||
| note | | note | ||
Revision as of 07:03, 6 May 2009
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
La table llx_socpeople contient les contacts (personnes) des sociétés (clients et fournisseurs)
Contains the contact people of companies (clients or providers).
Contiene los contactos físicos (personas) de las empresas (clientes y proveedores).
Structure
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | PRI | NULL | auto_increment | index technique | |
| 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 |