Question

It s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.

Closed 11 years ago.

I am working on a web site that has a movie list. What I am looking to do is make it so the user can check of and rate the movies that they have seen. I have 2 different tables one for the users and one for the movies. This is my first attempt to have 2 tables link and as such I am not sure what the starting point on something like this. I want to use the movie ID as the identifier in the user profile. But I cant think of a good way to put that into the user database neatly.

成就

Answer 1

a. 提供一个表用户:

UserID
Username
Date of birth, ...

表格:

MovieID
Moviename
Productionyear, ...

表格将:

LinkID
UserREF (here you put the userID of the user)
MovieREF (here you put the MovieID of the movie)
Rating
Datetime, ...

现在,你可以像现在这样与这些表格合作,但你可以做些什么,以确保你的数据保持有效:如果你对用户教育基金会和电影教育基金会施加限制,那么,如果没有相应的用户或电影,联系表中就没有线。

Answer 2

您需要第三张表格。例如

user_movie_rating: user_id, movie_id, rating

阅读电影的评分

SELECT SUM(rating) / COUNT(user_id) FROM user_movie_rating WHERE movie_id = x

友情链接