HouseID | Name |
---|---|
1 | New Horizon Pictures |
2 | Star Studios |
3 | Silver Screen Entertainment |
4 | Moonlight Films |
5 | Sunset Cinema |
FilmID | Title | ReleaseYear | Budget | BoxOffice | HouseID |
---|---|---|---|---|---|
(→ ProductionHouse.HouseID) | |||||
1 | The Dark Knight | 2008 | 180000000.0 | 1006000000.0 | 1 |
2 | Avatar | 2009 | 300000000.0 | 2748000000.0 | 2 |
3 | Titanic | 1997 | 200000000.0 | 2202000000.0 | 3 |
4 | Jurassic Park | 1993 | 63000000.0 | 914000000.0 | 4 |
5 | Forrest Gump | 1994 | 55000000.0 | 677000000.0 | 5 |
ActorID | FirstName | LastName | BirthDate | RoleInFilm | FilmID |
---|---|---|---|---|---|
(→ Film.FilmID) | (→ Film.FilmID) | ||||
1 | Leonardo | DiCaprio | 1974-11-11 | 1 | 1 |
2 | Christian | Bale | 1974-01-30 | 2 | 2 |
3 | Kate | Winslet | 1975-10-05 | 3 | 1 |
4 | Samuel | L. Jackson | 1948-12-21 | 4 | 3 |
5 | Tom | Hanks | 1956-07-09 | 5 | 4 |
DirectorID | FirstName | LastName | BirthDate | DirectedFilm | FilmID |
---|---|---|---|---|---|
(→ Film.FilmID) | (→ Film.FilmID) | ||||
1 | Christopher | Nolan | 1970-07-30 | 1 | 1 |
2 | James | Cameron | 1954-08-16 | 2 | 2 |
3 | Robert | Zemeckis | 1951-05-14 | 3 | 1 |
4 | Steven | Spielberg | 1946-12-18 | 4 | 3 |
5 | Ron | Howard | 1954-03-13 | 5 | 4 |
ProducerID | FirstName | LastName | BirthDate | ProducedFilm | FilmID |
---|---|---|---|---|---|
(→ Film.FilmID) | (→ Film.FilmID) | ||||
1 | Debra | Franicich | 1957-07-01 | 1 | 1 |
2 | Joel | Silva | 1965-08-05 | 2 | 2 |
3 | Bonnie | Timmermann | 1963-06-12 | 3 | 1 |
4 | Michael | De Luca | 1961-07-13 | 4 | 3 |
5 | Gary | Goetzman | 1960-08-16 | 5 | 4 |
StuntID | Coordinator | Experience | SceneID | FilmID |
---|---|---|---|---|
(→ Film.FilmID) | (→ Film.FilmID) | |||
1 | Johnny | 10 years | None | 1 |
2 | Emily | 5 years | None | 2 |
3 | David | 15 years | None | 3 |
4 | Anna | 20 years | None | 4 |
5 | Mark | 7 years | None | 5 |
SceneID | Choreographer | Experience | SceneDescription | FilmID |
---|---|---|---|---|
(→ Film.FilmID) | ||||
1 | Jackie | 10 years | A fight scene on a train. | 1 |
2 | Alex | 5 years | A fight scene at an airport. | 2 |
3 | Luke | 15 years | A fight scene in a dark alley. | 3 |
4 | Helen | 20 years | A fight scene in a castle. | 4 |
5 | Mike | 7 years | A fight scene on a rooftop. | 5 |