WebSphere Commerce database table: PLCYPWDDSC

PLCYPWDDSC

This table holds language-dependent information related to a password policy.

Column Descriptions:

Name Type Description
PLCYPASSWD_ID BIGINT NOT NULL The ID of the password policy foreign key to the Password Policy (PLCYPASSWD) 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) A name for the password policy.
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> PLCYPASSWD_ID+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_603 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_604 PLCYPASSWD_ID PLCYPASSWD PLCYPASSWD_ID Cascade

Related reference
Authentication data model

Name	Type	Description
PLCYPASSWD_ID	BIGINT NOT NULL	The ID of the password policy foreign key to the Password Policy (PLCYPASSWD) 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)	A name for the password policy.
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_603	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_604	PLCYPASSWD_ID	PLCYPASSWD	PLCYPASSWD_ID	Cascade