WebSphere Commerce database table: PLCYTYPDSC

PLCYTYPDSC

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

Column Descriptions:

Name 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> POLICYTYPE_ID+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_606 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_607 POLICYTYPE_ID POLICYTYPE POLICYTYPE_ID Cascade

Related reference
Contract data model

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Constraint	Columns	Parent Table	Parent Columns	Type
F_606	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_607	POLICYTYPE_ID	POLICYTYPE	POLICYTYPE_ID	Cascade