[eluser]Jay Callicott[/eluser]
Ya I don't know that Navicat is the point, that's just a GUI for MySQL. I think my idea is pretty good, not sure what "long cry" means.
Ya if you use InnoDB you can use foreign keys. Doing introspection for foreign keys is a little tricky, but basically you could create an application that just uses introspection to flesh out a whole app workflow. I think it would work.
The reason I'm thinking of this is that we have a potential client that just wants a small app like this and this sort of thing would work I think if it existed.