qbclass


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
bom.qbClassId FK9idnvlvevjqbuwqrm13adstax R
bom_aud.qbClassId Implied Constraint R
customer.qbClassId FKlr7myb3s9g6ab1k3q9jwerfo6 R
customer_aud.qbClassId Implied Constraint R
locationgroup.qbClassId FKarya0mcflqbxdbxa18jcrtqhl R
locationgroup_aud.qbClassId Implied Constraint R
mo.qbClassId FK2ix4grppwu0yjt19jwrr4wt8s R
mo_aud.qbClassId Implied Constraint R
moitem.qbClassId FKa1mb00b1xd1b1x0hfd7bnujuq R
moitem_aud.qbClassId Implied Constraint R
po.qbClassId FKlb47qhwbc6t1ravynsr45uh8k R
po_aud.qbClassId Implied Constraint R
poitem.qbClassId FKsw0wyn1bfufeaytdc88hsdvhd R
poitem_aud.qbClassId Implied Constraint R
product.qbClassId FKj4pceg5l3atadp8o1ikbnl37f R
product_aud.qbClassId Implied Constraint R
so.qbClassId FK8vbusriy3fhgbfn893wp6d7ia R
so_aud.qbClassId Implied Constraint R
soitem.qbClassId FK7eqs8u2qlc4205xj601tq6fkr R
soitem_aud.qbClassId Implied Constraint R
wo.qbClassId FKjvhddsb9806fi44i4mqidp88s R
wo_aud.qbClassId Implied Constraint R
accountingHash VARCHAR 30 √ null
accountingId VARCHAR 36 √ null
activeFlag BIT 1 null
dateCreated DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
name VARCHAR 31 null
parentId INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
QBClassNameIdx Performance Asc name
QBClassParentIdIdx Performance Asc parentId
UKpewxai5b5r7949a2jybe14jy3 Must be unique Asc/Asc name + parentId

Relationships

Close relationships within degrees of separation