## 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