Difference between revisions of "Table llx c country"
m (moved Table llx c pays to Table llx c country) |
|||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 3: | Line 3: | ||
{{ListOfTables}} | {{ListOfTables}} | ||
| − | = Contenu = | + | = Content/Contenu/Contenido = |
| − | {{flag | + | {{flag en}} Contains the list of countries available. Used to generate drop-down list and filter results. |
| − | {{flag | + | {{flag fr}} Contient la liste des pays disponibles. Utilisée pour générer des listes déroulantes et filtrer des résultats. |
{{flag sp}} Contiene la lista de paises disponibles. Usada para generar una lista desplegabe y filtrar los resultados. | {{flag sp}} Contiene la lista de paises disponibles. Usada para generar una lista desplegabe y filtrar los resultados. | ||
= Structure = | = Structure = | ||
| − | {| align="left" width="100%" border="0 | + | == 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>Field</b> | ||
|style="background-color: #e9e9ef"| <b>Type</b> | |style="background-color: #e9e9ef"| <b>Type</b> | ||
| Line 23: | Line 24: | ||
| rowid | | rowid | ||
| int(11) | | int(11) | ||
| − | | | + | | NO |
| PRI | | PRI | ||
| − | | | + | | |
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
| Line 35: | Line 36: | ||
| | | | ||
| | | | ||
| − | | | + | | code of country |
|- | |- | ||
| code_iso | | code_iso | ||
| Line 43: | Line 44: | ||
| NULL | | NULL | ||
| | | | ||
| − | | | + | | ISO code of country |
|- | |- | ||
| libelle | | libelle | ||
| Line 51: | Line 52: | ||
| | | | ||
| | | | ||
| − | | | + | | label of country |
|- | |- | ||
| active | | active | ||
| Line 59: | Line 60: | ||
| 1 | | 1 | ||
| | | | ||
| − | | | + | | is the country 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 | ||
| + | | rowid | ||
| + | |- | ||
| + | | idx_c_pays_code | ||
| + | | UNIQUE | ||
| + | | code | ||
| + | |- | ||
| + | | idx_c_pays_libelle | ||
| + | | UNIQUE | ||
| + | | libelle | ||
| + | |- | ||
| + | | idx_c_pays_code_iso | ||
| + | | UNIQUE | ||
| + | | code_iso | ||
| + | |} | ||
Latest revision as of 10:12, 17 March 2016
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL
Content/Contenu/Contenido
Contains the list of countries available. Used to generate drop-down list and filter results.
Contient la liste des pays disponibles. Utilisée pour générer des listes déroulantes et filtrer des résultats.
Contiene la lista de paises disponibles. Usada para generar una lista desplegabe y filtrar los resultados.
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| code | varchar(2) | NO | UNI | code of country | ||
| code_iso | varchar(3) | YES | UNI | NULL | ISO code of country | |
| libelle | varchar(50) | NO | UNI | label of country | ||
| active | tinyint(4) | NO | 1 | is the country active? |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| idx_c_pays_code | UNIQUE | code |
| idx_c_pays_libelle | UNIQUE | libelle |
| idx_c_pays_code_iso | UNIQUE | code_iso |