WebSphere Commerce database table: ACRESMEMRL

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000011 MEMBER_ID+RESOURCEID+ACRELATION_ID+ACRESCGRY_ID Unique Index
SQL050212031155630 ACRESMEMRL_ID Primary Key
I0000012 RESOURCEID+ACRELATION_ID+ACRESCGRY_ID Non-Unique Index
I0000447 ACRESCGRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback