Summary of the "translatevalues_" fields in ListManager

 

This 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)