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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031155770 ACRESCGRY_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_50 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade

Feedback