Table llx c regions - Revision history

Ssherratt: /* Table */

2018-07-24T16:51:13Z

Table

← Older revision		Revision as of 16:51, 24 July 2018
Line 53:		Line 53:
	\| NULL		\| NULL
	\|		\|
	\| Postal Code of ~~circonscription/~~area or region		\| Postal Code of area or region
	\|-		\|-
	\| tncc		\| tncc

Ssherratt: /* Table */

2018-07-24T16:48:56Z

Table

← Older revision		Revision as of 16:48, 24 July 2018
Line 37:		Line 37:
	\|		\|
	\|		\|
	\| code of region: note this must be unique to the entire table/all countries, not just to ~~the~~ country.		\| code of region: note this must be a numeric code unique to the entire table/all countries, not just to one country.
	\|-		\|-
	\| fk_pays		\| fk_pays

Ssherratt: /* Table */

2018-07-24T16:48:14Z

Table

← Older revision		Revision as of 16:48, 24 July 2018
Line 37:		Line 37:
	\|		\|
	\|		\|
	\| code of region		\| code of region: note this must be unique to the entire table/all countries, not just to the country.
	\|-		\|-
	\| fk_pays		\| fk_pays

Aikhan: /* Table */

2013-04-13T09:51:27Z

Table

← Older revision		Revision as of 09:51, 13 April 2013
Line 53:		Line 53:
	\| NULL		\| NULL
	\|		\|
	\| Postal Code of circonscription of region		\| Postal Code of circonscription/area or region
	\|-		\|-
	\| tncc		\| tncc
Line 79:		Line 79:
	\| Is the region active?		\| Is the region active?
	\|}		\|}

	== Keys ==		== Keys ==
	{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"

Eldy: /* Structure */

2011-07-19T10:22:41Z

Structure

← Older revision		Revision as of 10:22, 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 81:		Line 80:
	\|}		\|}
	== 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-19T15:44:21Z

Structure

← Older revision		Revision as of 15:44, 19 October 2009
Line 12:		Line 12:

	= Structure =		= Structure =
	'''Version 1.~~11 2007~~/12/02'''		== 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 28:		Line 28:
	\| NO		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 42:		Line 42:
	\| fk_pays		\| fk_pays
	\| int(11)		\| int(11)
	\| ~~YES~~		\| NO
	\| MUL		\| MUL
	\| ~~NULL~~		\|
	\|		\|
	\| ID of related country ([[Table llx_c_pays\|llx_c_pays]]->rowid)		\| ID of related country ([[Table llx_c_pays\|llx_c_pays]]->rowid)
Line 79:		Line 79:
	\|		\|
	\| Is the region active?		\| Is the region active?
			\|}
			== 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
			\| id
			\|-
			\| code_region
			\| UNIQUE
			\| code_region
			\|-
			\| idx_c_regions_fk_pays
			\| MULTIPLE
			\| fk_pays
	\|}		\|}

Simnandez: /* Structure */

2009-10-08T08:09:31Z

Structure

← Older revision		Revision as of 08:09, 8 October 2009
Line 12:		Line 12:

	= Structure =		= Structure =
			'''Version 1.11 2007/12/02'''

	{\| 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 24:		Line 26:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| NULL		\| NULL
Line 32:		Line 34:
	\| code_region		\| code_region
	\| int(11)		\| int(11)
	\|		\| NO
	\|		\|
	\|		\|
Line 41:		Line 43:
	\| int(11)		\| int(11)
	\| YES		\| YES
	\|		\| MUL
	\| NULL		\| NULL
	\|		\|
Line 72:		Line 74:
	\| active		\| active
	\| tinyint(4)		\| tinyint(4)
	\|		\| NO
	\|		\|
	\| 1		\| 1
	\|		\|
	\| Is the region active?		\| Is the region active?
	\|}		\|}

Simnandez at 14:48, 25 May 2009

2009-05-25T14:48:42Z

@@ Line 1: / Line 1: @@
 [[Category:Table SQL]]
 {{ListOfTables}}
-= Contenu =
+= Content/Contenu/Contenido =
 = Structure =
@@ Line 14: / Line 20: @@
   |style="background-color: #e9e9ef"| <b>Extra</b>
   |style="background-color: #e9e9ef"| <b>Description</b>
 |-
 | rowid
@@ Line 22: / Line 29: @@
 | auto_increment
 | technical index
 |}

Simnandez: /* Structure */

2009-05-12T16:59:02Z

Structure

← Older revision		Revision as of 16:59, 12 May 2009
Line 6:		Line 6:

	= 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 18:01, 11 March 2009

2009-03-11T18:01:17Z

← Older revision		Revision as of 18:01, 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]]~~		{{ListOfTables}}
	~~The documentation related to other tables is available on the tables list page: [[Liste des tables]]~~

	= Contenu =		= Contenu =