Reference > Database > WebSphere Commerce database tables > I


WebSphere Commerce database table: INVRSRVDSC

Each row contains language-specific descriptions for the types of inventory reservations that the user has defined.

Column Name Column Type Description
INVRSRVTYP_ID BIGINT NOT NULL Identifier for the type of reservation.
LANGUAGE_ID INTEGER NOT NULL Language of this description. For a list of language components, see the LANGUAGE table.
NAME VARCHAR(254) A unique name required for MassLoad.
DESCRIPTION VARCHAR(254) Language specific description.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030346610 INVRSRVTYP_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_401 INVRSRVTYP_ID INVRSRVTYP INVRSRVTYP_ID Cascade
F_400 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search