This table stores all the resource categories in the system and the metadata information about them. The metadata includes information about the table and columns that store the resources belonging to this resource category.
Column Name | Column Type | Column Description |
---|---|---|
ACRESCGRY_ID | INTEGER NOT NULL |
The ID assigned to this particular resource category. This is a Primary key. |
FIELD1 | VARCHAR (128) NULL |
Customizable. |
RESCLASSNAME | VARCHAR (254) NOT NULL |
The class name of the bean that represents this resource. For commands, this is the fully qualified name of the interface. |
RESJOINKEY | VARCHAR (64) NULL |
The column in the resource table to which the key from the owner table can be joined. This is null if the owner is stored in the same table as the resource itself. |
RESKEYOWNCOL | VARCHAR (64) NULL |
The name of the column that has the resource ID in the table that stores the owner. This is null if the owner is stored in the same table as the resource itself. |
RESOWNERCOL | VARCHAR (64) NULL |
The name of the column that stores the owner of this resource. |
RESOWNERTABLE | VARCHAR (64) NULL |
The name of the table that stores the owner of the resource. |
RESPRIMARYTABLE | VARCHAR (64) NULL |
The name of the table that stores the resource. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000009 | RESCLASSNAME | Unique Index |
SQL030416034831890 | ACRESCGRY_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_39 | ACRESCGRY_ID | ACRESACT | ACRESCGRY_ID | Cascade |
F_41 | ACRESCGRY_ID | ACRESATREL | ACRESCGRY_ID | Cascade |
F_45 | ACRESCGRY_ID | ACRESGPRES | ACRESCGRY_ID | Cascade |
F_49 | ACRESCGRY_ID | ACRESMEMRL | ACRESCGRY_ID | Cascade |
F_50 | ACRESCGRY_ID | ACRESPRIM | ACRESCGRY_ID | Cascade |
F_52 | ACRESCGRY_ID | ACRESREL | ACRESCGRY_ID | Cascade |
F_55 | ACRESCGRY_ID | ACRSCGDES | ACRESCGRY_ID | Cascade |