ATTRDESC

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 group name.
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