Productions
ProductionID | Title | ReleaseDate |
1 | Movie One | 2021-01-01 |
2 | Film Two | 2021-05-01 |
3 | Series Three | 2021-07-01 |
4 | Documentary Four | 2021-09-01 |
5 | Show Five | 2021-11-01 |
Locations
LocationID | Name | Type |
1 | Studio Sets 1 | Studio_Set |
2 | Exterior Shoots 1 | Exterior |
3 | Interior Scenes 1 | Interior |
4 | Sound Stage 1 | Stage |
5 | Backlot 1 | Backlot |
Productions_Locations
ProductionID | LocationID |
(→ Productions.ProductionID) | (→ Locations.LocationID) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 2 |
Actors
ActorID | FirstName | LastName | Birthdate |
1 | John | Doe | 1980-06-23 |
2 | Jane | Smith | 1978-05-12 |
3 | Emma | Wilson | 1992-04-01 |
4 | Tom | Brown | 1995-03-16 |
5 | Alice | Green | 1990-07-29 |
Cast
ProductionID | ActorID | Role |
(→ Productions.ProductionID) | (→ Actors.ActorID) | |
1 | 1 | Lead Actor |
1 | 2 | Supporting Actor |
2 | 3 | Lead Actor |
2 | 4 | Supporting Actor |
3 | 5 | Narrator |