WebSphere Commerce database table: ACRELATION

This table is a master list of all the access control relationships that exist in the system. These relationships are between resources that are protected and the members in the system.

Column Descriptions
Column Name Column Type Description
ACRELATION_ID INTEGER NOT NULL The relation ID. This is the primary key.
RELATIONNAME VARCHAR(128) NOT NULL The name of the relationship.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000007 RELATIONNAME Unique Index
SQL060903235117340 ACRELATION_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_34 ACRELATION_ID ACPOLICY ACRELATION_ID Cascade
F_36 ACRELATION_ID ACRELDESC ACRELATION_ID Cascade
F_47 ACRELATION_ID ACRESMEMRL ACRELATION_ID Cascade
F_51 ACRELATION_ID ACRESREL ACRELATION_ID Cascade
Related reference