This table is a master list of all the relations that exist in the system. These relationships are between resources that are protected and the members in the system.
Column Name | Column Type | Column Description |
---|---|---|
ACRELATION_ID | INTEGER NOT NULL |
Relation ID. This is the Primary Key. |
RELATIONNAME | VARCHAR (128) NOT NULL |
Name of the relation. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000007 | RELATIONNAME | Unique Index |
SQL030416034830250 | ACRELATION_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_34 | ACRELATION_ID | ACPOLICY | ACRELATION_ID | Cascade |
F_36 | ACRELATION_ID | ACRELDESC | ACRELATION_ID | Cascade |
F_47 | ACRELATION_ID | ACRESMEMRL | ACRELATION_ID | Cascade |
F_51 | ACRELATION_ID | ACRESREL | ACRELATION_ID | Cascade |