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:

NameTypeDescription
ACRESCGRY_IDINTEGER NOT NULLThe ID assigned to this particular resource category. This is a primary key.
RESPRIMARYTABLEVARCHAR (64)The name of the table that stores the resource.
RESOWNERTABLEVARCHAR (64)The name of the table that stores the owner of the resource.
RESOWNERCOLVARCHAR (64)The name of the column that stores the owner of this resource.
RESKEYOWNCOLVARCHAR (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.
FIELD1VARCHAR (128)This column is customizable.
RESCLASSNAMEVARCHAR (254) NOT NULLThe class name of the bean that represents this resource. For commands, this is the fully-qualified name of the interface.
RESJOINKEYVARCHAR (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.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ACRESCGRY_IDPrimary Key
I0000009RESCLASSNAMEUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_39ACRESCGRY_IDACRESACTACRESCGRY_IDCascade
F_41ACRESCGRY_IDACRESATRELACRESCGRY_IDCascade
F_45ACRESCGRY_IDACRESGPRESACRESCGRY_IDCascade
F_49ACRESCGRY_IDACRESMEMRLACRESCGRY_IDCascade
F_50ACRESCGRY_IDACRESPRIMACRESCGRY_IDCascade
F_52ACRESCGRY_IDACRESRELACRESCGRY_IDCascade
F_55ACRESCGRY_IDACRSCGDESACRESCGRY_IDCascade