Table llx c departements - Revision history

Ssherratt: /* Table */

2018-07-24T16:53:10Z

Table

← Older revision		Revision as of 16:53, 24 July 2018
Line 52:		Line 52:
	\| NULL		\| NULL
	\|		\|
	\| Postal Code ~~of circonscription~~ of departement		\| Postal Code of departement/province/district.
	\|-		\|-
	\| tncc		\| tncc

Ssherratt: /* Table */

2018-07-24T16:52:43Z

Table

← Older revision		Revision as of 16:52, 24 July 2018
Line 36:		Line 36:
	\|		\|
	\|		\|
	\| code of departement		\| code of departement/province/state/district: note this alphanumeric code must be unique to the entire table/all other global provinces, not just to one country.
	\|-		\|-
	\| fk_region		\| fk_region

Eldy: /* Table */

2016-06-21T16:13:27Z

Table

← Older revision		Revision as of 16:13, 21 June 2016
Line 60:		Line 60:
	\| NULL		\| NULL
	\|		\|
	\| ID of ncc		\| ID of ncc - Used for France only. Means "Type de nom en clair". See http://www.insee.fr/fr/methodes/nomenclatures/cog/documentation.asp?page=telechargement/2015/doc/doc_variables.htm
	\|-		\|-
	\| ncc		\| ncc
Line 68:		Line 68:
	\| NULL		\| NULL
	\|		\|
	\| ncc		\| ncc - Used for France only. Means "Nom en clair". See http://www.insee.fr/fr/methodes/nomenclatures/cog/documentation.asp?page=telechargement/2015/doc/doc_variables.htm
	\|-		\|-
	\| nom		\| nom
Line 86:		Line 86:
	\| Is the departement active?		\| Is the departement 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:02:36Z

Structure

← Older revision		Revision as of 10:02, 19 July 2011
Line 13:		Line 13:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.1 2009/10/17'''~~		{\| 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 88:		Line 87:
	\|}		\|}
	== Keys ==		== Keys ==
	~~'''Version 1.1 2009/10/17'''~~		{\| 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-19T09:48:01Z

Structure

← Older revision		Revision as of 09:48, 19 October 2009
Line 12:		Line 12:

	= Structure =		= Structure =
	'''Version 1.~~9 2007~~/12/02'''		== Table ==
			'''Version 1.1 2009/10/17'''
	{\| 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 22:		Line 22:
	\|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>

	\|-		\|-
	\| rowid		\| rowid
Line 28:		Line 27:
	\| NO		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 87:		Line 86:
	\|		\|
	\| Is the departement active?		\| Is the departement active?
			\|}
			== Keys ==
			'''Version 1.1 2009/10/17'''
			{\| 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
			\|-
			\| uk_departements
			\| UNIQUE
			\| code_departement,fk_region
			\|-
			\| idx_departements_fk_region
			\| MULTIPLE
			\| fk_region
	\|}		\|}

Simnandez: /* Structure */

2009-10-06T08:06:15Z

Structure

← Older revision		Revision as of 08:06, 6 October 2009
Line 12:		Line 12:

	= Structure =		= Structure =
			'''Version 1.9 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_departement		\| code_departement
	\| varchar(6)		\| varchar(6)
	\|		\| NO
	\|		\| UNI
	\|		\|
	\|		\|
Line 41:		Line 43:
	\| int(11)		\| int(11)
	\| YES		\| YES
	\|		\| UNI
	\| NULL		\| NULL
	\|		\|
Line 80:		Line 82:
	\| active		\| active
	\| tinyint(4)		\| tinyint(4)
	\|		\| NO
	\|		\|
	\| 1		\| 1
	\|		\|
	\| Is the departement active?		\| Is the departement active?
	\|}		\|}

Simnandez: /* Structure */

2009-05-25T10:22:19Z

Structure

← Older revision		Revision as of 10:22, 25 May 2009
Line 63:		Line 63:
	\|-		\|-
	\| ncc		\| ncc
	\| ~~varhcar~~(50)		\| varchar(50)
	\| YES		\| YES
	\|		\|
Line 71:		Line 71:
	\|-		\|-
	\| nom		\| nom
	\| ~~varhcar~~(50)		\| varchar(50)
	\| YES		\| YES
	\|		\|

Simnandez: /* Content/Contenu/Contenido */

2009-05-25T10:13:39Z

Content/Contenu/Contenido

← Older revision		Revision as of 10:13, 25 May 2009
Line 4:		Line 4:

	= Content/Contenu/Contenido =		= Content/Contenu/Contenido =

			{{flag en}} Contains a list of departments for some countries.

	{{flag fr}} Contient une liste des départments proposés pour certains pays.		{{flag fr}} Contient une liste des départments proposés pour certains pays.

	~~{{flag en}} Contains a list of departments for some countries.~~

	{{flag sp}} Contiene la lista de departamentos (provincias) de varios paises.		{{flag sp}} Contiene la lista de departamentos (provincias) de varios paises.

Simnandez: /* Structure */

2009-05-25T10:13:23Z

Structure

← Older revision		Revision as of 10:13, 25 May 2009
Line 44:		Line 44:
	\| NULL		\| NULL
	\|		\|
	\| ID of region ([[Table llx_c_regions\|llx_c_regions]]->code_region)		\| ID of related region ([[Table llx_c_regions\|llx_c_regions]]->code_region)
	\|-		\|-
	\| cheflieu		\| cheflieu

Simnandez: /* Structure */

2009-05-25T09:58:54Z

Structure

@@ Line 20: / Line 20: @@
   |style="background-color: #e9e9ef"| <b>Extra</b>
   |style="background-color: #e9e9ef"| <b>Description</b>
 |-
 | rowid
@@ Line 28: / Line 29: @@
 | auto_increment
 | technical index
 |}