Database Table: ACRELATION

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000007 RELATIONNAME Unique Index
SQL030416034830250 ACRELATION_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
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