client

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
accountbooking.client_id FK_3E0BC42E19EB6921R
amazonexportstatus.client_id FK_6BECD65419EB6921R
amazonjob.client_id FK_A585049319EB6921R
amazonorderadjustmentjob.client_id FK_8F4BA2E619EB6921R
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
client_orderdocument.client_id FK_2DEDF87419EB6921R
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
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
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
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
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
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
productprice.client_id FK_1A05706319EB6921R
productstatistics.client_id FK_C1EF9CB219EB6921R
productstock.client_id FK_9BFB04DA19EB6921R
productstockcondition.client_id FK_A96DC5BD19EB6921R
realjob.client_id FK_6F99AF3919EB6921R
realstockjob.client_id FK_E323653119EB6921R
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
vendororder.client_id FK_82C1E65C19EB6921R
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
workflow.client_id FK_65C5981619EB6921R
workflow_client.client_id FK_E641BE9619EB6921C
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

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