WebSphere Commerce database table: RTNRSNDESC

This table stores the language-dependent description of the return reason codes.

Column Descriptions
Column Name Column Type Description
RTNREASON_ID INTEGER NOT NULL The reason to which this information applies.
LANGUAGE_ID INTEGER NOT NULL The language for which this information applies. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) A description of the reason for the return.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235247420 RTNREASON_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_732 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_733 RTNREASON_ID RTNREASON RTNREASON_ID Cascade
Related reference