Displaying 1 result from an estimated 1 matches for "hierarchy_id".
Did you mean:
hierarchy_dir
2006 Apr 06
6
Flexible data schema in a database?
...system, we have an object and we want to add data
about that object to the system.
Now my thoughts on the problem:
It may be possible to achieve this with just 2 tables.
fields
-----------------------------
id - primary key
parent_id - tree like structure
name - string for the name of the field
hierarchy_id - id of the hierarchy this field belongs to
repeatable - can a record contain more then one of these fields?
data
-----------------------------
id - primary key
field_id - reference to the field to which this data belongs
hierarchy_id - id of the hierarchy this data belongs to
content - string for...