We are trying to find some links in the database e.g. translation entries, but some of the table names are not that consistent e.g. Options. For example, we are wanting to find out Data Elements & Options that:
a. Do not have a (FR) translation entered
b. The translation entry (modified date) is older than the DE.
- Is there a database diagram available that shows the links & FKs between the (many) tables in the db?
- Is there a way to differentiate the translation languages by doing a SQL query?
I am comparing the tables below for #a:
SELECT * FROM dataelementcategoryoption
SELECT * FROM categoryoptiontranslations
SELECT * FROM categorycombo
SELECT * FROM categorycombotranslations
Thanks in advance