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 Related reference
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