4,395
edits
Changes
→Structure
Line 15:
Line 15:
= Structure =
= Structure =
+== 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 26:
Line 28:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
Line 42:
Line 44:
| fk_contratdet
| fk_contratdet
| int(11)
| int(11)
−|
+| NO
−|
+| MUL
|
|
|
|
Line 50:
Line 52:
| date
| date
| datetime
| datetime
−|
+| NO
−|
+| MUL
|
|
|
|
Line 58:
Line 60:
| statut
| statut
| smallint(6)
| smallint(6)
−|
+| NO
|
|
|
|
Line 66:
Line 68:
| fk_user_author
| fk_user_author
| int(11)
| int(11)
−|
+| NO
|
|
|
|
Line 79:
Line 81:
|
|
| comentary
| comentary
−|}
+|}
+== 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
+| rowid
+|-
+| idx_contratdet_log_fk_contratdet
+| MULTIPLE
+| fk_contratdet
+|-
+| idx_contratdet_log_date
+| MULTIPLE
+| date
+|}