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 |
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 |
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 |
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 |
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 |
id | name | manager_id |
---|---|---|
(→ employee.id) | ||
1 | Operations | 1 |
2 | Maintenance | 2 |
3 | Customer Service | 3 |
4 | Administration | 4 |