Customers
customerID | name | passportID | Biometric_Authentication | Manual_Verification |
1 | James Davies | 1234567890 | 1 | 1 |
2 | John Smith | 987654321 | 0 | 0 |
3 | Emma Jones | 9876543210 | 1 | 0 |
4 | Michael Brown | 1234567891 | 0 | 1 |
5 | Lisa Wilson | 9999999999 | 1 | 1 |
Flights
flightID | departureTime | arrivalTime | destination |
1 | 2023-01-01 09:00:00 | 2023-01-01 12:00:00 | New York |
2 | 2023-01-02 10:00:00 | 2023-01-02 14:00:00 | Los Angeles |
3 | 2023-01-03 11:00:00 | 2023-01-03 15:00:00 | Chicago |
4 | 2023-01-04 12:00:00 | 2023-01-04 16:00:00 | Dallas |
5 | 2023-01-05 13:00:00 | 2023-01-05 17:00:00 | Houston |
Passports
passportID | expiryDate | issuingCountry |
1 | 2025-12-31 | United States |
2 | 2024-12-31 | Canada |
3 | 2023-12-31 | United Kingdom |
4 | 2022-12-31 | Australia |
5 | 2021-12-31 | Germany |
CustomerFlightMap
customerID | flightID | passportID |
(→ Customers.customerID) | (→ Flights.flightID) | (→ Passports.passportID) |
1 | 1 | 1234567890 |
2 | 2 | 987654321 |
3 | 3 | 9876543210 |
4 | 4 | 1234567891 |
5 | 5 | 9999999999 |
Biometrics
biometryID | customerID | biometricData |
| (→ Customers.customerID) | |
1 | 1 | None |
2 | 2 | None |
3 | 3 | None |
4 | 4 | None |
5 | 5 | None |
ManualVerifications
verificationID | customerID | manualInfo |
| (→ Customers.customerID) | |
1 | 1 | None |
2 | 2 | None |
3 | 3 | None |
4 | 4 | None |
5 | 5 | None |