Table llx c effectif: Difference between revisions
Jump to navigation
Jump to search
m (→Contenu) |
|||
| (5 intermediate revisions by one other user not shown) | |||
| Line 3: | Line 3: | ||
{{ListOfTables}} | {{ListOfTables}} | ||
= Content/Contenu = | = Content/Contenu/Contenido = | ||
{{flag en}} Contains ranges of number of employees in a company. Used to generate drop-down lists | |||
{{flag fr}} Contient les différentes tranches de nombres d'employés dans une entreprise. Utilisée pour générer des listes déroulantes. | {{flag fr}} Contient les différentes tranches de nombres d'employés dans une entreprise. Utilisée pour générer des listes déroulantes. | ||
{{flag sp}} Contiene los rangos de número de empleados en una empresa. Se usa para genarar las listas desplegables | {{flag sp}} Contiene los rangos de número de empleados en una empresa. Se usa para genarar las listas desplegables | ||
= 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 21: | Line 22: | ||
|style="background-color: #e9e9ef"| <b>Description</b> | |style="background-color: #e9e9ef"| <b>Description</b> | ||
|- | |- | ||
| | | id | ||
| int(11) | | int(11) | ||
| | | NO | ||
| PRI | | PRI | ||
| | | | ||
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
|- | |- | ||
| code | |||
| varchar(12) | |||
| NO | |||
| UNI | |||
| | |||
| | |||
| code of range | |||
|- | |||
| libelle | |||
| varchar(30) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| label of range | |||
|- | |||
| active | |||
| tinyint(4) | |||
| NO | |||
| | |||
| 1 | |||
| | |||
| Is the range 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 | |||
| UNIQUE | |||
| code | |||
|} | |||
Latest revision as of 10:04, 19 July 2011
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 ranges of number of employees in a company. Used to generate drop-down lists
Contient les différentes tranches de nombres d'employés dans une entreprise. Utilisée pour générer des listes déroulantes.
Contiene los rangos de número de empleados en una empresa. Se usa para genarar las listas desplegables
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| id | int(11) | NO | PRI | auto_increment | technical index | |
| code | varchar(12) | NO | UNI | code of range | ||
| libelle | varchar(30) | YES | NULL | label of range | ||
| active | tinyint(4) | NO | 1 | Is the range active? |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | id |
| code | UNIQUE | code |