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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|