Table llx compta - Revision history

Simnandez: /* Structure */

2011-07-19T14:34:48Z

Structure

← Older revision		Revision as of 14:34, 19 July 2011
Line 13:		Line 13:
	= 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 97:		Line 96:
	\|}		\|}
	== 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:49:05Z

Structure

← Older revision		Revision as of 07:49, 20 October 2009
Line 12:		Line 12:

	= 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 23:		Line 25:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 46:		Line 48:
	\|-		\|-
	\| amount		\| amount
	\| ~~double~~		\| real
	\| NO		\| NO
	\|		\|
Line 59:		Line 61:
	\| NULL		\| NULL
	\|		\|
	\|		\| label
	\|-		\|-
	\| fk_user_author		\| fk_user_author
Line 84:		Line 86:
	\| 0		\| 0
	\|		\|
	\|		\| is validated?
	\|-		\|-
	\| note		\| note
Line 93:		Line 95:
	\|		\|
	\| notes		\| notes
	\|}		\|}
			== 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
			\|}

Simnandez: /* Contenu */

2009-06-05T10:09:25Z

Contenu

← Older revision		Revision as of 10:09, 5 June 2009
Line 3:		Line 3:
	{{ListOfTables}}		{{ListOfTables}}

	= Contenu =		= Content/Contenu/Contenido =

			{{flag en}} Contains

			{{flag fr}} Contient

			{{flag sp}} Contiene

	= Structure =		= Structure =

Simnandez: /* Structure */

2009-06-05T10:06:07Z

Structure

← Older revision		Revision as of 10:06, 5 June 2009
Line 24:		Line 24:
	\| technical index		\| technical index
	\|-		\|-
			\| datec
			\| datetime
			\| YES
			\|
			\| NULL
			\|
			\| date of creation
			\|-
			\| datev
			\| date
			\| YES
			\|
			\| NULL
			\|
			\| date of value
			\|-
			\| amount
			\| double
			\| NO
			\|
			\| 0
			\|
			\| amount
			\|-
			\| label
			\| varchar(255)
			\| YES
			\|
			\| NULL
			\|
			\|
			\|-
			\| fk_user_author
			\| int(11)
			\| YES
			\|
			\| NULL
			\|
			\| ID of author user ([[Table llx_user\|llx_user]]->rowid)
			\|-
			\| fk_user_valid
			\| int(11)
			\| YES
			\|
			\| NULL
			\|
			\| ID of validator user ([[Table llx_user\|llx_user]]->rowid)

			\|-
			\| valid
			\| tinyint(4)
			\| YES
			\|
			\| 0
			\|
			\|
			\|-
			\| note
			\| text
			\| YES
			\|
			\| NULL
			\|
			\| notes
			\|}

Simnandez: /* Structure */

2009-05-12T08:48:35Z

Structure

← Older revision		Revision as of 08:48, 12 May 2009
Line 7:		Line 7:

	= 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"
			\|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>
			\|-
			\| rowid
			\| int(11)
			\|
			\| PRI
			\| NULL
			\| auto_increment
			\| technical index
			\|-

Eldy at 21:24, 11 March 2009

2009-03-11T21:24:02Z

← Older revision		Revision as of 21:24, 11 March 2009
Line 1:		Line 1:
	[[Category:Table SQL]]		[[Category:Table SQL]]
	~~La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]~~
	~~The documentation related to other tables is available on the tables list page: [[Liste des tables]]~~		{{ListOfTables}}

	= Contenu =		= Contenu =

Eldy at 15:21, 3 February 2009

2009-02-03T15:21:41Z

← Older revision		Revision as of 15:21, 3 February 2009
Line 1:		Line 1:
	[[~~Catégorie~~:Table SQL]]		[[Category:Table SQL]]
	La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]		La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
	The documentation related to other tables is available on the tables list page: [[Liste des tables]]		The documentation related to other tables is available on the tables list page: [[Liste des tables]]

Ywarnier at 02:39, 6 August 2007

2007-08-06T02:39:32Z

New page

[[Catégorie:Table SQL]]
La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
The documentation related to other tables is available on the tables list page: [[Liste des tables]]

= Contenu =

= Structure =