Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ACATTR
This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.
Column Name Column Type Description ACATTR_ID BIGINT NOT NULL The attribute ID. This is the primary key. ATTRNAME VARCHAR(128) NOT NULL The name of this attribute. This has to be unique. DATATYPE INTEGER NOT NULL The data type of this attribute. It is a foreign key to the REFID column in the ICDATAREG table. FIELD1 VARCHAR(128) This column is customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000003 ATTRNAME Unique Index SQL100520030250860 ACATTR_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_8 DATATYPE ICDATAREG REFID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_10 ACATTR_ID ACATTRDESC ACATTR_ID Cascade F_40 ACATTR_ID ACRESATREL ACATTR_ID Cascade
Related reference
_vcc_freeselect_bottom_