Line 6:
Line 6:
{{ListOfTables}}
{{ListOfTables}}
−
= Contenu =
+
= Content/Contenu/Contenido =
+
{{flag en}} Contains the log details of contrats. This table is linked to [[Table llx_contratdet]]
+
+
{{flag fr}} Contient les détails du log des contrats, cette table est liée avec la [[Table llx_contrat]]
+
+
{{flag sp}} Contiene los detalles de log de los contratos, esta tabla está vinculada con [[Table llx_contratdet]]
= Structure =
= Structure =
Line 26:
Line 31:
| auto_increment
| auto_increment
| technical index
| technical index
+
|-
+
| tms
+
| timestamp
+
| NO
+
|
+
| CURRENT_TIMESTAMP
+
|
+
| last update date
+
|-
+
| fk_contratdet
+
| int(11)
+
|
+
|
+
|
+
|
+
| ID of contratdet ([[Table llx_contratdet|llx_contratdet]]->rowid)
+
|-
+
| date
+
| datetime
+
|
+
|
+
|
+
|
+
| date of order
+
|-
+
| statut
+
| smallint(6)
+
|
+
|
+
|
+
|
+
| state
+
|-
+
| fk_user_author
+
| int(11)
+
|
+
|
+
|
+
|
+
| ID creator user ([[Table llx_user|llx_user]]->rowid)
+
|-
+
| comentaire
+
| text
+
| YES
+
|
+
| NULL
+
|
+
| comentary
|}
|}