translations

7104 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
termId INT 10 null
languageId INT 10 null
translation TEXT 65535 √ NULL
translated TINYINT 3 0
needsReview BOOLEAN 3 √ 0
lastCheckInCommunity INT 10 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
term_language Must be unique Asc/Asc termId + languageId
translation_status Performance Asc/Asc languageId + translated

Relationships