Table llx commande fournisseur dispatch - Revision history

Simnandez: /* Structure */

2011-07-19T14:32:42Z

Structure

← Older revision		Revision as of 14:32, 19 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.1 2009/10/07'''~~		{\| 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 82:		Line 81:
	\|}		\|}
	== Keys ==		== Keys ==
	~~'''Version 1.1 2009/10/07'''~~		{\| 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>

Simnandez: /* Structure */

2009-10-20T07:41:14Z

Structure

← Older revision		Revision as of 07:41, 20 October 2009
Line 14:		Line 14:

	= Structure =		= Structure =
			== Table ==
			'''Version 1.1 2009/10/07'''
	{\| 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 25:		Line 27:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 34:		Line 36:
	\| int(11)		\| int(11)
	\| YES		\| YES
	\|		\| MUL
	\| NULL		\| NULL
	\|		\|
Line 78:		Line 80:
	\|		\|
	\| date of dispatch		\| date of dispatch
	\|}		\|}
			== Keys ==
			'''Version 1.1 2009/10/07'''
			{\| 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>Type</b>
			\|style="background-color: #e9e9ef"\| <b>Fields</b>
			\|-
			\| PRIMARY
			\| PRIMARY
			\| rowid
			\|-
			\| idx_commande_fournisseur_dispatch_fk_commande
			\| MULTIPLE
			\| fk_commande
			\|}

Simnandez: Created page with 'Category:Table SQL Category:Fournisseur Category:Supplier Category:Proveedores {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the provider ...'

2009-06-03T16:45:38Z

Created page with 'Category:Table SQL Category:Fournisseur Category:Supplier Category:Proveedores {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the provider ...'

New page

[[Category:Table SQL]]
[[Category:Fournisseur]]
[[Category:Supplier]]
[[Category:Proveedores]]

{{ListOfTables}}

= Content/Contenu/Contenido =
{{flag en}} Contains the provider orders dispatch.

{{flag fr}} Contient les envois des commandes fournisseurs.

{{flag sp}} Contiene los envíos de los pedidos a proveedores.

= 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"
|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
|-
| rowid
| int(11)
|  
| PRI
| NULL
| auto_increment
| technical index
|-
| fk_commande
| int(11)
| YES
|
| NULL
|
| ID of order ([[Table llx_commande_fournisseur|llx_commande_fournisseur]]->rowid)
|-
| fk_product
| int(11)
| YES
|
| NULL
|
| ID of product ([[Table llx_projet|llx_projet]]->rowid)
|-
| qty
| float
| YES
|
| NULL
|
| Quantity
|-
| fk_entrepot
| int(11)
| YES
|
| NULL
|
| ID of warehouse ([[Table llx_entrepot|llx_entrepot]]->rowid)
|-
| fk_user
| int(11)
| YES
|
| NULL
|
| ID of user ([[Table llx_user|llx_user]]->rowid)
|-
| datec
| datetime
| YES
|
| NULL
|
| date of dispatch
|}