Database Table: ACRESCGRY

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000009 RESCLASSNAME Unique Index
SQL030416034831890 ACRESCGRY_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_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