This table stores the relationship between resources. Given a resource, you can find out the possible relationships that it can have and also the table and the columns in which various relationships are stored.
Column Name | Column Type | Column Description |
---|---|---|
ACRELATION_ID | INTEGER NOT NULL |
Relation ID. This is a Primary Key. Foreign key to the RELATION table. |
ACRESCGRY_ID | INTEGER NOT NULL |
Resource category ID. This is a Primary Key. Foreign key to the ACRESCGRY table. |
FIELD1 | VARCHAR (128) NULL |
Customizable. |
RESJOINCOL | VARCHAR (64) NULL |
The column in the main resource table that can be joined with the RESRELKEYCOL column. |
RESOURCETYPE | VARCHAR (64) NULL |
The column name in the relationship table that stores the resource type for which the relationship applies. This field is used for relationship tables that capture relationships for more than one type of resources. It would be the string "ACRESCGRY_ID" for ACRESMEMRL table. |
RESRELCOL | VARCHAR (64) NULL |
The column in the relationship table that stores the resource relationship. |
RESRELKEYCOL | VARCHAR (64) NULL |
The column name in the relationship table that stores the resource ID. |
RESRELMEMCOL | VARCHAR (64) NOT NULL |
The column in the relationship table that stores the member ID. |
RESRELTABLE | VARCHAR (64) NOT NULL |
Name of the table that stores the member relationships for a given resource. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034833880 | ACRELATION_ID, ACRESCGRY_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_51 | ACRELATION_ID | ACRELATION | ACRELATION_ID | Cascade |
F_52 | ACRESCGRY_ID | ACRESCGRY | ACRESCGRY_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|