4,395
edits
Table llx c departements: Difference between revisions
Jump to navigation
Jump to search
→Structure
| Line 20: | 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 28: | Line 29: | ||
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
|- | |||
| code_departement | |||
| varchar(6) | |||
| | |||
| | |||
| | |||
| | |||
| code of departement | |||
|- | |||
| fk_region | |||
| int(11) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| ID of region ([[Table llx_c_regions|llx_c_regions]]->code_region) | |||
|- | |||
| cheflieu | |||
| varchar(7) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| Postal Code of circonscription of departement | |||
|- | |||
| tncc | |||
| int(11) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| ID of ncc | |||
|- | |||
| ncc | |||
| varhcar(50) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| ncc | |||
|- | |||
| nom | |||
| varhcar(50) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| Name of departement | |||
|- | |||
| active | |||
| tinyint(4) | |||
| | |||
| | |||
| 1 | |||
| | |||
| Is the departement active? | |||
|} | |} | ||