Database Table: BASEITMDSC

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

Column Name Column Type Column Description
BASEITEM_ID BIGINT
NOT NULL
The BaseItem.
LANGUAGE_ID INTEGER
NOT NULL
The Language for this information. For a list of language components, see the LANGUAGE table.
LASTUPDATE TIMESTAMP
NULL
The last time this information was updated.
LONGDESCRIPTION VARCHAR (4000)
NULL
A detailed description of the BaseItem.
SHORTDESCRIPTION VARCHAR (254)
NULL
A brief description of the BaseItem.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034842010 BASEITEM_ID, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_109 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_110 BASEITEM_ID BASEITEM BASEITEM_ID Cascade

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