WebSphere Commerce database table: STORITMFFC

Each row of this table contains information about a BaseItem for a particular Store (or all the Stores in a StoreGroup) and FulfillmentCenter.

Column Descriptions
Column Name Column Type Description
BASEITEM_ID BIGINT NOT NULL The BaseItem.
STOREENT_ID INTEGER NOT NULL The Store or StoreGroup for this row. Attributes in this row apply to the specified Store, or to Stores in the specified StoreGroup that do not have their own row.
FFMCENTER_ID INTEGER NOT NULL The FulfillmentCenter.
SHIPPINGOFFSET INTEGER NOT NULL DEFAULT 86400 An estimate of the number of seconds it takes from the time an OrderItem is released for fulfillment until it is shipped to the customer.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235256120 BASEITEM_ID+STOREENT_ID+FFMCENTER_ID Primary Key
I0000797 FFMCENTER_ID Non-Unique Index
I0000798 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_807 BASEITEM_ID BASEITEM BASEITEM_ID Cascade
F_806 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_805 STOREENT_ID STOREENT STOREENT_ID Cascade
Related reference