+------------------------+ | messageproperties_key | +------------------------+ | key_id INT(11) | | key VARCHAR(1024) | | (possible audit cols) | | +-------+ +-------------------------------+ | | | | messageproperties_key_locale | | | | +-------------------------------+ | | | | key_locale_id INT(11) | | | | | key_id INT(11) FK | +------------------------+ | | locale VARCHAR(32) | | | translation TEXT | +---------+ | | | | | | | | | +-------------------------------+