## Food_Court

id | name | location | cuisine_type | revenue
--- | --- | --- | --- | ---
1 | Grand Café | Terminal A | Continental | $1 Million
2 | Asian Delights | Terminal B | Asian | N/A

## Retail_Shop

id | name | location | type | revenue
--- | --- | --- | --- | ---
1 | Duty Free Shop | Terminal C | Electronics & Accessories | $1 Million
2 | Books Galore | Terminal D | Book Store | N/A

## Flight

id | flight_number | departure_time | arrival_time | gate_number
--- | --- | --- | --- | ---
1 | 1 | 2022-06-01 09:00:00 | 2022-06-01 11:00:00 | 10
2 | 2 | 2022-06-02 07:00:00 | 2022-06-02 09:00:00 | 20

## Passenger

id | first_name | last_name | date_of_birth | passport_number
--- | --- | --- | --- | ---
1 | John | Smith | 1990-06-01 | ABCD1234
2 | Jane | Doe | 1991-07-02 | EFGH5678

## Aircraft

id | aircraft_model | capacity | manufacturer | year_built
--- | --- | --- | --- | ---
1 | Boeing 737 Max | 200 | Boeing | 2000
2 | Airbus A320 Neo | 200 | Airbus | 2011

## Baggage_Handling

id | airport_code | baggage_weight | destination_airport_code | handling_fee
--- | --- | --- | --- | ---
1 | LAX | 500.0 | ORD | 150
2 | ORD | 600.0 | LAX | 180