orders

22592 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
accountbooking.order_id FK_3E0BC42E8D9F6D38R
amazoninvoicejob.order_id FK_5B25E6558D9F6D38R
amazonorderadjustmentjob.order_id FK_8F4BA2E68D9F6D38R
amazonordersendjob.order_id FK_199C39F78D9F6D38R
cashreportitem.order_id FK_AA0D8828D9F6D38R
commissioncontract_order.order_id FK_6BF14E868D9F6D38R
contact.order_id FK_4C62E6388D9F6D38R
ebayorderjob.order_id FK_D49D7FD78D9F6D38R
ecreportitem.order_id FK_4313015B8D9F6D38R
hbci.order_id FK_EE3BFE268D9F6D38R
hbci_order.order_id FK_DDB6F5198D9F6D38C
invoiceledgeritem.order_id FK_E952138C8D9F6D38R
liabilityitem.agentOrder_id FK_590A525DD2F28CB9R
offer.order_id FK_29D6873E8D9F6D38R
order_objectgroup.order_id FK_B642774B8D9F6D38C
order_pickingwarehouse.order_id FK_F2D91A2F8D9F6D38C
order_report.order_id FK_7A067518D9F6D38C
orderinternalcomment.order_id FK_764879078D9F6D38R
ordermetafield.order_id FK_5A4EE1D18D9F6D38R
orderpayment.order_id FK_5794735B8D9F6D38R
orderpaymentcondition.order_id FK_6502ABFB8D9F6D38R
orderpicking.order_id FK_395899738D9F6D38R
orderrefund.order_id FK_528A8C398D9F6D38R
orderremind.order_id FK_90B7512C8D9F6D38R
orderreturn.order_id FK_AE38A76E8D9F6D38R
orders.parentOrder_id FK_E52FFDEE72E99A55R
orders.parentShippingOrder_id FK_E52FFDEE1BC170BAR
orders.splittedFromOrder_id FK_E52FFDEE5A494F36R
paypaltransaction.order_id FK_47BECB318D9F6D38R
picklistreservation_orders.order_id FK_786F01CB8D9F6D38C
realinvoicejob.order_id FK_77C5FFB98D9F6D38R
subscriptioncontract.lastOrder_id FK_EED229BF662DD25BR
trackinginfo.order_id FK_C192DB1E8D9F6D38R
vendororder.internalOrder_id FK_82C1E65C18B9AF25R
vendororderdelivery.customerOrder_id FK_44EAB7571C7C4AADR
voucherreportitem.order_id FK_7BED79A28D9F6D38R
warehousestoragelocation.order_id FK_CBC9E6B78D9F6D38R
offer_id VARCHAR 36 √ null
offer.id FK_E52FFDEE53C674EER
client_id VARCHAR 36 √ null
client.id FK_E52FFDEE19EB6921R
created DATETIME 19 null
updated DATETIME 19 null
foreign_id VARCHAR 36 √ null
orderNumber BIGINT 19 null
storno BIT 1 null
invoiceNumber BIGINT 19 √ null
invoiceFile VARCHAR 100 √ null
invoiceDate DATETIME 19 √ null
creditNoteNumber BIGINT 19 √ null
creditNoteFile VARCHAR 100 √ null
creditNoteDate DATETIME 19 √ null
trackingCode VARCHAR 128 √ null
pickList_id VARCHAR 36 √ null
picklist.id FK_E52FFDEE3F473D40R
orderBuyingList_id VARCHAR 36 √ null
orderbuyinglist.id FK_E52FFDEEB9BA2274R
clerk_id INT 10 √ null
users.id FK_E52FFDEED95C1FC6R
receiptNumber BIGINT 19 √ null
receiptDate DATETIME 19 √ null
posTerminal_id VARCHAR 36 √ null
posterminal.id FK_E52FFDEE4BE3C43ER
receiptFile VARCHAR 255 √ null
receiptStornoNumber BIGINT 19 √ null
receiptStornoDate DATETIME 19 √ null
cashReport_id VARCHAR 36 √ null
cashreport.id FK_E52FFDEE856092CER
receiptStornoFile VARCHAR 255 √ null
stornoBookingAwaited BIT 1 null
cashGiven DECIMAL 10,2 √ null
drawback DECIMAL 10,2 √ null
ecReport_id VARCHAR 36 √ null
ecreport.id FK_E52FFDEE5FFE0628R
voucherReport_id VARCHAR 36 √ null
voucherreport.id FK_E52FFDEE79443B8AR
remindDate DATETIME 19 √ null
remindCount INT 10 null
paymentTermDate DATETIME 19 √ null
parentOrder_id VARCHAR 36 √ null
orders.id FK_E52FFDEE72E99A55R
partialNumber INT 10 √ null
agentLiability_id VARCHAR 36 √ null
liability.id FK_E52FFDEEC8CACDD9R
salesChannel_id VARCHAR 36 √ null
saleschannel.id FK_E52FFDEE4C7A5B2ER
reservedField VARCHAR 100 √ null
hasPartialOrders BIT 1 null
paymentInvoiceTermDate DATETIME 19 √ null
ignoreReservation BIT 1 null
otherCreditNoteNumbers VARCHAR 255 √ null
mrnNumber VARCHAR 255 √ null
warehouse_id VARCHAR 36 √ null
warehouse.id FK_E52FFDEE5080ECDER
parentShippingOrder_id VARCHAR 36 √ null
orders.id FK_E52FFDEE1BC170BAR
splittedFromOrder_id VARCHAR 36 √ null
orders.id FK_E52FFDEE5A494F36R
reservedOrderNumber INT 10 √ null
uniqNumber VARCHAR 128 √ null
excludeFromStatistic BIT 1 null
signature VARCHAR 255 √ null
publicKeyObject_id VARCHAR 36 √ null
publickey.id FK_E52FFDEE3B0ABC10R
stornoSignature VARCHAR 255 √ null
stornoPublicKeyObject_id VARCHAR 36 √ null
publickey.id FK_E52FFDEE17458494R
dailyClosingDate DATETIME 19 √ null
invoiceUniqNumber VARCHAR 255 √ null
excludeFromStatisticAllClients BIT 1 null
wormSignature LONGTEXT 2147483647 √ null
stornoWormSignature LONGTEXT 2147483647 √ null
tseTransactionNumber VARCHAR 32 √ null
tseStartDate VARCHAR 20 √ null
tseFinishDate VARCHAR 20 √ null
tseStornoTransactionNumber VARCHAR 32 √ null
tseStornoStartDate VARCHAR 20 √ null
tseStornoFinishDate VARCHAR 20 √ null
tseSerialNumber VARCHAR 255 √ null
tseStornoSerialNumber VARCHAR 255 √ null
cashDiscountNotUsed BIT 1 null
costCenter_id VARCHAR 36 √ null
costcenter.id FK_E52FFDEE43237701R
returnTrackingCode VARCHAR 100 √ null
forceCashDiscount BIT 1 null
customDeliveryNoteNumber INT 10 √ null
uncollectible BIT 1 null
expedition_id VARCHAR 36 √ null
expedition.id FK_E52FFDEE576EF81ER

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
created_idx Performance Asc created
IDX_E52FFDEE17458494 Performance Asc stornoPublicKeyObject_id
IDX_E52FFDEE19EB6921 Performance Asc client_id
IDX_E52FFDEE1BC170BA Performance Asc parentShippingOrder_id
IDX_E52FFDEE3B0ABC10 Performance Asc publicKeyObject_id
IDX_E52FFDEE3F473D40 Performance Asc pickList_id
IDX_E52FFDEE43237701 Performance Asc costCenter_id
IDX_E52FFDEE4BE3C43E Performance Asc posTerminal_id
IDX_E52FFDEE4C7A5B2E Performance Asc salesChannel_id
IDX_E52FFDEE5080ECDE Performance Asc warehouse_id
IDX_E52FFDEE576EF81E Performance Asc expedition_id
IDX_E52FFDEE5A494F36 Performance Asc splittedFromOrder_id
IDX_E52FFDEE5FFE0628 Performance Asc ecReport_id
IDX_E52FFDEE72E99A55 Performance Asc parentOrder_id
IDX_E52FFDEE79443B8A Performance Asc voucherReport_id
IDX_E52FFDEE856092CE Performance Asc cashReport_id
IDX_E52FFDEEB9BA2274 Performance Asc orderBuyingList_id
IDX_E52FFDEEC8CACDD9 Performance Asc agentLiability_id
IDX_E52FFDEED95C1FC6 Performance Asc clerk_id
invoicenumber_idx Performance Asc invoiceNumber
ordernumber_idx Performance Asc orderNumber
receiptnumber_idx Performance Asc receiptNumber
UNIQ_E52FFDEE53C674EE Must be unique Asc offer_id
UNIQ_E52FFDEEA560F403 Must be unique Asc invoiceUniqNumber
UNIQ_E52FFDEEC20EA752 Must be unique Asc uniqNumber

Relationships

Close relationships within degrees of separation