I'm trying to create a system allowing end users manage information about goods in different branches of business. Such goods described with a different fields and also, the number of types of that goods growth from time to time, so that they cannot be stored in a single table.
For example, we have a drugs with their name, producer, package and form of issue, as well as WHO ATC classification. And also have some cosmetics with it's own set of fields, say: name, produces and Word-Cosmetics-Organization classification.
I'd like to have a tool (like an application over some SQL engine) to manage this entities. The tool should allow a user to add new types of goods, new classifications etc. withowt user have a need to write SQL code itself.
Could you suggest something useful for a situation like this? Are there a known tools for this job exist?