×

Loading...
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

@Florida

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)
Last Updated: 2001-10-6
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / Can Table be Inheretence? details in contents. -howru(How are you?); 2001-10-5 {416} (#217493@0)
    For example:
    The first table: (id char(5), name varchar2(20))
    The second table: (id char(5), name varchar2(20), age int)
    The first table: (id char(5), name varchar2(20), age int, pc char(6))
    ......

    I may need such tables more than 20.

    if can inheret, I'll not care too much about the table name or type. Otherwise, if I should add one column into every table, that should be a hard work for me.

    tks.
    • There is no inheretence like what you said in Oracle. why you use the tables like that. If you follow the ERD you never get the tables like these. -onewayticket(onewayticket); 2001-10-5 (#217742@0)
      • 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?); 2001-10-6 {616} (#217943@0)
        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.
        • Try this SQL -onewayticket(onewayticket); 2001-10-6 {70} (#217984@0)
          Why not try the following SQL query from ONE table?

          SELECT LPAD(\
        • Try this hierarchical query. -onewayticket(onewayticket); 2001-10-6 {566} (#217993@0)
          Why not try the following SQL query.

          SELECT LPAD(\" \", 2*(LEVEL-1))||column1, column2, ...
          FROM table_name
          WHERE column1 like \"A%\"
          START WITH column1 = \"A\"
          CONNECT BY prior column1 = substr(column1, 1, length(column1) - 1);

          Result like:

          column1 column2 ...
          ------------ ------------
          A
          AA
          AAA
          AAB
          AB


          The \"LEVEL\", \"START WITH\", \"prior\" and \"CONNECT BY\" are the Oracle key words

          Note: LPAD(\" \"), \"A%\", \"A\" , the \" should be replaced by DAN1 YIN3 HAO4.
        • Tree structure should not be presented by all the level columns, but only by the column like parent_id. The poor design will bring you a lot trouble later. -cyt(cyt); 2001-10-7 (#218874@0)

More Topics

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论