## airport

id | name | city | country
--- | --- | --- | ---
1 | San Francisco International | San Francisco | USA
2 | Los Angeles International | Los Angeles | USA
3 | Dubai International | Dubai | UAE
4 | Heathrow Airport | London | UK
5 | Tokyo Haneda | Tokyo | Japan

## terminal

id | name | code | capacity | airport_id
--- | --- | --- | --- | ---
|  |  |  | (→ airport.id)
1 | Terminal 1 | T1 | 30 | 1
2 | Terminal 2 | T2 | 60 | 1
3 | Terminal 3 | T3 | 70 | 2
4 | Terminal 4 | T4 | 90 | 2
5 | Terminal 5 | T5 | 110 | 3

## flight

id | number | date | departure_time | arrival_time | origin_airport_id | destination_airport_id | aircraft_type | status
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ airport.id) | (→ airport.id) |  |
1 | AA123 | 2023-01-01 08:00 | 09:00 | 10:00 | 1 | 2 | Boeing 787 | Operational
2 | UA456 | 2023-01-01 11:00 | 12:00 | 13:00 | 1 | 3 | Airbus A320 | Delayed
3 | KL789 | 2023-01-01 15:00 | 16:00 | 17:00 | 2 | 4 | Boeing 777 | On Time
4 | QR101 | 2023-01-01 18:00 | 19:00 | 20:00 | 3 | 5 | Airbus A380 | Canceled
5 | EK246 | 2023-01-01 21:00 | 22:00 | 23:00 | 4 | 6 | Boeing 777 | Operational

## medical_facility

id | type | supplies | location | capacity | airport_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ airport.id)
1 | Medical Clinic | Bandages and Antiseptics | Terminal 1, Gate B12 | None | 1
2 | Medical Clinic | Intravenous Fluids and Oxygen | Terminal 2, Gate C14 | None | 1
3 | First Aid Station | Bandages and Antiseptics | Terminal 3, Gate D16 | None | 2
4 | First Aid Station | Pain Relief Medications and Splints | Terminal 4, Gate E18 | None | 2
5 | Pharmacy | Prescription Medications and Over-the-Counter Drugs | Terminal 5, Gate F20 | None | 3

## employee

id | firstname | lastname | role | hire_date | salary | department_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ department.id)
1 | John | Smith | Manager | 2022-01-01 | 75000 | 1
2 | Jane | Doe | Assistant Manager | 2022-01-15 | 60000 | 1
3 | Michael | Williams | Security Officer | 2022-02-01 | 45000 | 2
4 | Laura | Jackson | Housekeeping Supervisor | 2022-02-15 | 35000 | 3
5 | David | Martinez | Janitorial Staff | 2022-03-01 | 25000 | 4

## department

id | name | manager_id
--- | --- | ---
|  | (→ employee.id)
1 | Operations | 1
2 | Maintenance | 2
3 | Customer Service | 3
4 | Administration | 4