Reference > Database > WebSphere Commerce database tables > A
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 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 SQL100520030255130 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
_vcc_freeselect_bottom_