×

Loading...

Dear oneway, that is the key. Such problem is just occured in ERD. I should design a tree structure database like catalogue-catalogue-catalogue-item. and ...

howru (How are you?)
Dear oneway, that is the key. Such problem is just occured in ERD. I should design a tree structure database like catalogue-catalogue-catalogue-item. and ...

Level1
|
+--Level2
|
.......
+-------Level100

The number of level should be up to 100. There should be both category and item in each level. In my opinion, there should be the same table structure from level2 to level20 ( PK in the level and FK to the upper level). Now, even though I have thought it over when designing, I am still afraid that my boss will change his idea to add one column to all the tables.

tks.
(#217943@0)
2001-10-6 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

Back To Topic: Can Table be Inheretence? details in contents.

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论