database design for nesting items
From: Yaron Lapidot <ylapidot_at_netvision.net.il>
Date: Sun, 30 May 2004 21:22:46 +0200
Message-ID: <c9d8un$ift$1_at_news2.netvision.net.il>
Hello all
i've to design a database that hold infomation about documents each document could be a stand alone or a parent of other document/s each document have his own attributes and a uniqe key.
Date: Sun, 30 May 2004 21:22:46 +0200
Message-ID: <c9d8un$ift$1_at_news2.netvision.net.il>
Hello all
i've to design a database that hold infomation about documents each document could be a stand alone or a parent of other document/s each document have his own attributes and a uniqe key.
my problem is how to hold the attributes of the data.
because documents will be create dynamicly i can define a table whice will
hold the attributes data and be
varchar data type that can hold all kind of data(a lot of casting work)
or define a table for each data type i use ?
eventualy i design a tree of documents 'that each doc can hold his own attributes .
a lot of thanks
Yaron Lapidot
Received on Sun May 30 2004 - 21:22:46 CEST