Reference > Database > WebSphere Commerce database tables > B
WebSphere Commerce database table: BASEITMDSC
Each row of this table contains language-dependent information for a BaseItem.
Column Name Column Type Description BASEITEM_ID BIGINT NOT NULL The BaseItem. LANGUAGE_ID INTEGER NOT NULL The Language for this information. For a list of language components, see the LANGUAGE table. SHORTDESCRIPTION VARCHAR(254) A brief description of the BaseItem. LONGDESCRIPTION VARCHAR(4000) A detailed description of the BaseItem. LASTUPDATE TIMESTAMP The last time this information was updated. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030302230 BASEITEM_ID+LANGUAGE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_110 BASEITEM_ID BASEITEM BASEITEM_ID Cascade F_109 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade _vcc_freeselect_bottom_