WebSphere Commerce database table: ACRELGRP

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


Column Description(s):
Column NameColumn TypeDescription
ACRELGRP_ID INTEGER NOT NULL The relationship group ID.
MEMBER_ID BIGINT NOT NULL This column is a foreign key to the MEMBER table for the owner of this relationship group. All relationship groups should be owned by the root organization.
GRPNAME VARCHAR(200) NOT NULL The name of the relationship group.
CONDITIONS VARCHAR(2500) This column contains an XML document describing the condition for this implicit relationship group.
FIELD1 VARCHAR(64) This column is customizable.
DESCRIPTION VARCHAR(254) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000008 GRPNAME+MEMBER_ID Unique Index
SQL050212031154550 ACRELGRP_ID Primary Key
I0000442 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_37 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_29 ACRELGRP_ID ACPOLICY ACRELGRP_ID Cascade
F_54 ACRELGRP_ID ACRLGPDESC ACRELGRP_ID Cascade

Feedback