items_strings


Description

Textual content associated with an item, in a given language.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
item_id BIGINT 19 null
items.id fk_items_id_default_language_tag_items_strings_item_language_tag R
items.id fk_items_strings_item_id_items_id C
language_tag VARCHAR 6 null
items.default_language_tag fk_items_id_default_language_tag_items_strings_item_language_tag R
languages.tag fk_items_strings_language_tag_languages_tag R

Language tag of this content
translator VARCHAR 100 √ null

Name of the translator(s) of this content
title VARCHAR 200 √ null

Title of the item, in the specified language
image_url VARCHAR 2048 √ null

Url of a small image associated with this item.
subtitle VARCHAR 200 √ null

Subtitle of the item in the specified language
description TEXT 65535 √ null

Description of the item in the specified language
edu_comment TEXT 65535 √ null

Information about what this item teaches, in the specified language.

Table contained 2 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc item_id + language_tag
fk_items_strings_language_tag_languages_tag Performance Asc language_tag
fullTextTitle Performance Asc title
item_id Performance Asc item_id

Relationships

Close relationships within degrees of separation