29,031
edits
Changes
→Table
Line 6:
Line 6:
+
{{ListOfTables}}
{{ListOfTables}}
−= Contenu =
+= Content/Contenu/Contenido =
+{{flag en}} Contains the log of contrats details. This table is linked to [[Table llx_contratdet]]
+
+{{flag fr}} Contient les log des les détails des contrats, cette table est liée avec la [[Table llx_contratdet]]
+
+{{flag sp}} Contiene los log de los detalles de los contratos, esta tabla está vinculada con [[Table llx_contratdet]]
= Structure =
= Structure =
−{| 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"
+== 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 27:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
−|}
+{{FieldTms}}
+|-
+| fk_contratdet
+| int(11)
+| NO
+| MUL
+|
+|
+| ID of contratdet ([[Table llx_contratdet|llx_contratdet]]->rowid)
+|-
+| date
+| datetime
+| NO
+| MUL
+|
+|
+| date of order
+|-
+| statut
+| smallint(6)
+| NO
+|
+|
+|
+| state
+|-
+| fk_user_author
+| int(11)
+| NO
+|
+|
+|
+| ID creator user ([[Table llx_user|llx_user]]->rowid)
+|-
+| comentaire
+| text
+| YES
+|
+| NULL
+|
+| comentary
+|}
+== 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_contratdet_log_fk_contratdet
+| MULTIPLE
+| fk_contratdet
+|-
+| idx_contratdet_log_date
+| MULTIPLE
+| date
+|}