28,936
edits
Changes
→Table
Line 15:
Line 15:
|-+| tms
−| timestamp
−| NO
−|
−| CURRENT_TIMESTAMP
−|
−| last update date
+
= 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 26:
Line 27:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
Line 35:
Line 36:
| int(11)
| int(11)
| YES
| YES
−|
+| MUL
|
|
|
|
Line 58:
Line 59:
| ref
| ref
| varchar(30)
| varchar(30)
−| no
+| NO
−|
+| UNI
|
|
|
|
Line 66:
Line 67:
| entity
| entity
| int(11)
| int(11)
−|
+| NO
−|
+| UNI
| 1
| 1
|
|
| multi company id
| multi company id
−{{FieldTms}}
−|-
|-
| date_c
| date_c
Line 129:
Line 123:
|-
|-
| duree
| duree
−| double
+| real
| YES
| YES
|
|
−|
+| NULL
|
|
| intervention duration
| intervention duration
Line 167:
Line 161:
|
|
| Model PDF to print
| Model PDF to print
−|}
+|}
+== 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
+|-
+| uk_fichinter_ref
+| UNIQUE
+| ref,entity
+|-
+| idx_fichinter_fk_soc
+| UNIQUE
+| fk_soc
+|}