order - Laravel Schema Designer

plenty_order

id increments
typeId ^FK integer
plentyId integer
methodOfPayment integer
statusId ^FK integer
shippingProfile integer
ownerId integer
updatedAt timestamp
createdAt timestamp

plenty_order_position

id increments
orderId ^FK integer
typeId ^FK integer
referrer decimal (5,2)
variationId integer
variationQuantity decimal (8,2)
varitionName string (256)
attributeValues string (256)
characterValues string (256)
shippingProfil_xxx string
warehouseId_xxxx integer
updatedAt timestamps
createdAt timestamp

plenty_order_position_option

id increments
orderPositionId ^FK integer
typeId ^FK integer
subTypeId ^FK integer
value string (128)
updatedAt timestamps
createdAt timestamps

plenty_order_option_type

id increments
nonErasable tinyInteger
position integer

plenty_order_option_sub_type

id increments
nonErasable tinyInteger
position integer

plenty_order_amount

id increments
orderId ^FK integer
isSystemCurrency tinyInteger
isNet tinyInteger
currency string (3)
exchangeRatio decimal (12,6)
netTotal decimal (11,2)
grossTotal decimal (11,2)
vatTotal decimal (11,2)
invoiceTotal decimal (11,2)
paidAmount decimal (11,2)
prepaidAmount decimal (11,2)
updatedAt timestamps
createdAt timestamp

plenty_order_option

id increments
orderId ^FK integer
typeId ^FK integer
subTypeId ^FK integer
value string (128)
updatedAt timestamp
createdAt timestamp

plenty_order_option_sub_type_name

id increments
subTypeId ^FK integer
lang string (2)
name string (64)

plenty_order_option_type_name

id increments
typeId ^FK integer
lang string (2)
name string (64)

plenty_order_date_option

id increments
orderId ^FK integer
typeId ^FK integer
date timestamp
createdAt timestamps
updatedAt timestamp

plenty_order_position_date_option

id increments
orderPositionId ^FK integer
typeId ^FK integer
date timestamp
createdAt timestamps
updatedAt timestamp

plenty_order_date_option_type

id increments
nonErasable tinyInteger
position integer

plenty_order_date_option_type_name

id increments
typeId ^FK integer
lang string (2)
name string (64)

plenty_order_reference

id increments
orderId ^FK integer
referenceOrder ^FK integer
isParent tinyInteger
createdAt timestamp
updatedAt timestamps

plenty_order_position_reference

id increments
referenceOrderPosition ^FK integer
orderPositionId ^FK integer
referenceQuantity decimal (8,2)
isParent tinyInteger
updatedAt timestamps
createdAt timestamp

plenty_order_type

id increments
nonErasable tinyInteger
position integer

plenty_order_type_name

id increments
typeId ^FK integer
lang string (2)
name string (64)

plenty_order_position_type

id increments
nonErasable tinyInteger
position integer

plenty_order_position_type_name

id increments
typeId ^FK integer
lang string (2)
name string (64)

plenty_order_status_name

id increments
statusId ^FK integer
lang string (2)
backendName string (64)
frontendVisibility tinyInteger
frontendName string (64)

plenty_order_status

id increments
status decimal (6,4)
nonErasable tinyInteger

plenty_order_amount_vat

id increments
orderAmountId ^FK integer
countryVatId integer
vatId integer
vatAmount decimal (4,2)
value decimal (13,4)
updatedAt timestamps
createdAt timestamp

plenty_order_position_amount

id increments
orderPositionId ^FK integer
isSystemCurrency tinyInteger
countryVatId integer
vatId integer
currency string (3)
exchangeRatio decimal (12,6)
vatAmount decimal (4,2)
priceOriginalGross decimal (13,4)
priceGross decimal (13,4)
markup decimal (11,2)
rabate decimal (11,2)
isPercentel tinyInteger
createdAt timestamps
updatedAt timestamps

plenty_event_type_name

id increments
typeId ^FK integer
lang string (2)
name string (64)

plenty_event_source_name

id increments
sourceId ^FK integer
lang string (2)
name string (64)

plenty_event_type

id increments
backendName string (64)
nonErasable tinyInteger

plenty_event_source

id increments
nonErasable tinyInteger

plenty_order_event

id increments
orderId ^FK integer
eventTypeId ^FK integer
ownerId integer
statusId ^FK integer
eventSourceId ^FK integer
message string
createdAt timestamps