Biometric_Authentication
id | customer | date | status |
1 | James Davies | 2024-03-13 17:13:29 | None |
2 | John Smith | 2024-03-13 17:13:29 | None |
Manual_Verification
id | customer | date | status |
1 | James Davies | 2024-03-13 17:13:29 | None |
2 | Michael Johnson | 2024-03-13 17:13:29 | None |
Flight
flightNumber | departureAirport | destinationAirport | departureTime | arrivalTime |
None | New York | London | 2023-01-01 10:00:00 | 2023-01-01 16:00:00 |
None | Los Angeles | Paris | 2023-01-02 10:00:00 | 2023-01-02 18:00:00 |
Aircraft
aircraftId | model | capacity | registrationNumber |
None | Boing 787 Dreamliner | 350 | N900AN |
None | Airbus A380 | 853 | EI-DUB |
CheckIn
checkinID | passengerName | flightNum | boardingPassNum | checkedBaggage | checkInTime |
| | (→ Flight.flightNumber) | | | |
1 | James Davies | 1 | 100 | 1 | 2023-01-01 09:00:00 |
2 | Emma Watson | 2 | 200 | 0 | 2023-01-02 09:00:00 |
Baggage
baggageId | customer | weight | description |
None | James Davies | 25.0 | Laptop Bag |
None | Emma Watson | 30.0 | Cosmetic Bag |