Table llx c propalst: Difference between revisions
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
= Structure = | = Structure = | ||
'''Version 1. | == Table == | ||
'''Version 1.1 2009/10/07''' | |||
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | {| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | ||
|style="background-color: #e9e9ef"| <b>Field</b> | |style="background-color: #e9e9ef"| <b>Field</b> | ||
| Line 27: | Line 27: | ||
| NO | | NO | ||
| PRI | | PRI | ||
| | | | ||
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
| Line 54: | Line 54: | ||
| | | | ||
| is the proposal state active? | | is the proposal state active? | ||
|} | |||
== Keys == | |||
'''Version 1.1 2009/10/07''' | |||
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | |||
|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 | |||
|} | |} | ||
Revision as of 15:38, 19 October 2009
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 different possible states of the of commercial proposals.
Contient les différents états possibles des propositions commerciales.
Contiene los diferentes posibles estados de los presupuestos.
Structure
Table
Version 1.1 2009/10/07
| Field | Type | Null | Key | Default | Extra | Description |
| id | int(11) | NO | PRI | auto_increment | technical index | |
| code | varchar(12) | NO | UNI | code of proposal state | ||
| libelle | varchar(30) | YES | NULL | label of proposal state | ||
| active | tinyint(4) | NO | 1 | is the proposal state active? |
Keys
Version 1.1 2009/10/07
| Key | Type | Fields |
| PRIMARY | PRIMARY | id |
| code | UNIQUE | code |