Flight service

Service flow

Scheduled flight

1. Booking is inserted as soon as a pilot books his flight.
2. Flight is inserted 30 minutes before EOBT.
3. Subsequently, Booking is deleted.

Charter flight

1. Flight is inserted as soon as a pilot logs on via ACARS.

Termination

• Logbook and Itinerary are inserted upon reaching destination.
• Flight is deleted if the pilot cancels the flight.
• Flight is deleted if the pilot stays offline for 30 minutes or more.
• Flight is deleted once the aircraft reaches its destination.

Database schema

Pilots

Flightplan belongs to either Booking or Flight, cascading on its deletion.

• Booking: future flights reserved by pilots
• Logbook: flight history

Passengers

Ticket belongs to Flight.

• Ticket: tickets sold to each passenger
• Itinerary: journey history