Database Table: ACRESMEMRL

This table stores resource-member relationships for resources of the type of different resource categories. A combination of all the columns other than ACRESMEMRL_ID should be unique.

Column Name Column Type Column Description
ACRELATION_ID INTEGER
NOT NULL
Relation ID. This refers to the relation in this record.
ACRESCGRY_ID INTEGER
NOT NULL
Resource category ID that indicates the type of resource.
ACRESMEMRL_ID BIGINT
NOT NULL
Resource member relation ID. This is a Primary Key.
MEMBER_ID BIGINT
NOT NULL
Member ID that has a relationship with the resource.
RESOURCEID BIGINT
NULL
Resource ID that has this relationship with the member.
Indexes:
Index Name Indexed Column Names Index Type
I0000011 MEMBER_ID, RESOURCEID, ACRELATION_ID, ACRESCGRY_ID Unique Index
I0000012 RESOURCEID, ACRELATION_ID, ACRESCGRY_ID Non-Unique Index
SQL030416034833290 ACRESMEMRL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_47 ACRELATION_ID ACRELATION ACRELATION_ID Cascade
F_48 MEMBER_ID MEMBER MEMBER_ID Cascade
F_49 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable