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