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 Name Column Type Column Description
BASEITEM_ID BIGINT
NOT NULL
The BaseItem.
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.
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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035118830 BASEITEM_ID, STOREENT_ID, FFMCENTER_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_805 STOREENT_ID STOREENT STOREENT_ID Cascade
F_806 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_807 BASEITEM_ID BASEITEM BASEITEM_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable