Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: INVRESERVE
Each row contains information about existing inventory that has been reserved for such purposes as auctions. This reserved inventory is not available for customer orders until the reservation is reversed.
Column Name Column Type Description INVRESERVE_ID BIGINT NOT NULL System generated unique identifier. INVRSRVTYP_ID BIGINT NOT NULL The type or purpose of the reservation, such as an auction. The types are user defined and are in the INVRSRVTYP table. QUANTITY INTEGER The quantity of the reservation. DESCRIPTION VARCHAR(254) Descriptive information about this reservation. EXPIRATION TIMESTAMP The date and time when this reservation will expire. ITEMSPC_ID BIGINT The identifier for the item being reserved. LASTUPDATE TIMESTAMP The last time the row was updated. STORE_ID INTEGER The Store which owns the inventory. FFMCENTER_ID INTEGER The FulfillmentCenter which holds the reserved inventory. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030346390 INVRESERVE_ID Primary Key I0001260 ITEMSPC_ID+STORE_ID+FFMCENTER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_398 INVRSRVTYP_ID INVRSRVTYP INVRSRVTYP_ID Cascade F_399 ITEMSPC_ID STORE_ID FFMCENTER_ID ITEMFFMCTR ITEMSPC_ID Cascade
Related reference
_vcc_freeselect_bottom_