Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: INVCNFREL
Each row represents the relationship of an item and/or location with an inventory configuration.
Column Name Column Type Description INVCNFREL_ID BIGINT NOT NULL Internal ID of this relationship. INVCNF_ID BIGINT NOT NULL The inventory configuration ID. CATENTRY_ID BIGINT The catalog entry ID. A value of NULL means that this relationship applies to all items at the location specified. A value of NULL for CATENTRY_ID, STORE_ID and STLOC_ID means that this relationship applies to all items at all locations. STORE_ID INTEGER The online store ID. Either this or the physical store ID can be specified, but not both. A value of NULL for both STORE_ID and STLOC_ID means that this relationship applies to the item at all locations. A value of NULL for CATENTRY_ID, STORE_ID and STLOC_ID means that this relationship applies to all items at all locations. STLOC_ID INTEGER The physical store ID. Either this or the online store ID can be specified, but not both. A value of NULL for both STORE_ID and STLOC_ID means that this relationship applies to the item at all locations. A value of NULL for CATENTRY_ID, STORE_ID and STLOC_ID means that this relationship applies to all items at all locations. OPTCOUNTER SMALLINT Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type I0001227 CATENTRY_ID+STORE_ID+STLOC_ID Unique Index SQL100520030345930 INVCNFREL_ID Primary Key I0001228 STORE_ID Non-Unique Index I0001229 STLOC_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3586 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_3589 INVCNF_ID INVCNF INVCNF_ID Cascade F_3588 STLOC_ID STLOC STLOC_ID Cascade F_3587 STORE_ID STORE STORE_ID Cascade _vcc_freeselect_bottom_