← Shopware 6.7.7.1

Shopware 6.7.7.1 tax_provider

Columns

9 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
active tinyint unsigned NO Default: 1
priority int NO Default: 1
identifier varchar(255) NO Unique
availability_rule_id binary(16) YES Index Foreign Key → rule.id
app_id binary(16) YES Index Foreign Key → app.id
process_url varchar(255) YES
created_at datetime(3) NO
updated_at datetime(3) YES

Indexes

4 indexes

Index Name Columns Unique
availability_rule_id availability_rule_id,active No
fk.tax_provider.app_id app_id No
PRIMARY id Yes
uniq.tax_provider.identifier identifier Yes

Relations (from this table)

2 relations

Local Field Foreign Table Foreign Field
app_id app id
availability_rule_id rule id

Relations (to this table)

1 relations

Local Field Foreign Table Foreign Field
id tax_provider_translation tax_provider_id