Interface to build relationships between tables

1

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.

    
asked by anonymous 21.03.2014 / 13:55

1 answer

1

For php + MySQL there is WorkBench

It is an application for modeling the database visually / designer, very useful and that allowed you to see / build diagram and schemas in the relationships and views of your bank and allow you to create the base or even return php code for your use, see WorkBench generate php code

In the case of Data Populator , I usually use this [here] to generate my data mocks. Very good, simple, I considered self-intuitive and beyond all free ...

    
21.03.2014 / 14:08