Table llx socpeople: Difference between revisions
m (→Contenu) |
(→Table) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 14: | Line 14: | ||
= Structure = | = Structure = | ||
{| align="left" width="100%" border="0 | == Table == | ||
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | |||
|style="background-color: #e9e9ef"| <b>Field</b> | |style="background-color: #e9e9ef"| <b>Field</b> | ||
|style="background-color: #e9e9ef"| <b>Type</b> | |style="background-color: #e9e9ef"| <b>Type</b> | ||
| Line 25: | Line 26: | ||
| rowid | | rowid | ||
| int(11) | | int(11) | ||
| | | NO | ||
| PRI | | PRI | ||
| | | | ||
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
| Line 38: | Line 39: | ||
| | | | ||
| creation date | | creation date | ||
{{FieldTms}} | |||
|- | |- | ||
| fk_soc | | fk_soc | ||
| Line 53: | Line 47: | ||
| NULL | | NULL | ||
| | | | ||
| | | ID of society ([[Table llx_societe|llx_societe]]->rowid) | ||
|- | |||
| entity | |||
| int(11) | |||
| NO | |||
| | |||
| 1 | |||
| | |||
| multi company id | |||
|- | |- | ||
| civilite | | civilite | ||
| Line 109: | Line 111: | ||
| 0 | | 0 | ||
| | | | ||
| | | ID of country ([[Table llx_c_pays|llx_c_pays]]->rowid) | ||
|- | |- | ||
| birthday | | birthday | ||
| Line 174: | Line 176: | ||
| | | | ||
| identifier on the Jabber network (could be another network) | | identifier on the Jabber network (could be another network) | ||
|- | |||
| priv | |||
| smallint(6) | |||
| NO | |||
| | |||
| 0 | |||
| | |||
| | |||
|- | |- | ||
| fk_user_creat | | fk_user_creat | ||
| Line 181: | Line 191: | ||
| 0 | | 0 | ||
| | | | ||
| | | user who created this contact ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
| fk_user_modif | | fk_user_modif | ||
| Line 189: | Line 199: | ||
| NULL | | NULL | ||
| | | | ||
| | | user who changed this contact ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
| note | | note | ||
| Line 198: | Line 208: | ||
| | | | ||
| note | | note | ||
|} | |- | ||
| default_lang | |||
| varchar(6) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| default language for this contact | |||
|- | |||
{{FieldImportKey}} | |||
|} | |||
== Keys == | |||
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | |||
|style="background-color: #e9e9ef"| <b>Key</b> | |||
|style="background-color: #e9e9ef"| <b>Type</b> | |||
|style="background-color: #e9e9ef"| <b>Fields</b> | |||
|- | |||
| PRIMARY | |||
| PRIMARY | |||
| rowid | |||
|- | |||
| idx_socpeople_fk_soc | |||
| MULTIPLE | |||
| fk_soc | |||
|- | |||
| idx_socpeople_fk_user_creat | |||
| MULTIPLE | |||
| fk_user_creat | |||
|} | |||
Latest revision as of 12:53, 10 August 2012
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
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| datec | datetime | YES | NULL | creation date | ||
| tms | timestamp | NO | Current date | Date of last modification. See page Field Tms. | ||
| fk_soc | int(11) | YES | MUL | NULL | ID of society (llx_societe->rowid) | |
| entity | int(11) | NO | 1 | multi company id | ||
| 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 | ID of country (llx_c_pays->rowid) | ||
| 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) | ||
| priv | smallint(6) | NO | 0 | |||
| fk_user_creat | int(11) | YES | MUL | 0 | user who created this contact (llx_user->rowid) | |
| fk_user_modif | int(11) | YES | NULL | user who changed this contact (llx_user->rowid) | ||
| note | text | YES | NULL | note | ||
| default_lang | varchar(6) | YES | NULL | default language for this contact | ||
| import_key | varchar(14) | YES | NULL | Code used to save the import id. See page Field Import key. |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| idx_socpeople_fk_soc | MULTIPLE | fk_soc |
| idx_socpeople_fk_user_creat | MULTIPLE | fk_user_creat |