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 Column Description
DESCRIPTION VARCHAR (254)
NULL
Descriptive information about this reservation.
EXPIRATION TIMESTAMP
NULL
The date and time when this reservation will expire.
FFMCENTER_ID INTEGER
NULL
The FulfillmentCenter which holds the reserved inventory.
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.
ITEMSPC_ID BIGINT
NULL
The identifier for the item being reserved.
LASTUPDATE TIMESTAMP
NULL
The last time the row was updated.
QUANTITY INTEGER
NULL
The quantity of the reservation.
STORE_ID INTEGER
NULL
The Store which owns the inventory.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034947850 INVRESERVE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_398 INVRSRVTYP_ID INVRSRVTYP INVRSRVTYP_ID Cascade
F_399 FFMCENTER_ID, ITEMSPC_ID, STORE_ID ITEMFFMCTR FFMCENTER_ID, ITEMSPC_ID, STORE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable