Say you had multiple tables like customers and orders, defined like
customers
---
cust_id
cust_name
orders
---
order_id
cust_id
Now say I want to translate\alias those column headers
I could see creating a meta table like
customers_meta
---
lang_id column1 column2
1 'Customer ID' 'Customer Name'
2 'Identificación del cliente' 'Nombre del cliente'
Then you could potentially replace the column headers in the front end.
Any other methods? Could Alias the column headers in a view? But I wouldn't want a bunch of views.
I'm returning json anyways so I could do something like this
Function to return dynamic set of columns for given table
I guess my questions are, thoughts on storing the translations. Thoughts on returning the column names.
What do you think of this approach?
