Reference > Database > WebSphere Commerce database tables > P


WebSphere Commerce database table: PLCYACCDSC

This table holds language-dependent information related to an account policy.

Column Name Column Type Description
PLCYACCT_ID INTEGER NOT NULL The ID of the Account Policy, foreign key to the PLCYACCT table.
LANGUAGE_ID INTEGER NOT NULL The ID of the language foreign key to the LANGUAGE table. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) The name for the account policy.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030409930 PLCYACCT_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_597 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_598 PLCYACCT_ID PLCYACCT PLCYACCT_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search