shipping

38 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
commissioncontract.returnShipping_id FK_34122FF466C42665R
customer.shipping_id FK_81398E094887F3F8R
offer.shipping_id FK_29D6873E4887F3F8R
shipping_category.shipping_id FK_9AA3576E4887F3F8C
shipping_country.shipping_id FK_B53BCFA24887F3F8C
shipping_customergroup.shipping_id FK_9282E56B4887F3F8C
shipping_excludedcategory.shipping_id FK_9FF596904887F3F8C
shipping_excludedcountry.shipping_id FK_E3AD22654887F3F8C
shipping_excludedcustomergroup.shipping_id FK_BE3124734887F3F8C
shipping_excludedpayment.shipping_id FK_DDF66F0E4887F3F8C
shipping_excludedproduct.shipping_id FK_6394EFAE4887F3F8C
shipping_objectgroup.shipping_id FK_219B8F6E4887F3F8C
shipping_payment.shipping_id FK_8B6082C94887F3F8C
shipping_product.shipping_id FK_350202694887F3F8C
shipping_saleschannel.shipping_id FK_366DA2194887F3F8C
shippingcost.shipping_id FK_8DB718484887F3F8R
shippingmetafield.shipping_id FK_27594DCF4887F3F8R
shippingpackage.shipping_id FK_C0145594887F3F8R
subscriptioncontract.shipping_id FK_EED229BF4887F3F8R
client_id VARCHAR 36 null
client.id FK_2D1C172419EB6921R
handler VARCHAR 36 null
ident VARCHAR 36 null
title VARCHAR 255 null
metadata LONGTEXT 2147483647 null

(DC2Type:array)

costs DECIMAL 10,2 null
sort INT 10 null
minDeliveryTime INT 10 null
maxDeliveryTime INT 10 null
active BIT 1 1
minProductQuantity DECIMAL 10,3 null
maxProductQuantity DECIMAL 10,3 null
minProductWeight DECIMAL 10,3 null
maxProductWeight DECIMAL 10,3 null
minProductVolume DECIMAL 10,3 null
maxProductVolume DECIMAL 10,3 null
minProductLength DECIMAL 10,3 null
maxProductLength DECIMAL 10,3 null
minProductWidth DECIMAL 10,3 null
maxProductWidth DECIMAL 10,3 null
minProductHeight DECIMAL 10,3 null
maxProductHeight DECIMAL 10,3 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_2D1C172419EB6921 Performance Asc client_id

Relationships