WebSphere Commerce database table: ACRESMEMRL

This is an access control table that stores resource-member relationships for resources of different types.

Column Descriptions
Column Name Column Type Description
RESOURCEID BIGINT The resource ID that has this relationship with the member.
ACRESMEMRL_ID BIGINT NOT NULL The resource member relation ID. This is a primary key.
MEMBER_ID BIGINT NOT NULL The member ID that has a relationship with the resource.
ACRELATION_ID INTEGER NOT NULL The relation ID. It refers to the relation in this record.
ACRESCGRY_ID INTEGER NOT NULL The resource category ID that indicates the type of resource.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000011 MEMBER_ID+RESOURCEID+ACRELATION_ID+ACRESCGRY_ID Unique Index
SQL060903235120710 ACRESMEMRL_ID Primary Key
I0000012 RESOURCEID+ACRELATION_ID+ACRESCGRY_ID Non-Unique Index
I0000447 ACRESCGRY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_47 ACRELATION_ID ACRELATION ACRELATION_ID Cascade
F_49 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade
F_48 MEMBER_ID MEMBER MEMBER_ID Cascade
Related reference