Summary of the "translatevalues_" fields in ListManager

Below table stores the translated values for each key and language:

Primary key: TranslateValueID_

Field Name

Description

Version Added

TranslateValueID_

An auto-incrementing ID field that uniquely identifies a record in this table (int, NOT NULL)

TranslateLangID_

A reference to translatelang_, this defines what language this translated value is in (int, NOT NULL)

TranslateKeyID_

A reference to translatekeys_, this defines what key is used to access this translation (int. NOT NULL)

IsValid_

When a translatekeys_ record is modified, any translatevalues_ records that reference it are flagged as invalid so that they can be retranslated (bool)

Value_

This is the translated value for the specified language and key (text, NULL)