Database Table: ACRELDESC

This table stores locale specific information about relationships.

Column Name Column Type Column Description
ACRELATION_ID INTEGER
NOT NULL
Relation ID. This is a Primary Key along with the LANGUAGE_ID field. Foreign key to the ACRELATION table.
DESCRIPTION VARCHAR (254)
NULL
Description of the relation.
DISPLAYNAME VARCHAR (254)
NOT NULL
Locale specific display name of the relation. With the language ID, this is a unique key.
LANGUAGE_ID INTEGER
NOT NULL
Language ID. This is a Primary Key along with the ACRELATION _ID. Foreign key to the LANGUAGE table. For a list of language components, see the LANGUAGE table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034830550 ACRELATION_ID, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_35 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_36 ACRELATION_ID ACRELATION ACRELATION_ID Cascade

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