Reference > Database > WebSphere Commerce database tables > P


WebSphere Commerce database table: PLCYTYPDSC

This table describes the type of business policy for a policy.

Column Name Column Type Description
POLICYTYPE_ID CHAR(64) NOT NULL The policy type ID. It is a foreign key to the POLICYTPYE table.
LANGUAGE_ID INTEGER NOT NULL The language ID. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) The business policy type description.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030411050 POLICYTYPE_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_606 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_607 POLICYTYPE_ID POLICYTYPE POLICYTYPE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search