I've designed a database model and I'm racking my mind about how to code an easy way of accessing the data with DMZ 1.5.4.
There is one main table, called module and several tables which have the prefix plugin. Each module can have several plugin types and each Plugin can have different settings. For instance, if there is a plugin of type 'Text', one instance can have the label 'Preview' and another on can have the label 'Content'. each Plugin has it's own position in the module.
Example:
Code:
Module A
----------
Plugin Text ('Preview'), Position: 1
Plugin Date ('Current Date'), Position: 2
Plugin Text ('Content'), Position: 3
Each Module has many Entries. The allowed plugins for the entry are already defined, that means each entry is related to different plugincontent tables, one for each plugin.
Example:
Code:
Module A
--------
Entry 1:
Plugin Content Text: 'Lorem ipsum dolor'
Plugin Content Date: 2009-10-25
Plugin Content Text 'Lorem ipsum dolor'
Now, I want to select all Entries and the related contents of the active plugins, sorted by the position.
The Problem is, that each plugin hast different types of settings and different types of values, for instance dates, textfield option fields etc.
How can I realize this with DMZ and is there a name for these relationships where not only a foreign key is the important column for the relation, for example the pluginid, but also the table name?!
