Fields (10)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| pricegroup | varchar(15) | YES | MUL | NULL | |
| from | int(10) unsigned | NO | NULL | ||
| to | varchar(30) | NO | NULL | ||
| articleID | int(11) | NO | MUL | 0 | |
| articledetailsID | int(11) | NO | MUL | 0 | |
| price | double | NO | 0 | ||
| pseudoprice | double | YES | NULL | ||
| baseprice | double | YES | NULL | ||
| percent | decimal(10,2) | YES | NULL |
Indexes (6)
| Name | Columns | Unique |
|---|---|---|
| articledetailsID | articledetailsID | No |
| articleID | articleID | No |
| pricegroup | pricegroup,to,articledetailsID | No |
| pricegroup_2 | pricegroup,from,articledetailsID | No |
| PRIMARY | id | Yes |
| product_prices | articledetailsID,from | No |