customer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
customer.parentId FKieq94r5kgbqax6xo4g45c3txj R
customerparts.customerId FKmgyc0iu98bxjy52d6t4bxc9ho R
customerparts_aud.customerId Implied Constraint R
location.defaultCustomerId FKrm7ei310f0tvnlciel8wlrjaa R
paymentview.customerId Implied Constraint R
poitem.customerId FK3dj4sp3qfhpad5na6a6wtg69o R
poitem_aud.customerId Implied Constraint R
post.customerId FK5ggwlfgchqp0laj8kh1dkujx0 R
pricingrule.customerInclId Implied Constraint R
pricingrule_aud.customerInclId Implied Constraint R
quicklist.customerId FKgwsuqt0yopjq40ybnhuva7prk R
quicklist_aud.customerId Implied Constraint R
receiptitem.customerId FKa6ys8h5icpegfhvvtrqr0l6n3 R
receiptitem_aud.customerId Implied Constraint R
rma.customerId FK4ofrupuw7voc1jgeah3hxvsxq R
rma_aud.customerId Implied Constraint R
shippingemailview.CUSTOMERID Implied Constraint R
so.customerId FKd10kh3o7nusuv0bh378q7nw2t R
so_aud.customerId Implied Constraint R
wallet.customerId FK_wallet_customerId R
wo.customerId FK8jw6dmx7cq2hg6al4yrggugmc R
wo_aud.customerId Implied Constraint R
accountId INT 10 null
account.id FK94bqsq44lb8q1t7yg3p4xbw7r R
accountingHash VARCHAR 30 √ null
accountingId VARCHAR 36 √ null
activeFlag BIT 1 null
carrierServiceId INT 10 √ null
carrierservice.id FK4g00osq6ky1r9nyimx2xsxva9 R
creditLimit DECIMAL 28,9 √ null
currencyId INT 10 √ null
currency.id FKs0r6464d8usongpt7d96x6hwj R
currencyRate DECIMAL 28,9 √ null
dateCreated DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
defaultCarrierId INT 10 √ null
carrier.id FKstgsiyl5p2aqlpu6c4dnj9q5w R
defaultPaymentTermsId INT 10 null
paymentterms.id FKh1kfwowfqhqany0pn3jqnhiy6 R
defaultPriorityId INT 10 √ null
priority.id FKcustomerDefaultPriority R
defaultSalesmanId INT 10 √ null
defaultShipTermsId INT 10 null
shipterms.id FKo7xxd2shpuh9lxg8v4lksy2fm R
jobDepth INT 10 √ null
lastChangedUser VARCHAR 100 √ null
name VARCHAR 41 null
note VARCHAR 256 √ null
number VARCHAR 30 null
parentId INT 10 √ null
customer.id FKieq94r5kgbqax6xo4g45c3txj R
qbClassId INT 10 √ null
qbclass.id FKlr7myb3s9g6ab1k3q9jwerfo6 R
statusId INT 10 null
customerstatus.id FKcc0seu1jhtpcxl9pjyfyseyh5 R
sysUserId INT 10 √ null
sysuser.id Implied Constraint R
taxExempt BIT 1 null
taxExemptNumber VARCHAR 30 √ null
taxRateId INT 10 √ null
taxrate.id FKdjai2kvporlupbtelejvebh21 R
toBeEmailed BIT 1 null
toBePrinted BIT 1 null
url VARCHAR 256 √ null
issuableStatusId INT 10 √ null
issuablestatus.id issuableStatusKey R
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
customerNameIdx Performance Asc name
customerNumberIdx Performance Asc number
FK4g00osq6ky1r9nyimx2xsxva9 Performance Asc carrierServiceId
FK94bqsq44lb8q1t7yg3p4xbw7r Performance Asc accountId
FKcc0seu1jhtpcxl9pjyfyseyh5 Performance Asc statusId
FKcustomerDefaultPriority Performance Asc defaultPriorityId
FKdjai2kvporlupbtelejvebh21 Performance Asc taxRateId
FKh1kfwowfqhqany0pn3jqnhiy6 Performance Asc defaultPaymentTermsId
FKieq94r5kgbqax6xo4g45c3txj Performance Asc parentId
FKlr7myb3s9g6ab1k3q9jwerfo6 Performance Asc qbClassId
FKo7xxd2shpuh9lxg8v4lksy2fm Performance Asc defaultShipTermsId
FKs0r6464d8usongpt7d96x6hwj Performance Asc currencyId
FKstgsiyl5p2aqlpu6c4dnj9q5w Performance Asc defaultCarrierId
issuableStatusKey Performance Asc issuableStatusId
UK_6i1jo7brg3kqpdiw58ye3vasv Must be unique Asc number
UKce8f1dpemolf390y20ijetd7k Must be unique Asc/Asc name + parentId

Relationships

Close relationships within degrees of separation