Reference > Database > WebSphere Commerce database tables > A
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 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 SQL100520030253580 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
Referenced By 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
_vcc_freeselect_bottom_