← Shopware 5.7.9

Shopware 5.7.9 s_premium_dispatch

Shipping method definitions with calculation type, surcharges, and delivery rules.

Columns

27 columns

Column Type Nullable Additional
id int(11) NO Primary Key, auto_increment
name varchar(255) NO
type int(11) unsigned NO
description mediumtext NO
comment varchar(255) NO
active int(1) unsigned NO
position int(11) NO
calculation int(1) unsigned NO
surcharge_calculation int(1) unsigned NO
tax_calculation int(11) unsigned NO
shippingfree decimal(10,2) unsigned YES
multishopID int(11) unsigned YES
customergroupID int(11) unsigned YES
bind_shippingfree int(1) unsigned NO
bind_time_from int(11) unsigned YES
bind_time_to int(11) unsigned YES
bind_instock int(1) unsigned YES
bind_laststock int(1) unsigned NO
bind_weekday_from int(1) unsigned YES
bind_weekday_to int(1) unsigned YES
bind_weight_from decimal(10,3) YES
bind_weight_to decimal(10,3) YES
bind_price_from decimal(10,2) YES
bind_price_to decimal(10,2) YES
bind_sql mediumtext YES
status_link mediumtext YES
calculation_sql mediumtext YES

Indexes

1 indexes

Index Name Columns Unique
PRIMARY id Yes

Relations (to this table)

1 relations

Local Field Foreign Table Foreign Field
id s_premium_dispatch_attributes dispatchID