woinstruction_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
REV BIGINT 19 null
revinfo.id FKhj4wsg80h2yi8muieesv64l9 R
REVTYPE TINYINT 3 √ null
bomInstructionItemId BIGINT 19 √ null
bominstructionitem.id Implied Constraint R
dateFirstReady DATETIME 26 √ null
dateLastFulfilled DATETIME 26 √ null
description VARCHAR 256 √ null
details LONGTEXT 2147483647 √ null
name VARCHAR 256 √ null
qtyFulfilled INT 10 √ null
qtyReady INT 10 √ null
sortOrder INT 10 √ null
url VARCHAR 256 √ null
woId INT 10 √ null
wo.id Implied Constraint R
customFields JSON 1073741824 √ null

Indexes

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

Relationships

Close relationships within degrees of separation