Sometimes when I am working on a dynamic model for example, it is difficult to figure out which database value for a domain in the SF database translates to a particular translation in the GUI. For example, figuring out the database value in the table col for column 'calculated_field_type' when it is an expression or when it is a calculated column can be quite tedious. I usually then look for a column in the UI with the particular value I am looking for, and then query the database to find out what database value is associated with this.
One of the solutions to this tedious process is a translation table in the SF database, where you can see what domain element is translated to which text. However, i'm open to other solutions...
