问题描述
在我的数据库中，除其他表外，还有products.产品表包含ID，名称，说明和有关该产品的其他一些数据.我还要添加一个类别.
On my database I have among other tables, products. Products table contains the id, name, description and some other data about the product. I want to add also a category.
我应该创建一个名为category的新表，并使用id和每个类别的名称，并在products中添加一个* category_id *来引用category的ID，否则我应该使用products的每一行上类别的名称?
Should I create a new table named category with and id and the name of each category, and have into the products a *category_id* that will refers to the id of category, or should I have the name of the category on each row of products ?
在第一种情况下，我将必须使用JOIN.这会对性能产生严重影响吗?
On the first case I will have to use JOIN. Will this have a serious impact on the performance?
推荐答案
通过在自己的表中定义类别，您可以:
By defining the categories in their own table you can:
- 重命名类别
- 动态生成类别列表以供选择
- 添加类别描述
- 添加新类别
…等等，而不必每次修改它们都更新与类别相关的代码.
… and so on, without having to update every bit of category related code each time you modify them.
是的，添加一个表.
可能不是.
这篇关于我是否应该为此在数据库中创建一个新表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！