xo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
addressmultilinexoview.XOID Implied Constraint R
postxo.xoId FK6xgehomkkfii78g8c7vhsodc R
receipt.xoId FK3c01r7gtw2181lirbcbkrpr2p R
receipt_aud.xoId Implied Constraint R
ship.xoId FKq4t84fl5qy7wd5w9ka7ujqo2m R
ship_aud.xoId Implied Constraint R
shipcartonxoview.XOID Implied Constraint R
xoitem.xoId FK75f34uk5ck2rkthewhi1kc40r R
xoitem_aud.xoId Implied Constraint R
carrierId INT 10 null
carrier.id FKip4a2jx987m76j5i4yi871umq R
carrierServiceId INT 10 √ null
carrierservice.id FKcarrierService R
dateCompleted DATETIME 26 √ null
dateConfirmed DATETIME 26 √ null
dateCreated DATETIME 26 √ null
dateFirstShip DATETIME 26 √ null
dateIssued DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
dateScheduled DATETIME 26 √ null
fromAddress VARCHAR 90 √ null
fromAttn VARCHAR 60 √ null
fromCity VARCHAR 30 √ null
fromCountryId INT 10 √ null
fromLGId INT 10 null
locationgroup.id FK32yiw9aqxue37clcqfl0o2khv R
fromName VARCHAR 41 √ null
fromStateId INT 10 √ null
fromZip VARCHAR 10 √ null
mainLocationTagId BIGINT 19 √ null
tag.id FKjy1lo90ivot3q442g5nmolj8l R
note LONGTEXT 2147483647 √ null
num VARCHAR 25 null
ownerIsFrom BIT 1 null
revisionNum INT 10 √ null
shipToAddress VARCHAR 90 √ null
shipToAttn VARCHAR 60 √ null
shipToCity VARCHAR 30 √ null
shipToCountryId INT 10 √ null
ship.id Implied Constraint R
shipToLGId INT 10 null
locationgroup.id FKrtl3tvftrid2h9r0e15ox3h4u R
shipToName VARCHAR 41 √ null
shipToStateId INT 10 √ null
ship.id Implied Constraint R
shipToZip VARCHAR 10 √ null
statusId INT 10 null
xostatus.id FKcmrrhdyvi726jxi3hxcs4vlhy R
typeId INT 10 null
xotype.id FK754lwoex60ojtipys2gjlj0kt R
userId INT 10 null
sysuser.id FKj46qd352i4o2sfg7enr08msio R
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK32yiw9aqxue37clcqfl0o2khv Performance Asc fromLGId
FK754lwoex60ojtipys2gjlj0kt Performance Asc typeId
FKcarrierService Performance Asc carrierServiceId
FKcmrrhdyvi726jxi3hxcs4vlhy Performance Asc statusId
FKip4a2jx987m76j5i4yi871umq Performance Asc carrierId
FKj46qd352i4o2sfg7enr08msio Performance Asc userId
FKjy1lo90ivot3q442g5nmolj8l Performance Asc mainLocationTagId
FKrtl3tvftrid2h9r0e15ox3h4u Performance Asc shipToLGId
UK3k8plerplmvfuxi38hleohf1p Must be unique Asc num

Relationships

Close relationships within degrees of separation