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)