[Resolved] I need help regarding data structure of translated taxonomies

Background of the issue:
I am trying to make the translated elements work with my custom queries from JetEngine. The problem is that I'm not exactly sure how the database is structured as for WPML. For instance, how is a taxonomy term in English linked to its counterpart translated Japanese version? In this query, the term_id's (243, 242, 241 and 239) are the Japanese version of these terms

SELECT DISTINCT
t.term_id,
t.name,
t.slug,
t.term_group,
tt.description,
t.name AS button_title
FROM wp_terms t
JOIN wp_term_taxonomy tt ON t.term_id = tt.term_id
JOIN wp_icl_translations icl_t ON icl_t.element_id = tt.term_taxonomy_id
LEFT JOIN wp_icl_translation_status icl_ts ON icl_ts.translation_id = icl_t.translation_id
WHERE tt.taxonomy IN ('team-employment-type', 'team-location')
AND icl_t.language_code = 'jp'
AND icl_t.element_type IN ('tax_team-employment-type', 'tax_team-location')
ORDER BY
CASE
WHEN t.term_id = 243 THEN 0 -- USA (translated)
WHEN t.term_id = 242 THEN 1 -- Japan (translated)
WHEN t.term_id = 241 THEN 2 -- Leadership (translated)
WHEN t.term_id = 239 THEN 3 -- Board (translated)
ELSE 4
END;

Symptoms:
I am unsure how the database links each respective taxonomy term to its English version.

Questions:
What exactly in the database links each respective taxonomy term to its English version?
Which specific table and columns are used to link translated taxonomy terms?