← Shopware 5.7.5

Shopware 5.7.5 s_article_configurator_template_prices

Price templates for variant generation — base prices applied when creating variants.

Columns

8 columns

Column Type Nullable Additional
id int(11) unsigned NO Primary Key, auto_increment
template_id int(10) unsigned YES Index
customer_group_key varchar(15) YES Index
from int(10) unsigned NO
to varchar(30) NO
price double NO Default: 0
pseudoprice double YES
percent decimal(10,2) YES

Indexes

4 indexes

Index Name Columns Unique
pricegroup customer_group_key,to No
pricegroup_2 customer_group_key,from No
PRIMARY id Yes
template_id template_id No

Relations (to this table)

1 relations

Local Field Foreign Table Foreign Field
id s_article_configurator_template_prices_attributes template_price_id