BASEITMDSC

Each row of this table contains language-dependent information for a BaseItem.

Column Descriptions:

NameTypeDescription
BASEITEM_IDBIGINT NOT NULLThe BaseItem.
LANGUAGE_IDINTEGER NOT NULLThe Language for this information. For a list of language components, see the LANGUAGE table.
SHORTDESCRIPTIONVARCHAR (254)A brief description of the BaseItem.
LONGDESCRIPTIONVARCHAR (4000)A detailed description of the BaseItem.
LASTUPDATETIMESTAMPThe last time this information was updated.
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>BASEITEM_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_109LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_110BASEITEM_IDBASEITEMBASEITEM_IDCascade