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 Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
I0000008 GRPNAME+MEMBER_ID Unique Index
SQL060903235118070 ACRELGRP_ID Primary Key
I0000442 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_37 MEMBER_ID MEMBER MEMBER_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_29 ACRELGRP_ID ACPOLICY ACRELGRP_ID Cascade
F_54 ACRELGRP_ID ACRLGPDESC ACRELGRP_ID Cascade
Related reference