Reference > Database > WebSphere Commerce database tables > S


WebSphere Commerce database table: STLFFMREL

This table holds relationships between store location and fulfillment center.

Column Name Column Type Description
STLFFMREL_ID INTEGER NOT NULL Unique ID and primary key
STLOC_ID INTEGER NOT NULL The identifier to physical store.
FFMCENTER_ID INTEGER NOT NULL The reference number for the fulfillment center that represents the fulfillment for the specified store
ADDRESS_ID BIGINT NOT NULL The address of the physical store as stored in the Address table. This is typically used as the shipping address for items that are for in-store pickup.
OPTCOUNTER SMALLINT Reserved IBM Internal Use

Indexes
Index Name Indexed Column Names Index Type
I0001220 STLOC_ID+FFMCENTER_ID Unique Index
SQL100520030431810 STLFFMREL_ID Primary Key
I0001221 FFMCENTER_ID Non-Unique Index
I0001222 ADDRESS_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_3580 ADDRESS_ID ADDRESS ADDRESS_ID Cascade
F_3579 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_3578 STLOC_ID STLOC STLOC_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search