Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tabreaz
Starting Member
3 Posts |
 Posted - 2006-03-25 : 05:46:07
|
hi all,I have a requirement which must allow users to create objects, theobjectcan have any number of subjects. Internally those sub-objectscan contain sub-objects. Similar to our filesystem. A directory canhave sub-dir's so on.First i view object and sub-objects both as objects, and decided tostore the information in two tables as'Objects:ObjectID ObjectName ObjectType ObjectOwner CreationDate Level.....the level field describe the depth of the object in a tree.For example the depth SubObj3 below is 3 asrootObject SubObj1 SubObj2 SubObj3 SubObjects:ObjectID SubObjectIDCan someone help me to tune this table structure. |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
|
|
|
DB Design