ACRESCGRY

This table stores all the access control resource categories in the system and the metadata information about them. The metadata includes information about the table and the columns that store the resources belonging to the resource category.

Column Descriptions:

Name	Type	Description
ACRESCGRY_ID	INTEGER NOT NULL	The ID assigned to this particular resource category. This is a primary key.
RESPRIMARYTABLE	VARCHAR (64)	The name of the table that stores the resource.
RESOWNERTABLE	VARCHAR (64)	The name of the table that stores the owner of the resource.
RESOWNERCOL	VARCHAR (64)	The name of the column that stores the owner of this resource.
RESKEYOWNCOL	VARCHAR (64)	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.
FIELD1	VARCHAR (128)	This column is 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)	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.
OPTCOUNTER	SMALLINT	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ACRESCGRY_ID	Primary Key
I0000009	RESCLASSNAME	Unique Index

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	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