wo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
postwo.woId FK2vcwirrpagvu5j33ukoem4a1x R
woassignedusers.woId FKdde9bvwljl4lv4ubssv71lhqe R
woassignedusers_aud.woId Implied Constraint R
woinstruction.woId FK3qrfcxtoit3u8vvgbe7qo4qxl R
woinstruction_aud.woId Implied Constraint R
woitem.woId FKr6a3dddbfponms402wdayp9c3 R
woitem_aud.woId Implied Constraint R
womoview.WOID Implied Constraint R
calCategoryId INT 10 √ null
calcategory.id FK4rgrqmd8t44871m5p4m663edn R
cost DECIMAL 28,9 √ null
customerId INT 10 √ null
customer.id FK8jw6dmx7cq2hg6al4yrggugmc R
dateCreated DATETIME 26 √ null
dateFinished DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
dateScheduled DATETIME 26 √ null
dateScheduledToStart DATETIME 26 √ null
dateStarted DATETIME 26 √ null
locationGroupId INT 10 √ null
locationgroup.id FKp1jvxjqnx6dx1h8469k5xa02d R
locationId INT 10 √ null
location.id FKehkprc6rewqtagth6wrob57jb R
moItemId INT 10 null
moitem.id FK5mifl1way9iwh9v1ql41o261m R
note LONGTEXT 2147483647 √ null
num VARCHAR 30 null
priorityId INT 10 null
priority.id FK5toym0tqqujop26pc6vn7i7f5 R
qbClassId INT 10 √ null
qbclass.id FKjvhddsb9806fi44i4mqidp88s R
qtyOrdered INT 10 √ null
qtyScrapped INT 10 √ null
qtyTarget INT 10 √ null
statusId INT 10 null
wostatus.id FKj4v67oqha89tpafmpm6cbto19 R
userId INT 10 null
sysuser.id FK7auqtn6or120su6keupf6b14n R
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK4rgrqmd8t44871m5p4m663edn Performance Asc calCategoryId
FK5mifl1way9iwh9v1ql41o261m Performance Asc moItemId
FK5toym0tqqujop26pc6vn7i7f5 Performance Asc priorityId
FK7auqtn6or120su6keupf6b14n Performance Asc userId
FK8jw6dmx7cq2hg6al4yrggugmc Performance Asc customerId
FKehkprc6rewqtagth6wrob57jb Performance Asc locationId
FKj4v67oqha89tpafmpm6cbto19 Performance Asc statusId
FKjvhddsb9806fi44i4mqidp88s Performance Asc qbClassId
FKp1jvxjqnx6dx1h8469k5xa02d Performance Asc locationGroupId
UKa9dug46v3ybtjdsa90jkp0n7h Must be unique Asc num

Relationships

Close relationships within degrees of separation