Difference between revisions of "Table llx societe commerciaux"

 
(5 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
{{ListOfTables}}
 
{{ListOfTables}}
  
= Contenu =
+
= Content/Contenu/Contenido =
 +
 
 +
{{flag en}} Contains the commercial contacts for a society.
 +
 
 +
{{flag fr}} Contient les contact commerciaux pour les societes.
 +
 
 +
{{flag sp}} Contiene los contactos comerciales de las empresas.
  
 
= Structure =
 
= Structure =
{|  align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
+
== 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 19: Line 26:
 
| rowid  
 
| rowid  
 
| int(11)  
 
| int(11)  
| &nbsp;
+
| NO
 
| PRI
 
| PRI
 +
|
 +
| auto_increment
 +
| technical index
 +
|-
 +
| fk_soc
 +
| int(11)
 +
| YES
 +
| UNI
 +
| NULL
 +
|
 +
| ID society ([[Table llx_societe|llx_societe]]->rowid)
 +
|-
 +
| fk_user
 +
| int(11)
 +
| YES
 +
| UNI
 
| NULL
 
| NULL
| auto_increment
+
|  
| index technique
+
| ID of user ([[Table llx_user|llx_user]]->rowid)
|}
+
|}&nbsp;
 +
== 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
 +
|-
 +
| fk_soc
 +
| UNIQUE
 +
| fk_soc,fk_user
 +
|}&nbsp;

Latest revision as of 15:51, 19 July 2011


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅:Table SQL


Content/Contenu/Contenido

  Contains the commercial contacts for a society.

  Contient les contact commerciaux pour les societes.

  Contiene los contactos comerciales de las empresas.

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
fk_soc int(11) YES UNI NULL ID society (llx_societe->rowid)
fk_user int(11) YES UNI NULL ID of user (llx_user->rowid)

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
fk_soc UNIQUE fk_soc,fk_user