WebSphere Commerce database table: ACRESPRIM

This table stores the primary resource column names for an access control resource. A given resource can have more than one primary column.

Column Descriptions
Column Name Column Type Description
ACRESCGRY_ID INTEGER NOT NULL The resource ID for which the entry applies.
RESPRIMARYCOL VARCHAR(64) NOT NULL The column that stores the primary key for a resource.
FIELD1 VARCHAR(128) This column is customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235121000 ACRESCGRY_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_50 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade
Related reference