test

Tables (11)

airline

  • id — BIGINT
  • airline_code — VARCHAR(20)
  • airline_name — BIGINT
  • airline_country — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

airport

  • id — BIGINT
  • airport_name — VARCHAR(50)
  • country — VARCHAR(50)
  • state — VARCHAR(50)
  • city — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

baggage

  • id — BIGINT
  • weight_in_kg — DECIMAL(4,2)
  • created_date — TIMESTAMP
  • updated_date — TIMESTAMP
  • booking_id — BIGINT

baggage_check

  • id — BIGINT
  • check_result — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • booking_id — BIGINT
  • passenger_id — BIGINT

boarding_pass

  • id — BIGINT
  • qr_code — VARCHAR(65535)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • booking_id — BIGINT

booking

  • bookingid — BIGINT
  • flight_id — BIGINT
  • status — VARCHAR(20)
  • booking_platform — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • passenger_id — BIGINT

flight_manifest

  • id — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • booking_id — BIGINT
  • flight_id — BIGINT

flights

  • flight_id — BIGINT
  • departing_gate — VARCHAR(20)
  • arriving_gate — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • airline_id — BIGINT
  • departing_airport_id — BIGINT
  • arriving_airport_id — BIGINT

no_fly_list

  • id — BIGINT
  • active_from — DATE
  • active_to — DATE
  • no_fly_reason — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • psgnr_id — BIGINT

passengers

  • id — BIGINT
  • first_name — VARCHAR(50)
  • last_name — VARCHAR(50)
  • date_of_birth — DATE
  • country_of_citizenship — VARCHAR(50)
  • country_of_residence — VARCHAR(50)
  • passport_number — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

security_check

  • id — BIGINT
  • check_result — VARCHAR(20)
  • comments — VARCHAR(65535)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • passenger_id — BIGINT