Reference > Database > WebSphere Commerce database tables > P


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 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
SQL100520030408120 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

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search