4,395
edits
Changes
Jump to navigation
Jump to search
→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_contrat
| fk_contrat
| int(11)
| int(11)
−|
+| NO
−|
+| MUL
|
|
|
|
Line 51:
Line 53:
| int(11)
| int(11)
| YES
| YES
−|
+| MUL
| NULL
| NULL
|
|
Line 82:
Line 84:
| fk_remise_except
| fk_remise_except
| int(11)
| int(11)
−|
+| YES
|
|
| NULL
| NULL
Line 99:
Line 101:
| datetime
| datetime
| YES
| YES
−|
+| MUL
| NULL
| NULL
|
|
Line 107:
Line 109:
| datetime
| datetime
| YES
| YES
−|
+| MUL
| NULL
| NULL
|
|
Line 115:
Line 117:
| datetime
| datetime
| YES
| YES
−|
+| MUL
| NULL
| NULL
|
|
Line 132:
Line 134:
| YES
| YES
|
|
−| 0.00
+| 0.000
|
|
| VAT taxes
| VAT taxes
|-
|-
| qty
| qty
−| double
+| real
−|
+| NO
|
|
|
|
Line 145:
Line 147:
|-
|-
| remise_percent
| remise_percent
−| double
+| real
| YES
| YES
|
|
Line 156:
Line 158:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| unit price
| unit price
|-
|-
| price_ht
| price_ht
−| double
+| real
| YES
| YES
|
|
Line 169:
Line 171:
|-
|-
| remise
| remise
−| double
+| real
| YES
| YES
|
|
Line 180:
Line 182:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| total excluding tax
| total excluding tax
Line 188:
Line 190:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| total tax
| total tax
Line 196:
Line 198:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| total with tax
| total with tax
Line 239:
Line 241:
|
|
| comment
| comment
−|}
+|}
+== 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_fk_contrat
+| MULTIPLE
+| fk_contrat
+|-
+| idx_contratdet_fk_product
+| MULTIPLE
+| fk_product
+|-
+| idx_contratdet_date_ouverture_prevue
+| MULTIPLE
+| date_ouverture_prevue
+|-
+| idx_contratdet_date_ouverture
+| MULTIPLE
+| date_ouverture
+|-
+| idx_contratdet_date_fin_validite
+| MULTIPLE
+| date_fin_validite
+|}