Directors
DirectorID | Name | BirthDate | Nationality |
1 | John Doe | 1968-07-23 | American |
2 | Jane Smith | 1970-03-10 | Canadian |
Producers
ProducerID | Name | ContactNumber | Email | AssociatedDirector |
| | | | (→ Directors.DirectorID) |
1 | Alice Brown | +1234567890 | ab@email.com | 1 |
2 | Charlie Green | +0987654321 | cg@email.com | 2 |
Films
FilmID | Title | ReleaseYear | FilmType | Budget | ProductionCompanyID |
| | | | | (→ Companies.CompanyID) |
1 | The Documentary | 2000 | Documentary | 500000.0 | 1 |
2 | Another Doc | 2001 | Documentary | 750000.0 | 1 |
3 | A Short Film | 2002 | Short Film | 500000.0 | 2 |
4 | Yet Another Short | 2003 | Short Film | 300000.0 | 2 |
Actors
ActorID | FirstName | LastName | DateOfBirth |
1 | Tom | Hanks | 1956-07-09 |
2 | Meryl | Streep | 1949-06-22 |
Casts
RoleID | FilmID | ActorID | CharacterName | AppearanceFee |
| (→ Films.FilmID) | (→ Actors.ActorID) | | |
1 | 1 | 1 | Main Lead | 100000 |
2 | 2 | 2 | Supporting Role | 50000 |
Companies
CompanyID | CompanyName | AddressLine1 | AddressLine2 | City | StateOrRegion | PostalCode | Country |
1 | Big Movie Co. | 123 Main St. | | New York | NY | 10001 | USA |
2 | Small Indie Studio | 456 Elm Rd. | | Los Angeles | CA | 90001 | USA |