final database design questions
Hi, just after some advice on the best way to go about the final part of my db design.
at the moment I have a movies table:
) DEFAULT CHARSET utf8
and a users table:
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(55) UNIQUE,
email VARCHAR(55) UNIQUE,
) DEFAULT CHARACTER SET utf8
I have thousands of movies in the movies table and I have an addmovie.php form that allows users to search for the movies.
I want users to be able to add movies from their searches to their own user page (users.php?user=username).
I'm just wondering on the best database design for this.. should I just make a 'usermovies' table to link to the movies table? and then just add every users selected movies to the usermovies table? ie
userid - movieid
1 - 343
1 - 4656
7 - 234
1 - 111
2 - 3434
any tips would be wonderful.