Better database design for SEAM

[ruthlesset]

One method I have seen a few people use for application development recently is to create a table called Parameters with 4 columns recid, type, name, value. This table is used to store data like Countries, States among others. So this table would have data like:

1, country, USA, US
2, country, Canada, CA
3, state, California, CA
4, state, New York, NY
...

Is this kind of a table useful in SEAM or would it be more beneficial to have separate tables say Country that stores countries and State that stores state.

[florianhell]

This is less a question for seam than more for db.

Of course it is better to two tables for storing this data.