1 Reply Latest reply on Jun 23, 2011 5:38 AM by Florian Hell

    Better database design for SEAM

    Ozzy Ozz Newbie

      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.