Customers

customerIDnamepassportIDBiometric_AuthenticationManual_Verification
1James Davies123456789011
2John Smith98765432100
3Emma Jones987654321010
4Michael Brown123456789101
5Lisa Wilson999999999911

Flights

flightIDdepartureTimearrivalTimedestination
12023-01-01 09:00:002023-01-01 12:00:00New York
22023-01-02 10:00:002023-01-02 14:00:00Los Angeles
32023-01-03 11:00:002023-01-03 15:00:00Chicago
42023-01-04 12:00:002023-01-04 16:00:00Dallas
52023-01-05 13:00:002023-01-05 17:00:00Houston

Passports

passportIDexpiryDateissuingCountry
12025-12-31United States
22024-12-31Canada
32023-12-31United Kingdom
42022-12-31Australia
52021-12-31Germany

CustomerFlightMap

customerIDflightIDpassportID
(→ Customers.customerID)(→ Flights.flightID)(→ Passports.passportID)
111234567890
22987654321
339876543210
441234567891
559999999999

Biometrics

biometryIDcustomerIDbiometricData
(→ Customers.customerID)
11None
22None
33None
44None
55None

ManualVerifications

verificationIDcustomerIDmanualInfo
(→ Customers.customerID)
11None
22None
33None
44None
55None