client

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
accountbooking.client_id FK_3E0BC42E19EB6921R
amazonasinjob.client_id FK_B7531C3219EB6921R
amazonexportstatus.client_id FK_6BECD65419EB6921R
amazoninvoicejob.client_id FK_5B25E65519EB6921R
amazonjob.client_id FK_A585049319EB6921R
amazonorderadjustmentjob.client_id FK_8F4BA2E619EB6921R
amazonordersendjob.client_id FK_199C39F719EB6921R
amazonstockjob.client_id FK_67F719D219EB6921R
attribute.mainClient_id FK_FA7AEFFB6CF8BF97R
attribute_client.client_id FK_E5A52A0F19EB6921C
attributemetafield.client_id FK_2734999019EB6921R
cashjournal.client_id FK_A7F52B619EB6921R
category.mainClient_id FK_64C19C16CF8BF97R
category_client.client_id FK_C8ACCE2E19EB6921C
categorymetafield.client_id FK_CCC871B19EB6921R
check24job.client_id FK_DEB64E7D19EB6921R
client_orderdocument.client_id FK_2DEDF87419EB6921R
client_pickingwarehouse.client_id FK_B4068BC819EB6921C
clientcontent.client_id FK_52509C9919EB6921R
clientdocument.client_id FK_FE1C2F7619EB6921R
clientsheme.client_id FK_A9EC886119EB6921R
clientvalue.client_id FK_91CEEB4D19EB6921R
commission.client_id FK_1C65015819EB6921R
commissioncontract.client_id FK_34122FF419EB6921R
contact.client_id FK_4C62E63819EB6921R
contentemailattachment_client.client_id FK_94AC664919EB6921C
counter.client_id FK_C122947819EB6921R
countrymetafield.client_id FK_887C52DD19EB6921R
csvexport.client_id FK_DDCE6D9A19EB6921R
csvexportjob.client_id FK_A7D3275E19EB6921R
csvimport.client_id FK_20CB51319EB6921R
csvimportjob.client_id FK_75BCEB0519EB6921R
currencymetafield.client_id FK_8BDE557319EB6921R
customer.client_id FK_81398E0919EB6921R
customer_crossclient.client_id FK_5945883E19EB6921C
customergroupmetafield.client_id FK_79B37F3219EB6921R
customermetafield.client_id FK_9773404F19EB6921R
customform.client_id FK_B25A1FF419EB6921R
customform_crossclient.client_id FK_B6920A3419EB6921C
customformgrid.client_id FK_5565DBF419EB6921R
customformgrid_crossclient.client_id FK_604D605119EB6921C
deletedentity.client_id FK_E99897A219EB6921R
desktopdownloadjob.client_id FK_A824072119EB6921R
discount.mainClient_id FK_E1E0B40E6CF8BF97R
discount_client.client_id FK_A904286A19EB6921C
documentmetafield.client_id FK_3477F23919EB6921R
ean.client_id FK_67B1C66019EB6921R
ebayjob.client_id FK_B7229A6C19EB6921R
ebayorderjob.client_id FK_D49D7FD719EB6921R
ebayproductjob.client_id FK_BA65906319EB6921R
ebaystockjob.client_id FK_54CF73FF19EB6921R
export.client_id FK_428C169419EB6921R
hbci.client_id FK_EE3BFE2619EB6921R
import.client_id FK_9D4ECE1D19EB6921R
invoiceledger.client_id FK_7799189519EB6921R
language.client_id FK_D4DB71B519EB6921R
languagemetafield.client_id FK_D7145B5A19EB6921R
liability.client_id FK_3B59ECCC19EB6921R
mailjob.client_id FK_55EE4AC919EB6921R
maillog.client_id FK_2109C2F419EB6921R
manufacturer.mainClient_id FK_3D0AE6DC6CF8BF97R
manufacturer_client.client_id FK_DAF84AA519EB6921C
manufacturermetafield.client_id FK_3E6E93F619EB6921R
materialpicklist.client_id FK_178061B119EB6921R
offer.client_id FK_29D6873E19EB6921R
offeritemmetafield.client_id FK_6AD9A6B919EB6921R
offermetafield.client_id FK_C2CBB30219EB6921R
orderbuyinglist.client_id FK_ACE681BA19EB6921R
ordermetafield.client_id FK_5A4EE1D119EB6921R
orderpicking.client_id FK_3958997319EB6921R
orderreturn.client_id FK_AE38A76E19EB6921R
orders.client_id FK_E52FFDEE19EB6921R
orderstatus.client_id FK_72A6FD7D19EB6921R
ottojob.client_id FK_1BAF341519EB6921R
ottostockjob.client_id FK_E6E6E44119EB6921R
ottotask.client_id FK_8C25323419EB6921R
payment_excludedclient.client_id FK_5983CAC219EB6921C
paymentmetafield.client_id FK_FB70410819EB6921R
picklist.client_id FK_D2525B6319EB6921R
printjob.client_id FK_5BB8166419EB6921R
product.mainClient_id FK_D34A04AD6CF8BF97R
product_client.client_id FK_A53845F119EB6921C
productmetafield.client_id FK_700669F719EB6921R
productoption.mainClient_id FK_71E297706CF8BF97R
productoption_client.client_id FK_53EB464019EB6921C
productoptionmetafield.client_id FK_14D1516719EB6921R
productpicturemetafield.client_id FK_9C26741D19EB6921R
productprice.client_id FK_1A05706319EB6921R
productsalecondition.client_id FK_5A9D614B19EB6921R
productstatistics.client_id FK_C1EF9CB219EB6921R
productstock.client_id FK_9BFB04DA19EB6921R
productstockcondition.client_id FK_A96DC5BD19EB6921R
realinvoicejob.client_id FK_77C5FFB919EB6921R
realjob.client_id FK_6F99AF3919EB6921R
realproductjob.client_id FK_1BC8681E19EB6921R
realsendorderjob.client_id FK_898D313119EB6921R
realstockjob.client_id FK_E323653119EB6921R
realstornojob.client_id FK_A452DE7C19EB6921R
report.client_id FK_C42F778419EB6921R
reportjob.client_id FK_D64B810819EB6921R
retailstore.client_id FK_1364CE6B19EB6921R
retailstore_crossclient.client_id FK_E3ED040619EB6921C
scaleprice.client_id FK_9F9E261519EB6921R
shipping.client_id FK_2D1C172419EB6921R
shippingmetafield.client_id FK_27594DCF19EB6921R
shirtnetworkprintjob.client_id FK_F51458C519EB6921R
shirtnetworkproduct.client_id FK_AE6EEF4519EB6921R
statemetafield.client_id FK_844565C719EB6921R
store.client_id FK_FF57587719EB6921R
subscriptioncontract.client_id FK_EED229BF19EB6921R
taxmetafield.client_id FK_5B22A2DE19EB6921R
user_client.client_id FK_A2161F6819EB6921R
usermetafield.client_id FK_5B3BE76019EB6921R
vendor_client.client_id FK_B18E03C719EB6921C
vendorconditions.internalClient_id FK_739D79357A78233AR
vendormetafield.client_id FK_66A5089119EB6921R
vendororder.client_id FK_82C1E65C19EB6921R
vendororderitemmetafield.client_id FK_61F4C9A519EB6921R
voucherserie.mainClient_id FK_F67263976CF8BF97R
voucherserie_client.client_id FK_BA672C4419EB6921C
warehouse.defaultInClient_id FK_ECB38BFC5FD7F972R
warehouse_client.client_id FK_2210DB2419EB6921C
warehouse_excludedclient.client_id FK_F6F1902A19EB6921C
warehousebooking.bookedInClient_id FK_FC6BD52C2B7E3CCCR
webshopexportjob.client_id FK_D176C3EB19EB6921R
webshopimportjob.client_id FK_3190FB019EB6921R
webshopproductexportjob.client_id FK_B28DD7619EB6921R
workflow.client_id FK_65C5981619EB6921R
workflow_client.client_id FK_E641BE9619EB6921C
workflow_crossclient.client_id FK_C2048CB19EB6921C
workflowactionjob.client_id FK_E5086F8719EB6921R
country_id VARCHAR 36 √ null
country.id FK_C7440455F92F3E70R
foreign_id VARCHAR 36 √ null
title VARCHAR 255 null
company VARCHAR 255 √ null
email VARCHAR 255 √ null
executive VARCHAR 255 √ null
salutation VARCHAR 30 √ null
firstName VARCHAR 255 √ null
lastName VARCHAR 255 √ null
street VARCHAR 255 √ null
city VARCHAR 255 √ null
zip VARCHAR 16 √ null
vatId VARCHAR 16 √ null
phone VARCHAR 128 √ null
fax VARCHAR 128 √ null
shopUrl VARCHAR 255 √ null
shopUser VARCHAR 255 √ null
shopPassword VARCHAR 255 √ null
ident VARCHAR 32 √ null
intrashipId VARCHAR 32 √ null
hbciAccount VARCHAR 32 √ null
VARCHAR 255 √ null
ftpServer VARCHAR 255 √ null
ftpUserName VARCHAR 255 √ null
ftpPassword VARCHAR 255 √ null
ftpPath VARCHAR 255 √ null
smtpEmailAddress VARCHAR 255 √ null
smtpUserName VARCHAR 255 √ null
smtpPassword VARCHAR 255 √ null
smtpHost VARCHAR 255 √ null
imapUserName VARCHAR 255 √ null
imapPassword VARCHAR 255 √ null
imapHost VARCHAR 255 √ null
currency VARCHAR 255 √ null
accountHolder VARCHAR 255 √ null
bankName VARCHAR 255 √ null
bankCode VARCHAR 255 √ null
bankNumber VARCHAR 255 √ null
bicCode VARCHAR 255 √ null
ibanNumber VARCHAR 255 √ null
orderNumberRange VARCHAR 255 √ null
hrbNumber VARCHAR 255 √ null
court VARCHAR 255 √ null
manageStock BIT 1 √ null
defaultVat DECIMAL 10,2 null
showCostsInNetto BIT 1 null
defaultCurrency_id VARCHAR 36 √ null
currency.id FK_C744045595D0AABAR
invoiceNumberRange VARCHAR 255 √ null
devMode BIT 1 null
additionalCostName VARCHAR 255 √ null
additionalCost2Name VARCHAR 255 √ null
additionalCost3Name VARCHAR 255 √ null
additionalCost4Name VARCHAR 255 √ null
additionalCost5Name VARCHAR 255 √ null
notSendMailsOnOrderPlaced BIT 1 √ null
shopType INT 10 √ null
usePricesAsNetto INT 10 √ null
transferDirectOnStores BIT 1 √ null
smtpSSL BIT 1 √ null
libreOfficePath VARCHAR 255 √ null
accountSystem_id VARCHAR 36 √ null
accountsystem.id FK_C744045546A0AD0R
phpExecutable VARCHAR 255 √ null
phpIniFile VARCHAR 255 √ null
firstInvoiceNumber VARCHAR 255 √ null
firstReceivableAccount VARCHAR 255 √ null
firstCreditorAccount VARCHAR 255 √ null
mysqlExecutable VARCHAR 255 √ null
mysqldumpExecutable VARCHAR 255 √ null
commissionContractNumberRange VARCHAR 255 √ null
customerNumberMask VARCHAR 255 √ null
calcStockOnCombinedProducts BIT 1 √ null
currencyPrecision INT 10 √ null
sepaCreditorNumber VARCHAR 255 √ null
cc VARCHAR 255 √ null
defaultDeliveryStatus INT 10 √ null
liabilityCurrencyPrecision INT 10 √ null
blocked BIT 1 null
clientUrl VARCHAR 255 √ null
smtpPort VARCHAR 255 √ null
smtpEncryption VARCHAR 255 √ null
imapPort VARCHAR 255 √ null
imapEncryption VARCHAR 255 √ null
paymentInvoiceNumberRange VARCHAR 255 √ null
firstPaymentInvoiceNumber VARCHAR 255 √ null
paymentCreditNoteNumberRange VARCHAR 255 √ null
firstPaymentCreditNoteNumber VARCHAR 255 √ null
creditNoteNumberRange VARCHAR 255 √ null
firstCreditNoteNumber VARCHAR 255 √ null
refundsOnlyManually BIT 1 null
acquisitionCostsPercent DECIMAL 10,4 √ null
excludeFromStatisticAllClients BIT 1 null
bcc VARCHAR 255 √ null
ftpPassive BIT 1 null
warehouseBookingReason1Name VARCHAR 32 √ null
warehouseBookingReason2Name VARCHAR 32 √ null
warehouseBookingReason3Name VARCHAR 32 √ null
warehouseBookingReason4Name VARCHAR 32 √ null
warehouseBookingReason5Name VARCHAR 32 √ null
warehouseBookingReason6Name VARCHAR 32 √ null
warehouseBookingReason7Name VARCHAR 32 √ null
warehouseBookingReason8Name VARCHAR 32 √ null
warehouseBookingReason9Name VARCHAR 32 √ null
warehouseBookingReason10Name VARCHAR 32 √ null
adjustNegativeBookings BIT 1 √ null
minStockFormula VARCHAR 255 √ null
maxStockFormula VARCHAR 255 √ null
searchInProductFields VARCHAR 255 √ null
purchasePriceCalculatingType INT 10 null
defaultReturnAction VARCHAR 2 √ null
dashboardStatisticsDateType INT 10 √ null
dashboardStatisticsWhereDql VARCHAR 255 √ null
dashboardStatisticsJoinDql VARCHAR 255 √ null
dashboardStatisticsTotalDql LONGTEXT 2147483647 √ null
minStockForFormula VARCHAR 255 √ null
excludeShippedOrdersInTodayStatistics BIT 1 null
sortPickListBySerialNumbers BIT 1 null
partialRefundWithCashDiscount BIT 1 null
useOfferItemWeightWithMaterials BIT 1 null
orderReservationOnlyThisClient BIT 1 null
logWorkflowActions BIT 1 null
calcMinimumScalePrice BIT 1 null
nonEUReplacementsWithFullDiscount BIT 1 null
sortProductsInSearchBy INT 10 √ null
glnNumber VARCHAR 128 √ null
useNettoPricesForOss BIT 1 null
deliveryNoteNumberRange VARCHAR 255 √ null
customSalesChannelStock LONGTEXT 2147483647 √ null
serialNumberForMixedBookings VARCHAR 255 √ null
additionalColumnsForCSVInventory LONGTEXT 2147483647 √ null
offerNumberRange VARCHAR 255 √ null
searchableEntitiesArray LONGTEXT 2147483647 √ null
numberFormulaForSortPickListBySerialNumbers VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_C744045546A0AD0 Performance Asc accountSystem_id
IDX_C744045595D0AABA Performance Asc defaultCurrency_id
IDX_C7440455F92F3E70 Performance Asc country_id
UNIQ_C744045544E78B2 Must be unique Asc ident

Relationships

Close relationships within degrees of separation