mysql - 需要优化的数据库架构

Question

我想设计一个数据库

on my website , a user can have multiple images assigned to it and one image can also have multiple users assigned to it.
one should be able to list how many images a user has Or how many users a image has.

there will be about 1,00,000 users and 1,00,000 images..

我怎样才能以最小的冗余和最大的效率在两者之间建立这种多对多的关系......请建议我一个优化的架构..

Answer 1

为了实现多对多关系，您需要一个链接表。创建一个共享图像和用户表主键的“UserImage”表。

通过这种方式，您可以检查用户是否拥有图像，或者图像有多少用户，而无需直接在图像表上操作。