WebSphere Commerce database table: BLKRSNDESC

WebSphere Commerce database table: BLKRSNDESC

Holds Reason code description in different locales
Column Descriptions
Column Name Column Type Description
BLKRSNCODE_ID INTEGER NOT NULL The block reason code for which the language specific description is being provided.
LANGUAGE_ID INTEGER NOT NULL The specific language in which the description is being provided.
DESCRIPTION VARCHAR(254) NOT NULL Description of the reason code
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235131290 BLKRSNCODE_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1221 BLKRSNCODE_ID BLKRSNCODE BLKRSNCODE_ID Cascade
F_1222 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Column Name	Column Type	Description
BLKRSNCODE_ID	INTEGER NOT NULL	The block reason code for which the language specific description is being provided.
LANGUAGE_ID	INTEGER NOT NULL	The specific language in which the description is being provided.
DESCRIPTION	VARCHAR(254) NOT NULL	Description of the reason code
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1221	BLKRSNCODE_ID	BLKRSNCODE	BLKRSNCODE_ID	Cascade
F_1222	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade