DBD

Tables (7)

Flight

  • flight_id — Primary key — NOT NULL
  • airplane (departuredate)
  • departuredate (departuretime)
  • Field3 (arrivaldate)
  • Field4 (arrivaltime)
  • Field (from)
  • Field (to)

Untitled (Pilot)

  • Key (flight_id) — Primary key — NOT NULL
  • Field (first_name)
  • Field (last_name)
  • Field (contactnumber)
  • Field (designation)
  • Field (pilotlicense)

Untitled (Boarding Pass)

  • Key (boarding pass_id) — Primary key — NOT NULL
  • Field (flight_id)
  • Field (passenger_id)
  • Field (ticket_id)
  • Field (gate)
  • Field (hascheckedin)
  • Field (hasboarded)
  • Field (baggage)
  • Field (meal)

Untitled (Passenger)

  • Key (passenger_id) — Primary key — NOT NULL
  • Field (last_name)
  • Field (email_address)
  • Field (contactnumber)

Untitled (Cabin Crew)

  • Key (cabin crew_id) — Primary key — NOT NULL
  • Field (flight_id)
  • Field (first_name)
  • Field (last_name)
  • Field (contactnumber)
  • Field (designation)

Untitled (Airplane)

  • Key (aeroplane_id) — Primary key — NOT NULL
  • Field (airline_id)
  • Field (modelnumber)
  • Field (manufacturer)

Untitled (Ticket)

  • Key (ticket_id) — Primary key — NOT NULL
  • Field (passenger_id)