Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ACRESMEMRL
This is an access control table that stores resource-member relationships for resources of different types.
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 SQL100520030254880 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
_vcc_freeselect_bottom_