Couple options you can take

來源: internuts 2010-10-19 23:17:15 [] [博客] [舊帖] [給我悄悄話] 本文已被閱讀: 次 (964 bytes)

No matter how deep or how many tables in cluster, you can use two methods to get there:

Option 1:  (1) Create a standard table for each layer, in-dependant of each other; create a relationship table to contain their relationship, such as who owns whom (or who belongs to whom).

Option 2:  Create cluster tables - this can be two types:  (1) using index: for example, the first table contains header number (key) and descriptions, the second table contains header number (key) and item number (key) and other non-key info.  Now the relationship between header and item is established.  (2) using pointer:  for example, the first table contains header number (key), item table id, and descriptions.  Note:  item table id is not a real table but a pointer here, it points to the item table.

 

No matter what db tables, not much different.

 

 

 

請您先登陸,再發跟帖!

發現Adblock插件

如要繼續瀏覽
請支持本站 請務必在本站關閉/移除任何Adblock

關閉Adblock後 請點擊

請參考如何關閉Adblock/Adblock plus

安裝Adblock plus用戶請點擊瀏覽器圖標
選擇“Disable on www.wenxuecity.com”

安裝Adblock用戶請點擊圖標
選擇“don't run on pages on this domain”