View source for Table llx categorie societe

[[Category:Table SQL]]
[[Category:Categories]]
[[Category:Catégories]]
[[Category:Categorías]]
{{ListOfTables}}

= Content/Contenu/Contenido =
{{flag en}} Contains a "n to m" relationship between societies and the categories.

{{flag fr}} Contient une relation "n to m" entre les sociétés et les catégories.

{{flag sp}} Contiene una relación "n a m" entre las empresas y las categorías.

= Structure =
== 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>Type</b>
 |style="background-color: #e9e9ef"| <b>Null</b>
 |style="background-color: #e9e9ef"| <b>Key</b>
 |style="background-color: #e9e9ef"| <b>Default</b>
 |style="background-color: #e9e9ef"| <b>Extra</b>
 |style="background-color: #e9e9ef"| <b>Description</b>
|-
| fk_categorie 
| int(11) 
| NO 
| PRI
|
|
| ID of category ([[Table llx_categorie|llx_categorie]]->rowid)
|-
| fk_soc
| int(11)
| NO 
| PRI
| 
| 
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
|-
| import_key
| varchar(14)
| YES 
| 
| NULL
| 
| import key
|}&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
| fk_categorie,fk_soc
|- 
| idx_categorie_product_fk_categorie  
| MULTIPLE
| fk_categorie
|- 
| idx_categorie_product_fk_societe
| MULTIPLE
| fk_product
|}&nbsp;