WebSphere Commerce database table: BASEITMDSC

WebSphere Commerce database table: BASEITMDSC

Each row of this table contains language-dependent information for a BaseItem.
Column Descriptions
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
SQL060903235129800 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

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.

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