Films
FilmID | Title | ReleaseYear |
1 | The Shawshank Redemption | 1994 |
Directors
DirectorID | Name | BirthDate |
1 | Frank Darabont | 1959-01-28 |
Actors
ActorID | Name | BirthDate |
1 | Tim Robbins | 1958-10-16 |
Roles
RoleID | FilmID | ActorID |
| (→ Films.FilmID) | (→ Actors.ActorID) |
1 | 1 | 1 |
Locations
LocationID | Address | City | State | Country |
1 | 123 Main St | Gotham | NY | USA |
Shooting_Schedule
ScheduleID | LocationID | RoleID | StartTime | EndTime |
| (→ Locations.LocationID) | (→ Roles.RoleID) | | |
1 | 1 | 1 | 2022-01-01 07:00:00 | 2022-01-01 18:00:00 |
Dining_Establishments
EstablishmentID | Type | Name | Address | City | State | Country |
1 | Restaurant | Green Leaf | 456 Elm St | Metropolis | CA | USA |
2 | Restaurant | Fresh Harvest | 789 Oak St | Gotham | NY | USA |
3 | Restaurant | Steak House | 123 Maple Ave | Gotham | NY | USA |
4 | Cafe | Brewed Awakenings | 456 Pine St | Metropolis | CA | USA |
5 | Cafe | Java Junction | 789 Cedar Ln | Metropolis | CA | USA |
Meals
MealID | EstablishmentID | MenuOption |
| (→ Dining_Establishments.EstablishmentID) | |
1 | 1 | Vegetarian |
2 | 2 | Vegetarian |
3 | 3 | Non-Vegetarian |
4 | 4 | Vegetarian |
5 | 5 | Non-Vegetarian |
Equipment
EquipmentID | Description | Quantity |
1 | Camera | 2 |
Budgets
BudgetId | FilmId | TotalCost |
| (→ Films.FilmId) | |
1 | 1 | 10000000 |