4,395
edits
Changes
Jump to navigation
Jump to search
Table llx product fournisseur price (view source)
Revision as of 09:42, 5 November 2009
, 15 years ago→Structure
Line 17:
Line 17:
= 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 28:
Line 30:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
Line 53:
Line 55:
| int(11)
| int(11)
| NO
| NO
−|
+| MUL
| NULL
| NULL
|
|
Line 59:
Line 61:
|-
|-
| price
| price
−| double(28,10)
+| double(24,8)
| YES
| YES
|
|
−| 0
+| 0,00000000
|
|
| price
| price
Line 75:
Line 77:
|-
|-
| unitprice
| unitprice
−| double(28,10)
+| double(24,8)
| YES
| YES
|
|
−| 0
+| 0.00000000
|
|
| price unitary
| price unitary
Line 85:
Line 87:
| int(11)
| int(11)
| YES
| YES
−|
+| MUL
| NULL
| NULL
|
|
| ID last modifier user ([[Table llx_user|llx_user]]->rowid)
| ID last modifier user ([[Table llx_user|llx_user]]->rowid)
−|}
+|}
+== 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_product_fournisseur_price_fk_user
+| MULTIPLE
+| fk_user
+|-
+| idx_product_fournisseur_price_fk_product_fournisseur
+| MULTIPLE
+| fk_product_fournisseur
+|}