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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000007 RELATIONNAME Unique Index
SQL050212031154270 ACRELATION_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback