98
edits
Changes
m
→Table
Line 1:
Line 1:
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 =+
[[Category:Table SQL]]
[[Category:Table SQL]]
−{{ListOfTables}}
+= 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 =
+== Table ==
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |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)
+| NO
+| PRI
+|
+| auto_increment
+| technical index
+|-
+| code_region
+| int(11)
+| NO
+|
+|
+|
+| code of region: note this must be a numeric code unique to the entire table/all countries, not just to one country.
+|-
+| fk_pays
+| int(11)
+| NO
+| MUL
+|
+|
+| ID of related country ([[Table llx_c_pays|llx_c_pays]]->rowid)
+|-
+| cheflieu
+| varchar(7)
+| YES
+|
+| NULL
+|
+| Postal Code of area or region
+|-
+| tncc
+| int(11)
+| YES
+|
+| NULL
+|
+| ID of ncc
+|-
+| nom
+| varchar(50)
+| YES
+|
+| NULL
+|
+| Name of region
+|-
+| active
+| tinyint(4)
+| NO
+|
+| 1
+|
+| Is the region active?
+|}
+
+== Keys ==
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |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
+|}