Shopware 5.7.19 s_articles_prices
Product prices — graduated/quantity pricing per customer group and variant.
| Column | Type | Nullable | Additional |
| id | int(11) unsigned | NO | Primary Key, auto_increment |
| pricegroup | varchar(15) | YES | Index |
| from | int(10) unsigned | NO | |
| to | varchar(30) | NO | |
| articleID | int(11) | NO | Index, Default: 0 |
| articledetailsID | int(11) | NO | Index, Default: 0 |
| price | double | NO | Default: 0 |
| pseudoprice | double | YES | |
| regulation_price | double | YES | |
| baseprice | double | YES | |
| percent | decimal(10,2) | YES | |
| Index 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 |
Relations (to this table)
1 relations
