WebSphere Commerce database table: PAYMTHDDSC

WebSphere Commerce database table: PAYMTHDDSC

This table is a site-wide table that contains a short description of the Cashier profiles in each of the supported language. This table is deprecated and is provided for backward compatibility only.

Column Descriptions
Column Name Column Type Description

PAYMTHD_ID INTEGER NOT NULL The unique integer ID of the Cashier profile. Foreign key that references the PAYMTHD_ID column of the PAYMTHD table.

LANGUAGE_ID INTEGER NOT NULL Language ID. Foreign key that references the LANGUAGE_ID column of the LANGUAGE table.

DESCRIPTION VARCHAR(254) Short description of the Cashier profile in the language identified by the language ID.

OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type

SQL060903235226540 LANGUAGE_ID+PAYMTHD_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type

F_574 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

F_575 PAYMTHD_ID PAYMTHD PAYMTHD_ID Cascade

Column Name	Column Type	Description
PAYMTHD_ID	INTEGER NOT NULL	The unique integer ID of the Cashier profile. Foreign key that references the `PAYMTHD_ID` column of the PAYMTHD table.
LANGUAGE_ID	INTEGER NOT NULL	Language ID. Foreign key that references the LANGUAGE_ID column of the LANGUAGE table.
DESCRIPTION	VARCHAR(254)	Short description of the Cashier profile in the language identified by the language ID.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_574	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_575	PAYMTHD_ID	PAYMTHD	PAYMTHD_ID	Cascade