WebSphere Commerce database table: SHIPMODE

Each row of this table represents a ShippingMode for a StoreEntity. A Store can use its own ShippingModes, and the ShippingModes of its StoreGroup.

Column Descriptions
Column Name Column Type Description
SHIPMODE_ID INTEGER NOT NULL Generated unique key.
FIELD1 VARCHAR(254) Customizable.
STOREENT_ID INTEGER NOT NULL The StoreEntity.
FIELD2 INTEGER Customizable.
CODE CHAR(30) A merchant assigned code, unique for the StoreEntity.
CARRIER CHAR(30) Shipping carrier identifier.
TRACKINGNAME VARCHAR(64) Reserved for IBM internal use.
TRACKINGURL VARCHAR(254) Reserved for IBM internal use.
TRACKINGHOST VARCHAR(64) Reserved for IBM internal use.
TRACKINGPORT INTEGER Reserved for IBM internal use.
TRACKINGICON VARCHAR(64) Reserved for IBM internal use.
TRACKINGTYPE CHAR(8) Reserved for IBM internal use.
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000228 STOREENT_ID+CODE+CARRIER Unique Index
SQL060903235250250 SHIPMODE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_745 STOREENT_ID STOREENT STOREENT_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1226 SHIPMODE_ID CALADJUST SHIPMODE_ID Cascade
F_427 SHIPMODE_ID MANIFEST SHIPMODE_ID Cascade
F_509 SHIPMODE_ID ORDERITEMS SHIPMODE_ID Cascade
F_1091 SHIPMODE_ID ORDRELEASE SHIPMODE_ID Cascade
F_1148 SHIPMODE_ID SHIPINFO SHIPMODE_ID Cascade
F_749 SHIPMODE_ID SHPARRANGE SHIPMODE_ID Cascade
F_753 SHIPMODE_ID SHPJCRULE SHIPMODE_ID Cascade
F_928 SHIPMODE_ID SHPMODCLCD SHIPMODE_ID Cascade
F_755 SHIPMODE_ID SHPMODEDSC SHIPMODE_ID Cascade
F_787 SHIPMODE_ID STOREDEF SHIPMODE_ID Cascade
Related reference