This table holds the language sensitive attribute
description. Before loading attributes in multiple languages, the
attributes must already exist in the database with default
data.
Column Descriptions:
| Name | Type | Description |
| ATTR_ID | BIGINT NOT NULL | The reference number to an attribute in the ATTR
table. |
| LANGUAGE_ID | INTEGER NOT NULL | The language for this attribute description. |
| ATTRTYPE_ID | CHAR (16) NOT NULL | The attribute type. |
| NAME | VARCHAR (254) NOT NULL | The name of the attribute. |
| DESCRIPTION | VARCHAR (254) | The attribute description. |
| DESCRIPTION2 | VARCHAR (254) | An additional description field for this
attribute |
| FIELD1 | VARCHAR (254) | Customizable field |
| GROUPNAME | VARCHAR (64) | Specifies the name of the group of attributes.
All related attributes should be created with the same
groupname. |
| QTYUNIT_ID | CHAR (16) | The units in which this attribute is
measured. |
| NOTEINFO | VARCHAR (64) | Auxiliary attribute data such as a footnote. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ATTR_ID+LANGUAGE_ID | Primary Key |
| I0001465 | LANGUAGE_ID | Non-Unique Index |
| I0001466 | ATTRTYPE_ID | Non-Unique Index |
| I0001467 | QTYUNIT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3556 | ATTR_ID | ATTR | ATTR_ID | Cascade |
| F_3557 | ATTRTYPE_ID | ATTRTYPE | ATTRTYPE_ID | Cascade |
| F_3558 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
| F_3559 | QTYUNIT_ID | QTYUNIT | QTYUNIT_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3562 | ATTR_ID+LANGUAGE_ID | ATTRVALDESC | ATTR_ID+LANGUAGE_ID | Cascade |