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_