Table llx element element - Revision history

Simnandez: /* Structure */

2011-07-19T15:15:47Z

Structure

← Older revision		Revision as of 15:15, 19 July 2011
Line 18:		Line 18:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.2 2009/12/10'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| 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~~"
	\|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 70:		Line 69:

	== Keys ==		== Keys ==
	~~'''Version 1.3 2009/12/11'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| 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~~"
	\|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>

Hregis at 19:33, 25 March 2010

2010-03-25T19:33:16Z

Simnandez: /* Table */

2009-12-12T15:44:19Z

Table

← Older revision		Revision as of 15:44, 12 December 2009
Line 55:		Line 55:
	\| int(11)		\| int(11)
	\| NO		\| NO
	\|		\| MUL
	\|		\|
	\|		\|

Simnandez: /* Keys */

2009-12-12T15:43:41Z

Keys

← Older revision		Revision as of 15:43, 12 December 2009
Line 70:		Line 70:

	== Keys ==		== Keys ==
	'''Version 1.2 2009/10/25'''		'''Version 1.3 2009/12/11'''
	{\| 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"		{\| 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"
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>
Line 82:		Line 82:
	\| idx_element_element_idx1		\| idx_element_element_idx1
	\| UNIQUE		\| UNIQUE
	\| ~~sourceid~~,sourcetype,~~targetid~~,targettype		\| fk_source,sourcetype,fk_target,targettype
	\|-		\|-
	\| ~~idx_element_element_targetid~~		\| idx_element_element_fk_target
	\| MULTIPLE		\| MULTIPLE
	\| ~~targetid~~		\| fk_target
	\|}		\|}

Simnandez: /* Table */

2009-12-12T15:42:06Z

Table

← Older revision		Revision as of 15:42, 12 December 2009
Line 18:		Line 18:
	= Structure =		= Structure =
	== Table ==		== Table ==
	'''Version 1.1 2009/10~~/07~~'''		'''Version 1.2 2009/12/10'''
	{\| 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"		{\| 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"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
Line 36:		Line 36:
	\| technical index		\| technical index
	\|-		\|-
	\| ~~sourceid~~		\| fk_source
	\| int(11)		\| int(11)
	\| NO		\| NO
Line 52:		Line 52:
	\| type of source. view content section		\| type of source. view content section
	\|-		\|-
	\| ~~targetid~~		\| fk_target
	\| int(11)		\| int(11)
	\| NO		\| NO
Line 68:		Line 68:
	\| type of target. view content section		\| type of target. view content section
	\|}		\|}

	== Keys ==		== Keys ==
	'''Version 1.2 2009/10/25'''		'''Version 1.2 2009/10/25'''

Simnandez: /* Keys */

2009-10-27T06:45:04Z

Keys

← Older revision		Revision as of 06:45, 27 October 2009
Line 69:		Line 69:
	\|}		\|}
	== Keys ==		== Keys ==
	'''Version 1.1 2009/10/07'''		'''Version 1.2 2009/10/25'''
	{\| 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"		{\| 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"
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>

Simnandez at 09:47, 20 October 2009

2009-10-20T09:47:45Z

Show changes

Simnandez: /* Structure */

2009-06-19T09:03:41Z

Structure

← Older revision		Revision as of 09:03, 19 June 2009
Line 123:		Line 123:
	\|		\|
	\|		\|
	\| ID of ~~source~~ (any table_of_elements->rowid)		\| ID of target (any table_of_elements->rowid)
	\|-		\|-
	\| targettype		\| targettype

Simnandez: /* Structure */

2009-06-19T08:01:43Z

Structure

@@ Line 100: / Line 100: @@
 | auto_increment
 | technical index
 |}

Simnandez: /* Contenu */

2009-06-19T07:33:58Z

Contenu

@@ Line 5: / Line 5: @@
 {{ListOfTables}}
-= Contenu =
+= Content/Contenu/Contenido =
 {{flag fr}} Cette table permet de sauvegarder les liens entre entités.

← Older revision		Revision as of 19:33, 25 March 2010
Line 108:		Line 108:
	* "member" : In this case the id field must be an id of the table llx_adherent		* "member" : In this case the id field must be an id of the table llx_adherent
	* "propal" : In this case the id field must be an id of the table llx_propal		* "propal" : In this case the id field must be an id of the table llx_propal
	* "~~sending~~" : In this case the id field must be an id of the table llx_expedition		* "shipping" : In this case the id field must be an id of the table llx_expedition
	* "delivery" : In this case the id field must be an id of the table llx_livraison		* "delivery" : In this case the id field must be an id of the table llx_livraison

Line 131:		Line 131:
	* "member" : Dans ce cas le champ doit être un id de la table llx_adherent		* "member" : Dans ce cas le champ doit être un id de la table llx_adherent
	* "propal" : Dans ce cas le champ doit être un id de la table llx_propal		* "propal" : Dans ce cas le champ doit être un id de la table llx_propal
	* "~~sending~~" : Dans ce cas le champ doit être un id de la table llx_expedition		* "shipping" : Dans ce cas le champ doit être un id de la table llx_expedition
	* "delivery" : Dans ce cas le champ doit être un id de la table llx_livraison		* "delivery" : Dans ce cas le champ doit être un id de la table llx_livraison

Line 153:		Line 153:
	* "member" : En este caso el campo id debe de ser un id de la tabla llx_adherent		* "member" : En este caso el campo id debe de ser un id de la tabla llx_adherent
	* "propal" : En este caso el campo id debe de ser un id de la tabla llx_propal		* "propal" : En este caso el campo id debe de ser un id de la tabla llx_propal
	* "~~sending~~" : En este caso el campo id debe de ser un id de la tabla llx_expedition		* "shipping" : En este caso el campo id debe de ser un id de la tabla llx_expedition
	* "delivery" : En este caso el campo id debe de ser un id de la tabla llx_livraison		* "delivery" : En este caso el campo id debe de ser un id de la tabla llx_livraison

	Este tipo permite utilizar 1 sola y única tabla para todo tipo de enlace en lugar de 2<sup>n</sup> tablas (n son el número de entidades gestionadas en Dolibarr).		Este tipo permite utilizar 1 sola y única tabla para todo tipo de enlace en lugar de 2<sup>n</sup> tablas (n son el número de entidades gestionadas en Dolibarr).