WebSphere Commerce database table: ACORGPOL

ACORGPOL

Deprecated. Provided for backward compatibility only.

Column Descriptions:

Name Type Description
ACPOLICY_ID INTEGER NOT NULL The ID of the template policy. It is a foreign key to the ACPOLICY table.
MEMBER_ID BIGINT NOT NULL The ID of the organizational entity that does not want the template policy applied to it. It is a foreign key to the MEMBER table.
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> ACPOLICY_ID+MEMBER_ID Primary Key
I0000436 MEMBER_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_25 MEMBER_ID MEMBER MEMBER_ID Cascade
F_26 ACPOLICY_ID ACPOLICY ACPOLICY_ID Cascade

Related reference
Access control data model

Name	Type	Description
ACPOLICY_ID	INTEGER NOT NULL	The ID of the template policy. It is a foreign key to the ACPOLICY table.
MEMBER_ID	BIGINT NOT NULL	The ID of the organizational entity that does not want the template policy applied to it. It is a foreign key to the MEMBER table.
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.

Name	Column Names	Type
<SYSTEM-GENERATED>	ACPOLICY_ID+MEMBER_ID	Primary Key
I0000436	MEMBER_ID	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_25	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_26	ACPOLICY_ID	ACPOLICY	ACPOLICY_ID	Cascade