pickitem


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
destTagId BIGINT 19 √ null
orderId INT 10 null
orderTypeId INT 10 null
ordertype.id FK6h0grdyvnagipkp69j35cbfe6 R
partId INT 10 null
part.id FK2opakx1e66pm5v4ihd7lyr4rn R
pickId INT 10 null
pick.id FKfrapttns7m4of6t7u4y75cp8s R
poItemId INT 10 √ null
poitem.id FK9u8545r37n3q106tfo5fkaocc R
qty DECIMAL 28,9 √ null
shipId INT 10 √ null
ship.id Implied Constraint R
slotNum INT 10 √ null
soItemId INT 10 √ null
soitem.id FK5wyguawrki4l2caxsjcob9qed R
srcLocationId INT 10 √ null
srcTagId BIGINT 19 √ null
statusId INT 10 null
pickitemstatus.id FK6g66t1jgjcp3lnue79kq7nb68 R
tagId BIGINT 19 √ null
tag.id Implied Constraint R
typeId INT 10 null
pickitemtype.id FK801ec895hy8pbfjh86kht3au8 R
uomId INT 10 null
uom.id FKol3jxjs4xkqvdh297bxh9vmvj R
woItemId INT 10 √ null
woitem.id FKlkklywqjfs2ag5f2wjdlsspon R
xoItemId INT 10 √ null
xoitem.id FKjef6m2q7crenvjo3jb6heg3g1 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK2opakx1e66pm5v4ihd7lyr4rn Performance Asc partId
FK5wyguawrki4l2caxsjcob9qed Performance Asc soItemId
FK6g66t1jgjcp3lnue79kq7nb68 Performance Asc statusId
FK6h0grdyvnagipkp69j35cbfe6 Performance Asc orderTypeId
FK801ec895hy8pbfjh86kht3au8 Performance Asc typeId
FK9u8545r37n3q106tfo5fkaocc Performance Asc poItemId
FKfrapttns7m4of6t7u4y75cp8s Performance Asc pickId
FKjef6m2q7crenvjo3jb6heg3g1 Performance Asc xoItemId
FKlkklywqjfs2ag5f2wjdlsspon Performance Asc woItemId
FKol3jxjs4xkqvdh297bxh9vmvj Performance Asc uomId
pickItemOrderIdIdx Performance Asc orderId
pickItemShipIdIdx Performance Asc shipId

Relationships

Close relationships within degrees of separation