ship_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKafpde4ksy85kli396p8qr5hab R
REVTYPE TINYINT 3 √ null
FOBPointId INT 10 √ null
fobpoint.id Implied Constraint R
billOfLading VARCHAR 20 √ null
carrierId INT 10 √ null
carrier.id Implied Constraint R
carrierServiceId INT 10 √ null
cartonCount INT 10 √ null
contact VARCHAR 250 √ null
dateCreated DATETIME 26 √ null
dateShipped DATETIME 26 √ null
locationGroupId INT 10 √ null
note LONGTEXT 2147483647 √ null
num VARCHAR 35 √ null
orderTypeId INT 10 √ null
ordertype.id Implied Constraint R
ownerIsFrom BIT 1 √ null
poId INT 10 √ null
po.id Implied Constraint R
shipToId INT 10 √ null
ship.id Implied Constraint R
shipmentIdentificationNumber VARCHAR 32 √ null
shippedBy INT 10 √ null
soId INT 10 √ null
so.id Implied Constraint R
statusId INT 10 √ null
xoId INT 10 √ null
xo.id Implied Constraint R
shipToAddress VARCHAR 90 √ null
shipToCity VARCHAR 30 √ null
shipToName VARCHAR 60 √ null
shipToZip VARCHAR 10 √ null
shipToCountryId INT 10 √ null
ship.id Implied Constraint R
shipToStateId INT 10 √ null
ship.id Implied Constraint R
shipToResidential BIT 1 √ null
customFields JSON 1073741824 √ null

Indexes

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

Relationships

Close relationships within degrees of separation