MOVIESTAR
Tables (5)
Actor
- actorId — INT — Primary key — NOT NULL
- actorImage — VARCHAR(100)
- actorName — VARCHAR(50)
Actor-Movie
- movieId — INT — Foreign key → Movie.movieId — NOT NULL
- actorId — INT — Foreign key → Actor.actorId — NOT NULL
- role — VARCHAR(50) — NOT NULL
Movie
- movieId — INT — Primary key — NOT NULL
- movieName — VARCHAR(100)
- movieTheme — VARCHAR(100)
- movieOpDate — DATE
- movieScore — INT
- moviePoster — VARCHAR(255)
- movieOverview — VARCHAR(250)
- movieLike — CHAR(1) — NOT NULL
Review
- reviewId — INT — Primary key — NOT NULL
- userId — INT — Foreign key → User.userId — NOT NULL
- movieId — INT — Foreign key → Movie.movieId — NOT NULL
- starRating — INT — NOT NULL
- reviewContent — VARCHAR(250)
- reviewDate — DATE — NOT NULL
User
- userId — INT — Primary key — NOT NULL
- userName — VARCHAR(50)
- userNick — VARCHAR(50)
- userEmail — VARCHAR(100)
- userPwd — VARCHAR(255)