MovieId | Title | FilmStyle | DirectorId |
---|---|---|---|
(→ Directors.DirectorId) | |||
1 | The Lost City | Adventure Movie | 1 |
2 | Racing Hearts | Romantic Comedy | 2 |
3 | Guns of Glory | Action Movie | 1 |
4 | Alien Invasion | Science Fiction | 3 |
5 | Epic Adventure | Adventure Movie | 2 |
DirectorId | Name |
---|---|
1 | Sofia Martinez |
2 | John Doe |
3 | Jane Smith |
DetailID | MovieId | ReleaseYear | Budget | Revenue | Duration | Rating |
---|---|---|---|---|---|---|
(→ Movies.MovieId) | ||||||
1 | 1 | 2021 | 10000000 | 15000000 | 120 minutes | 8.5 |
2 | 2 | 2020 | 7500000 | 9000000 | 95 minutes | 7.8 |
3 | 3 | 2021 | 15000000 | 25000000 | 135 minutes | 9.2 |
4 | 4 | 2022 | 12000000 | 16000000 | 100 minutes | 8.0 |
5 | 5 | 2020 | 10000000 | 12000000 | 115 minutes | 7.5 |
MemberId | MovieId | ActorName | CharacterPlayed |
---|---|---|---|
(→ Movies.MovieId) | |||
1 | 1 | Alice Johnson | Lead Protagonist |
2 | 1 | Bob Brown | Supporting Role |
3 | 2 | Charlie Davis | Love Interest |
4 | 3 | David Wilson | Protagonist |
5 | 4 | Emma Thompson | Antagonist |
ReviewId | MovieId | UserId | Comment | Stars |
---|---|---|---|---|
(→ Movies.MovieId) | (→ Users.UserId) | |||
1 | 1 | 1 | Great adventure! Loved it. | 5 |
2 | 2 | 1 | Not my cup of tea... | 3 |
3 | 3 | 2 | Exciting action sequences! | 4 |
4 | 4 | 3 | Predictable plot... | 2 |
5 | 5 | 4 | Fun watch overall! | 3 |