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

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

java - Gradle dependencies: compile project by relative path -

ruby on rails - Object doesn't support #inspect when used with .include -