WebSphere Commerce database table: PLCYACCLCK

WebSphere Commerce database table: PLCYACCLCK

This table contains the account lockout policies for WebSphere Commerce stores.
Column Descriptions
Column Name Column Type Description
PLCYACCLCK_ID BIGINT NOT NULL The ID for the Account Lockout Policy table (PLCYACCLCK).
LOCKOUTTHRESHOLD INTEGER DEFAULT 6 The number of times a user can consecutively enter an incorrect password before the system locks the users account.
WAITTIME INTEGER DEFAULT 10 The starting value (in seconds) of the time before the user is allowed to re-enter another password.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235230810 PLCYACCLCK_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_599 PLCYACCLCK_ID PLCYACCT PLCYACCLCK_ID Cascade
F_602 PLCYACCLCK_ID PLCYLCKDSC PLCYACCLCK_ID Cascade
Related reference

Authentication data model

Column Name	Column Type	Description
PLCYACCLCK_ID	BIGINT NOT NULL	The ID for the Account Lockout Policy table (PLCYACCLCK).
LOCKOUTTHRESHOLD	INTEGER DEFAULT 6	The number of times a user can consecutively enter an incorrect password before the system locks the users account.
WAITTIME	INTEGER DEFAULT 10	The starting value (in seconds) of the time before the user is allowed to re-enter another password.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_599	PLCYACCLCK_ID	PLCYACCT	PLCYACCLCK_ID	Cascade
F_602	PLCYACCLCK_ID	PLCYLCKDSC	PLCYACCLCK_ID	Cascade