4,395
edits
Changes
no edit summary
Line 1:
Line 1:
+
+
[[Category:Table SQL]]
[[Category:Table SQL]]
+
{{ListOfTables}}
{{ListOfTables}}
−= Contenu =
+= Content/Contenu/Contenido =
+{{flag en}} Contains a list of regions for some countries.
+{{flag fr}} Contient une liste des regions proposés pour certains pays.
+{{flag sp}} Contiene la lista de regiones de varios paises.
= Structure =
= Structure =
Line 14:
Line 20:
|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 22:
Line 29:
| auto_increment
| auto_increment
| technical index
| technical index
+|-
+| code_region
+| int(11)
+|
+|
+|
+|
+| code of region
+|-
+| fk_pays
+| int(11)
+| YES
+|
+| NULL
+|
+| ID of related country ([[Table llx_c_pays|llx_c_pays]]->rowid)
+|-
+| cheflieu
+| varchar(7)
+| YES
+|
+| NULL
+|
+| Postal Code of circonscription of region
+|-
+| tncc
+| int(11)
+| YES
+|
+| NULL
+|
+| ID of ncc
+|-
+| nom
+| varchar(50)
+| YES
+|
+| NULL
+|
+| Name of region
+|-
+| active
+| tinyint(4)
+|
+|
+| 1
+|
+| Is the region active?
|}
|}