I am developing an application where basically the user will relate MySQL tables. For example:
- table A (Products)
- table B (Photos)
- table C (Price History).
Basically the application would have to have the following:
- The user chooses the tables involved;
- The user says that when adding a new photo, the product ID must be included;
- The user says that when the price is changed, you must include the price in the history table using the product ID.
Well, it's just an introduction to the problem. The problem is to avoid programming and make the most of the interface, but this is a rule among many possible.
The question is, am I going down the wrong path, with no way out? Is there any application that does this (does not do everything but already does a lot and for sure there is) and I'm reinventing the wheel? Even if it is not PHP + MySQL, what matters is the concept.