mysql - 我是否过度设计了我的 MySQL 数据库(用户/公司/产品)？

Question

我是数据库设计新手，请给我一些建议。

1 When should I use a composite index?

im not sure what does index does, but i do know we should put it when it will be heavly loaded like for WHERE verified = 1 and in search like company.name = something. am i right ?

2 MySQL indexes - how many are enough?

is it just enough ?

3 Database Normalization

is it just right?

谢谢。

编辑*

规则。

1. each users( company member or owners ) could be a member of a company
2. each company have some member of users.
3. there are company admins ( ceo, admins) and there are company members ( inserts the products )
4. each company can have products.

对于数字 3，我将在 users_company 添加一点- 1 是管理员- 0 为成员

Answer 1

至少对我来说看起来不错，规范化良好。

我注意到每个产品只能属于一家公司。如果这就是您的意图，那很好，否则您可以让产品拥有自己的 PID 并拥有一个 product_company 关系表，这将让多个公司销售特定产品。我想取决于谁管理产品。

我确实注意到用户表称为“用户”(复数)，其他表是单数(“公司”、“产品”)。但这只是一件小事。