Database Table: ACATTRDESC

This table stores locale specific display information corresponding to the ACATTR table.

Column Name Column Type Column Description
ACATTR_ID BIGINT
NOT NULL
Attribute ID. This is a Primary Key along with the LANGUAGE_ID field in this table. Foreign key to ACATTR table.
DESCRIPTION VARCHAR (254)
NULL
Description of this attribute.
DISPLAYNAME VARCHAR (254)
NOT NULL
Locale specific display name for this attribute.
LANGUAGE_ID INTEGER
NOT NULL
Language ID. This is a Primary Key along with the Attribute ID. Foreign key to the LANGUAGE table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034824980 ACATTR_ID, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_10 ACATTR_ID ACATTR ACATTR_ID Cascade
F_9 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable