offeritem

27933 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
amazonorderadjustmentjob.offerItem_id FK_8F4BA2E6FDB4FBE0R
offeritemmetafield.offeritem_id FK_6AD9A6B93209C27CR
orderpickingitem.offerItem_id FK_B934F647FDB4FBE0R
orderreturnitem.offerItem_id FK_3E24DCDFFDB4FBE0R
productlicense.offerItem_id FK_CC27523EFDB4FBE0R
shirtnetworkproduct.offerItem_id FK_AE6EEF45FDB4FBE0R
timetracking.offerItem_id FK_88B32207FDB4FBE0R
voucher.saleofferitem_id FK_1392A5D81DF8A1EFR
offer_id VARCHAR 36 null
offer.id FK_7E455D7C53C674EER
product_id VARCHAR 36 null
product.id FK_7E455D7C4584665AR
foreign_id VARCHAR 36 null
sort INT 10 null
quantity DECIMAL 10,3 null
stornoQuantity INT 10 null
sku TINYTEXT 255 null
productTitle LONGTEXT 2147483647 null
variantTitle LONGTEXT 2147483647 null
productParameter LONGTEXT 2147483647 null
productOption LONGTEXT 2147483647 null
price DECIMAL 10,4 null
discount DECIMAL 10,2 null
vat DECIMAL 10,2 null
weight DECIMAL 10,2 null
note LONGTEXT 2147483647 null
storno BIT 1 null
wrapTitle VARCHAR 255 null
giftCardText LONGTEXT 2147483647 null
paymentTransactionId VARCHAR 255 null
giftCardType VARCHAR 255 null
ean VARCHAR 25 null
serialNumber VARCHAR 36 null
saleVoucher BIT 1 null
vendor_id VARCHAR 36 null
vendor.id FK_7E455D7CF603EE73R
vendorOrderItem_id VARCHAR 36 null
vendororderitem.id FK_7E455D7C72AE74BDR
warehouse_id VARCHAR 36 null
warehouse.id FK_7E455D7C5080ECDER
info VARCHAR 255 null
stornoBookingAwaited BIT 1 null
stornoPositionSum DECIMAL 10,2 null
stornoPositionText LONGTEXT 2147483647 null
commissionLiabilityItem_id VARCHAR 36 null
liabilityitem.id FK_7E455D7C968D9E05R
commissionContractItem_id VARCHAR 36 null
commissioncontractitem.id FK_7E455D7C56B55761R
commissionContractReturn_id VARCHAR 36 null
commissioncontract.id FK_7E455D7CAC08CBCR
partialOffer_id VARCHAR 36 null
offer.id FK_7E455D7C5DC0B8C2R
creditNoteNumber VARCHAR 36 null
creditNoteDate DATETIME 19 null
receiptStornoNumber BIGINT 19 null
stornoPositionAccount VARCHAR 12 null
refundedTax DECIMAL 10,2 null
nonDiscountedRefundedTax DECIMAL 10,2 null
fixDiscount DECIMAL 10,2 null
discountPercent DECIMAL 10,2 null
subscriptionContractItem_id VARCHAR 36 null
subscriptioncontractitem.id FK_7E455D7C661C24D9R
discountNote VARCHAR 255 null
altQuantity DECIMAL 10,3 null
skipDiscounts BIT 1 null
saleUnitName VARCHAR 255 null
receiptStornoDate DATETIME 19 null
bestBeforeDate VARCHAR 36 null
taxAccount VARCHAR 12 null
allocated BIT 1 null
purchasePrice DECIMAL 10,4 null
accessoryVoucher_id VARCHAR 36 null
voucher.id FK_7E455D7C6983B0D6R
file VARCHAR 255 null
lastupdated INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_7E455D7C4584665A Performance Asc product_id
IDX_7E455D7C5080ECDE Performance Asc warehouse_id
IDX_7E455D7C53C674EE Performance Asc offer_id
IDX_7E455D7C56B55761 Performance Asc commissionContractItem_id
IDX_7E455D7C5DC0B8C2 Performance Asc partialOffer_id
IDX_7E455D7C661C24D9 Performance Asc subscriptionContractItem_id
IDX_7E455D7C6983B0D6 Performance Asc accessoryVoucher_id
IDX_7E455D7CAC08CBC Performance Asc commissionContractReturn_id
IDX_7E455D7CF603EE73 Performance Asc vendor_id
search_idx Performance Asc foreign_id
UNIQ_7E455D7C72AE74BD Must be unique Asc vendorOrderItem_id
UNIQ_7E455D7C968D9E05 Must be unique Asc commissionLiabilityItem_id

Relationships