Difference between revisions of "Table llx product fournisseur price"
Jump to navigation
Jump to search
| 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 | ||
| − | | | + | | |
| 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( | + | | double(24,8) |
| YES | | YES | ||
| | | | ||
| − | | 0 | + | | 0,00000000 |
| | | | ||
| price | | price | ||
| Line 75: | Line 77: | ||
|- | |- | ||
| unitprice | | unitprice | ||
| − | | double( | + | | 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 | ||
| + | |} | ||
Revision as of 09:42, 5 November 2009
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL
Content/Contenu/Contenido
Contains the price of products by each supplier.
Contient les prix des produits de chaque fournisseur.
Contiene los precios de los productos de cada proveedor.
Structure
Table
Version 1.1 2009/10/07
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| datec | datetime | YES | NULL | creation date | ||
| tms | timestamp | NO | CURRENT_TIMESTAMP | last update date | ||
| fk_product_fornisseur | int(11) | NO | MUL | NULL | ID of supplied product (llx_product_fornisseur->rowid) | |
| price | double(24,8) | YES | 0,00000000 | price | ||
| quantity | double | YES | NULL | quantity of product | ||
| unitprice | double(24,8) | YES | 0.00000000 | price unitary | ||
| fk_user | int(11) | YES | MUL | NULL | ID last modifier user (llx_user->rowid) |
Keys
Version 1.1 2009/10/07
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| idx_product_fournisseur_price_fk_user | MULTIPLE | fk_user |
| idx_product_fournisseur_price_fk_product_fournisseur | MULTIPLE | fk_product_fournisseur |