Greetings,
I'm a bit new to SQL and SQLite so pardon me if I ask silly questions but I 
have run into a bit of a wall while attempting to design a database for a C++ 
program I am attempting to write.

The needs of the database are to: represent an object oriented hierarchy of any 
number of objects, where each object may have custom properties of several 
different datatypes and permission bits.

The table fields that I have so far are a primary integer key (ID), text 
representing the object's name, (NAME), and two fields "OWNER" and "PARENT" 
which are integers representing other objects in this table.

The problem I am running into is the object hierarchy and custom properties. 
For example: If object #1 is a parent of object #2, and #1 has a property named 
"location" then #2 should also have that property (although the value and 
permissions may be different from the parent).

I'm trying to see if I can do this some way I do not currently know how, 
because the only thing I can think of is some delimited BLOB and recalculate 
all the parent properties whenever the parent is changed which I imagine may 
significently slow down my database.

Opinions?

Regards,
Michael Munson

Reply via email to