ATTRDESC

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:

NameTypeDescription
ATTR_IDBIGINT NOT NULLThe reference number to an attribute in the ATTR table.
LANGUAGE_IDINTEGER NOT NULLThe language for this attribute description.
ATTRTYPE_IDCHAR (16) NOT NULLThe attribute type.
NAMEVARCHAR (254) NOT NULLThe name of the attribute.
DESCRIPTIONVARCHAR (254)The attribute description.
DESCRIPTION2VARCHAR (254)An additional description field for this attribute
FIELD1VARCHAR (254)Customizable field
GROUPNAMEVARCHAR (64)Specifies the name of the group of attributes. All related attributes should be created with the same group name.
QTYUNIT_IDCHAR (16)The units in which this attribute is measured.
NOTEINFOVARCHAR (64)Auxiliary attribute data such as a footnote.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ATTR_ID+LANGUAGE_IDPrimary Key
I0001465LANGUAGE_IDNon-Unique Index
I0001466ATTRTYPE_IDNon-Unique Index
I0001467QTYUNIT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3556ATTR_IDATTRATTR_IDCascade
F_3557ATTRTYPE_IDATTRTYPEATTRTYPE_IDCascade
F_3558LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_3559QTYUNIT_IDQTYUNITQTYUNIT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3562ATTR_ID+LANGUAGE_IDATTRVALDESCATTR_ID+LANGUAGE_IDCascade