id | title | releaseDate | genre | directorId |
---|---|---|---|---|
(→ Directors.id) | ||||
1 | The Shawshank Redemption | 1994-09-23 | Drama | 1 |
2 | Forrest Gump | 1994-06-23 | Drama/Romance | 2 |
3 | Pulp Fiction | 1994-10-17 | Crime/Thriller | 3 |
4 | Inception | 2010-07-16 | Action/Sci-Fi | 4 |
5 | Interstellar | 2014-11-07 | Adventure/Sci-Fi | 5 |
id | firstName | lastName | birthdate | realName | alias | story |
---|---|---|---|---|---|---|
1 | Frank | Darabont | 1959-01-28 | Francis Lawrence Darabont | None | Known for his work on The Green Mile and The Mist. |
2 | Robert | Zemeckis | 1951-05-14 | Robert Lee Zemeckis | Bob Z. | Known for directing Back to the Future and Forrest Gump. |
3 | Quentin | Tarantino | 1963-03-27 | Quentin Jerome Tarantino | QT | Known for his unique style of filmmaking and memorable dialogue. |
4 | Christopher | Nolan | 1970-07-30 | Christopher Edward Nolan | Chris | Known for his thought-provoking films such as Inception and Interstellar. |
5 | Jonathan | Nolan | 1976-09-11 | Jonathan Rowland Nolan | Jony | Brother of Christopher Nolan and co-writer of many of his movies. |
id | firstName | lastName | dateOfBirth | movieId |
---|---|---|---|---|
(→ Movies.id) | ||||
1 | Tom | Hanks | 1956-07-09 | 1 |
2 | Robin | Williams | 1958-07-21 | 2 |
3 | John | Travolta | 1974-02-18 | 3 |
4 | Leonardo | DiCaprio | 1974-11-11 | 4 |
5 | Ellen | Page | 1987-02-21 | 5 |
id | actorID | movieID | roleName | characterDescription |
---|---|---|---|---|
(→ Actors.id) | (→ Movies.id) | |||
1 | 1 | 1 | Andy Dufresne | A banker who is falsely accused of murder. |
2 | 2 | 2 | Benjamin Buford "Bubba" Blue | A man with a passion for shrimp. |
3 | 3 | 3 | Vincent Vega | A hitman with an appreciation for good music. |
4 | 4 | 4 | Cobb | A thief who steals ideas from people's dreams. |
5 | 5 | 5 | Cooper | A pilot and scientist trying to save humanity. |
id | albumTitle | releaseYear | artistId |
---|---|---|---|
(→ Artists.id) | |||
1 | Nevermind | 1991 | 1 |
2 | Ten | 1991 | 2 |
3 | Mellon Collie and the Infinite Sadness | 1995 | 3 |
4 | Siamese Dream | 1993 | 4 |
5 | The Colour and the Shape | 1996 | 5 |
id | birthdate | realName | alias | story |
---|---|---|---|---|
1 | 1967-02-20 | Kurt Donald Cobain | Kurt Cobain | Lead singer and guitarist of Nirvana. |
2 | 1964-12-23 | Edward Louis Severson III | Eddie Vedder | Lead singer of Pearl Jam. |
3 | 1967-03-17 | William Patrick Corgan Jr. | Billy Corgan | Frontman and songwriter of The Smashing Pumpkins. |
4 | 1942-06-20 | Brian Douglas Wilson | None | Founding member and leader of The Beach Boys. |
5 | 1955-04-30 | Stanley Clarke | None | One of the most influential bass players in jazz fusion. |