Table llx categorie ticket - Revision history

Eldy: /* Content/Contenu/Contenido */

2021-07-03T19:41:50Z

Content/Contenu/Contenido

← Older revision		Revision as of 19:41, 3 July 2021
Line 6:		Line 6:

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

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

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

	=Structure=		=Structure=

Eldy: /* Table */

2021-07-03T19:38:39Z

Table

← Older revision		Revision as of 19:38, 3 July 2021
Line 40:		Line 40:
	\|		\|
	\|		\|
	\|ID of ticket ([[Table ~~llx_societe~~\|llx_ticket]]->rowid)		\|ID of ticket ([[Table llx_ticket\|llx_ticket]]->rowid)
	\|-		\|-
	\|import_key		\|import_key

Theo-eoxia: /* Structure */

2021-07-01T14:10:33Z

Structure

← Older revision		Revision as of 14:10, 1 July 2021
Line 34:		Line 34:
	\|ID of category ([[Table llx_categorie\|llx_categorie]]->rowid)		\|ID of category ([[Table llx_categorie\|llx_categorie]]->rowid)
	\|-		\|-
	\|~~fk_soc~~		\|fk_ticket
	\|int(11)		\|int(11)
	\|NO		\|NO
Line 40:		Line 40:
	\|		\|
	\|		\|
	\|ID of ~~society~~ ([[Table llx_societe\|llx_ticket]]->rowid)		\|ID of ticket ([[Table llx_societe\|llx_ticket]]->rowid)
	\|-		\|-
	\|import_key		\|import_key

Theo-eoxia: /* Keys */

2021-07-01T14:10:07Z

Keys

← Older revision		Revision as of 14:10, 1 July 2021
Line 5:		Line 5:
	{{ListOfTables}}		{{ListOfTables}}

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

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

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

	= Structure =		=Structure=
	== Table ==		==Table==
	{\| ~~align~~="~~left~~" width="100%" ~~border~~="0" cellpadding="1" ~~cellspacing~~="0" ~~class~~="~~dolbox~~"		{\| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
	\|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>
	\|style="background-color: #e9e9ef"\| <b>Null</b>		\| style="background-color: #e9e9ef" \|<b>Null</b>
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\| style="background-color: #e9e9ef" \|<b>Key</b>
	\|style="background-color: #e9e9ef"\| <b>Default</b>		\| style="background-color: #e9e9ef" \|<b>Default</b>
	\|style="background-color: #e9e9ef"\| <b>Extra</b>		\| style="background-color: #e9e9ef" \|<b>Extra</b>
	\|style="background-color: #e9e9ef"\| <b>Description</b>		\| style="background-color: #e9e9ef" \|<b>Description</b>
	\|-		\|-
	\| fk_categorie		\|fk_categorie
	\| int(11)		\|int(11)
	\| NO		\|NO
	\| PRI		\|PRI
	\|		\|
	\|		\|
	\| ID of category ([[Table llx_categorie\|llx_categorie]]->rowid)		\|ID of category ([[Table llx_categorie\|llx_categorie]]->rowid)
	\|-		\|-
	\| fk_soc		\|fk_soc
	\| int(11)		\|int(11)
	\| NO		\|NO
	\| PRI		\|PRI
	\|		\|
	\|		\|
	\| ID of society ([[Table llx_societe\|llx_ticket]]->rowid)		\|ID of society ([[Table llx_societe\|llx_ticket]]->rowid)
	\|-		\|-
	\| import_key		\|import_key
	\| varchar(14)		\|varchar(14)
	\| YES		\|YES
	\|		\|
	\| NULL		\|NULL
	\|		\|
	\| import key		\|import key
	\|}		\|}

	== Keys ==		==Keys==
	{\| ~~align~~="~~left~~" width="100%" ~~border~~="0" cellpadding="1" ~~cellspacing~~="0" ~~class~~="~~dolbox~~"		{\| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\| style="background-color: #e9e9ef" \|<b>Key</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\| style="background-color: #e9e9ef" \|<b>Type</b>
	\|style="background-color: #e9e9ef"\| <b>Fields</b>		\| style="background-color: #e9e9ef" \|<b>Fields</b>
	\|-		\|-
	\| PRIMARY		\|PRIMARY
	\| PRIMARY		\|PRIMARY
	\| fk_categorie,fk_ticket		\|fk_categorie,fk_ticket
	\|-		\|-
	\| ~~idx_categorie_product_fk_categorie~~		\|idx_categorie_ticket_fk_categorie
	\| MULTIPLE		\|MULTIPLE
	\| fk_categorie		\|fk_categorie
	\|-		\|-
	\| ~~idx_categorie_product_fk_ticket~~		\|idx_categorie_ticket_fk_ticket
	\| MULTIPLE		\|MULTIPLE
	\| ~~fk_product~~		\|fk_ticket
	\|}		\|}

Theo-eoxia: Add llx_categorie_ticket page content

2021-07-01T14:08:46Z

Add llx_categorie_ticket page content

New page

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

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

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

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

= Structure =
== Table ==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| Field
|style="background-color: #e9e9ef"| Type
|style="background-color: #e9e9ef"| Null
|style="background-color: #e9e9ef"| Key
|style="background-color: #e9e9ef"| Default
|style="background-color: #e9e9ef"| Extra
|style="background-color: #e9e9ef"| Description
|-
| 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_ticket]]->rowid)
|-
| import_key
| varchar(14)
| YES
|
| NULL
|
| import key
|} 

== Keys ==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| Key
|style="background-color: #e9e9ef"| Type
|style="background-color: #e9e9ef"| Fields
|-
| PRIMARY
| PRIMARY
| fk_categorie,fk_ticket
|-
| idx_categorie_product_fk_categorie
| MULTIPLE
| fk_categorie
|-
| idx_categorie_product_fk_ticket
| MULTIPLE
| fk_product
|}