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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034842010 | BASEITEM_ID, LANGUAGE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|