shipcarton_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKfgcy1niav3yjnjvfspk73wopt R
REVTYPE TINYINT 3 √ null
additionalHandling BIT 1 √ null
carrierId INT 10 √ null
carrier.id Implied Constraint R
cartonNum INT 10 √ null
dateCreated DATETIME 26 √ null
freightAmount DECIMAL 28,9 √ null
freightWeight DECIMAL 28,9 √ null
height DECIMAL 28,9 √ null
insuredValue DECIMAL 28,9 √ null
len DECIMAL 28,9 √ null
orderId INT 10 √ null
orderTypeId INT 10 √ null
ordertype.id Implied Constraint R
shipId INT 10 √ null
ship.id Implied Constraint R
shipperRelease BIT 1 √ null
sizeUOM VARCHAR 30 √ null
sscc VARCHAR 20 √ null
trackingNum VARCHAR 255 √ null
weightUOM VARCHAR 32 √ null
width DECIMAL 28,9 √ null

Indexes

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

Relationships

Close relationships within degrees of separation