database schema - cakePHP one app multiple needs -
I'm dealing with a conceptual problem.
I am writing an app that collects data from different users profile. Each user profile requires a different set of tables. Profiles do not have common tables.
In addition to collecting data from the end, I should do some analysis on correlating the data with different profiles.
I plan to use a prefix on tables to separate a db, and profile. Since I have to support ~ 20 profiles, so I will end up with 100+ model / controlling classes.
Can I somehow arrange them in a more manageable way?
Ps: I am starting a cake :-)
Usage Do, as well as see. You can apply that using a table in a relational db or you can use a key-value database.
profile_id | Key | Value
This simple table layout allows you to store several key-value pairs as a per profile.
Which DB system you are using, you apply it in KPPHP.
Comments
Post a Comment