airports

idnamecitycountry
1GatwickLondonUK
2HeathrowLondonUK
3JFKNew YorkUSA
4Dubai InternationalDubaiUAE
5Charles de GaulleParisFrance

flights

idflight_numberdeparture_timearrival_timeorigin_iddestination_id
(→ airports.id)(→ airports.id)
1AA1012023-01-01 08:00:002023-01-01 12:00:0012
2BA2022023-01-02 09:00:002023-01-02 16:00:0021
3UA3032023-01-03 07:00:002023-01-03 14:00:0034
4EK4042023-01-04 08:00:002023-01-04 15:00:0041
5AF1012023-01-05 07:00:002023-01-05 13:00:0023

passengers

idfirst_namelast_namepassport_numberflight_id
(→ flights.id)
1JohnSmithABC1234561
2JaneDoeDEF6789011
3MichaelJacksonXYZ9876542
4EmmaWatsonPQR1234562
5LeonardoDiCaprioRST9876543

customs_immigration

idpassenger_idstatusclearance_timecustomsimmigration
(→ passengers.id)
11Processed2023-01-01 10:00:00YesYes
22Processed2023-01-01 10:15:00NoYes
33Pending2023-01-01 11:00:00NoneNone
44Processed2023-01-01 11:30:00YesYes
55Processed2023-01-01 11:45:00NoYes