I have Cars with different Characteristics, Characteristics have values, which can be restricted by predefined set of values or be "open" values (any string). Characteristics and predefined values must be localized. I designed this schema:
Though it seems like all requirements are met, I am a bit confused about having characteristic value in two different tables. I think it can cause some issues when trying to search by characteristic value.
Can you offer more elegant way to solve this problem?