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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035118830 | BASEITEM_ID, STOREENT_ID, FFMCENTER_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|