shipitem


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
postpoitem.shipItemId FK4g1wam0l8pq6u28vqoxevnhaa R
postsoitem.shipItemId FKtpttohpps0rm4woo5c9d34tfa R
dateLastModified DATETIME 26 √ null
itemId INT 10 √ null
orderId INT 10 √ null
orderTypeId INT 10 null
ordertype.id FKs5og8s6hkfbdb9jvebmh0sspf R
poItemId INT 10 √ null
poitem.id FK22ksf1230bq10soxnmtswrun6 R
qtyShipped DECIMAL 28,9 √ null
shipCartonId INT 10 null
shipcarton.id FKr0hdcfe5si0lsm0nvwn508vy6 R
shipId INT 10 null
ship.id FK7r8ox8ivljpbcfpcepnh1bx1d R
soItemId INT 10 √ null
soitem.id FKkigiflb3oyfy5oddiwohg4hj1 R
tagId BIGINT 19 √ null
tag.id Implied Constraint R
totalCost DECIMAL 28,9 √ null
uomId INT 10 null
uom.id FK5c6v183gvuwfqvmsokd6usj1m R
xoItemId INT 10 √ null
xoitem.id FKbbjuocl4uqev15e3w8afrpwis R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK22ksf1230bq10soxnmtswrun6 Performance Asc poItemId
FK5c6v183gvuwfqvmsokd6usj1m Performance Asc uomId
FK7r8ox8ivljpbcfpcepnh1bx1d Performance Asc shipId
FKbbjuocl4uqev15e3w8afrpwis Performance Asc xoItemId
FKkigiflb3oyfy5oddiwohg4hj1 Performance Asc soItemId
FKr0hdcfe5si0lsm0nvwn508vy6 Performance Asc shipCartonId
FKs5og8s6hkfbdb9jvebmh0sspf Performance Asc orderTypeId
shipItemOrderIdIdx Performance Asc orderId

Relationships

Close relationships within degrees of separation