WebSphere Commerce database table: ACACTDESC

WebSphere Commerce database table: ACACTDESC

This table stores locale-specific display information for the actions stored in the ACACTION table.
Column Descriptions
Column Name Column Type Description
ACACTION_ID INTEGER NOT NULL The action ID. It is a foreign key to the ACACTION table. Together with the LANGUAGE_ID column, it forms the primary key.
DISPLAYNAME VARCHAR(700) NOT NULL The display name for the action.
DESCRIPTION VARCHAR(700) The description of this action.
LANGUAGE_ID INTEGER NOT NULL The language ID. It is a foreign key to the LANGUAGE table. Together with the ACACTION_ID column, it forms the primary key. For a list of language components, see the LANGUAGE table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235112320 ACACTION_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_6 ACACTION_ID ACACTION ACACTION_ID Cascade
F_5 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference

Access control data model

Column Name	Column Type	Description
ACACTION_ID	INTEGER NOT NULL	The action ID. It is a foreign key to the ACACTION table. Together with the LANGUAGE_ID column, it forms the primary key.
DISPLAYNAME	VARCHAR(700) NOT NULL	The display name for the action.
DESCRIPTION	VARCHAR(700)	The description of this action.
LANGUAGE_ID	INTEGER NOT NULL	The language ID. It is a foreign key to the LANGUAGE table. Together with the ACACTION_ID column, it forms the primary key. For a list of language components, see the LANGUAGE table.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_6	ACACTION_ID	ACACTION	ACACTION_ID	Cascade
F_5	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade