customer_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKid3qexmiqlncrl1jv0y18eweg R
REVTYPE TINYINT 3 √ null
accountId INT 10 √ null
account.id Implied Constraint R
accountingHash VARCHAR 30 √ null
accountingId VARCHAR 36 √ null
activeFlag BIT 1 √ null
carrierServiceId INT 10 √ null
creditLimit DECIMAL 28,9 √ null
currencyId INT 10 √ null
currency.id Implied Constraint R
currencyRate DECIMAL 28,9 √ null
dateCreated DATETIME 26 √ null
defaultCarrierId INT 10 √ null
defaultPaymentTermsId INT 10 √ null
defaultPriorityId INT 10 √ null
defaultSalesmanId INT 10 √ null
defaultShipTermsId INT 10 √ null
jobDepth INT 10 √ null
lastChangedUser VARCHAR 100 √ null
name VARCHAR 41 √ null
note VARCHAR 256 √ null
number VARCHAR 30 √ null
parentId INT 10 √ null
qbClassId INT 10 √ null
qbclass.id Implied Constraint R
statusId INT 10 √ null
sysUserId INT 10 √ null
sysuser.id Implied Constraint R
taxExempt BIT 1 √ null
taxExemptNumber VARCHAR 30 √ null
taxRateId INT 10 √ null
taxrate.id Implied Constraint R
toBeEmailed BIT 1 √ null
toBePrinted BIT 1 √ null
url VARCHAR 256 √ null
issuableStatusId INT 10 √ null
issuablestatus.id Implied Constraint R
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc id + REV
FKid3qexmiqlncrl1jv0y18eweg Performance Asc REV

Relationships

Close relationships within degrees of separation