我有一个类别列表以及与每个类别关联的子类别数量. 假设类别表称为猫,那么我有热类别和冷类别 我有另一个称为subcats的表,然后有以下内容:
I have a list of categories and number of sub categories associated to each category. let say Category table is called Cat then I have hot and cold categories in it I have another table called subcats then I have the following:
猫:
ID Name 1 Hot 2 ColdSubCats :
SubCatID CATID Name 1 1 soup 2 1 rice 3 1 pizza 4 2 salad 5 2 fruit我应该考虑设计的性能,您如何评价我的设计?有更好的解决方案吗?
I should consider performance in my design, how do you rate my design? is there any better solution?
(类别仅是示例-我有很多类别和子类别.)
(Categories are just sample - I have heaps of categories and subcategories.)
推荐答案您可以将所有内容放在一个表中,类别.然后有一列作为parentID.如果parentID = 0,它是一个主类别,如果它是另一个ID,则它是一个子类别?此结构将支持子子类别...不确定是否对您有帮助.
You could have everything in one table, category. Then have a column for parentID. If parentID = 0, it is a master category, if its another ID, then it is a subcategory? This structure would support sub-sub categories... not sure if that's helpful to you.
示例字段:
Table: category categoryID parentID name示例数据:
categoryID : 1 parentID : 0 name : hot categoryID : 2 parentID : 0 name: cold categoryID : 3 parentID : 2 name : a soup that's cold categoryID : 4 parentID: 1 name: a soup that's hot更多推荐
如何在MySQL中设计类别和子类别?
发布评论