Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PLCYACCT
This table stores the user account policies that consist of an acount lockout policy and a password policy.
Column Name Column Type Description PLCYACCT_ID INTEGER NOT NULL The ID for the Account Policy table (PLCYACCT). PLCYACCLCK_ID BIGINT NOT NULL The ID for the account lockout policy foreign key to the Account Lockout Policy table (PLCYACCLCK). PLCYPASSWD_ID BIGINT NOT NULL The ID for the password policy foreign key to the Password Policy table (PLCYPASSWD). OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030410250 PLCYACCT_ID Primary Key I0000695 PLCYACCLCK_ID Non-Unique Index I0000696 PLCYPASSWD_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_599 PLCYACCLCK_ID PLCYACCLCK PLCYACCLCK_ID Cascade F_600 PLCYPASSWD_ID PLCYPASSWD PLCYPASSWD_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_598 PLCYACCT_ID PLCYACCDSC PLCYACCT_ID Cascade F_894 PLCYACCT_ID USERREG PLCYACCT_ID Cascade
Related reference
_vcc_freeselect_bottom_