데베설 팀플

테이블 (11)

AIRLINE (Untitled10)

  • AIRLINE_ID (Key) — 기본 키 — NOT NULL
  • airline_code (Field)
  • airline_name (Field2)
  • airline_country (Field3)
  • created_at (Field4)
  • updated_at (Field5)

AIRPORT (Untitled6)

  • AIRPORT_ID (Key) — 기본 키 — NOT NULL
  • airport_name (Field)
  • country (Field2)
  • state (Field3)
  • city (Field4)
  • created_at (Field5)
  • updated_at (Field6)

BAGGAGE (Untitled8)

  • BAGGAGE_ID (Key) — 기본 키 — NOT NULL
  • PASSENGERS_ID (Key22) — 외래 키 → BOOKING.PASSENGERS_ID — NOT NULL
  • weight_in_kg (Field)
  • created_at (Field2)
  • updated_at (Field3)

BAGGAGE_CHECK (Untitled3)

  • BAGGAGE_CHECK_ID (Key) — 기본 키 — NOT NULL
  • BOOKING_ID (Key3) — 외래 키 → BOOKING.BOOKING_ID — NOT NULL
  • PASSENGERS_ID (Key22) — 외래 키 → NO_FLY_LIST.PASSENGERS_ID — NOT NULL
  • check_result (Field)
  • created_at (Field2)
  • updated_at (Field3)

BOARDING_PASS (Untitled11)

  • BOARDING_PASS_ID (Key) — 기본 키 — NOT NULL
  • BOOKING_ID (Key2) — 외래 키 → BOOKING.BOOKING_ID — NOT NULL
  • PASSENGERS_ID (Key22) — 외래 키 → BOOKING.PASSENGERS_ID — NOT NULL
  • qr_code (Field)
  • created_at (Field2)
  • updated_at (Field3)

BOOKING (Untitled7)

  • BOOKING_ID (Key) — 기본 키 — NOT NULL
  • PASSENGERS_ID (Key2) — 외래 키 → PASSENGERS.PASSENGERS_ID — NOT NULL
  • flight_id (Field)
  • status (Field2)
  • booking_platform (Field3)
  • created_at (Field4)
  • updated_at (Field5)

FLIGHTS (Untitled5)

  • FLIGHTS_ID (Key) — 기본 키 — NOT NULL
  • AIRLINE_ID (Key2) — 외래 키 → AIRLINE.AIRLINE_ID — NOT NULL
  • AIRPORT_ID (Key3) — 외래 키 → AIRPORT.AIRPORT_ID — NOT NULL
  • departing_gate (Field)
  • arriving_gate (Field2)
  • created_at (Field3)
  • updated_at (Field4)

FLIGHTS_MANIFEST (Untitled9)

  • FLIGHTS_MANIFEST_ID (Key) — 기본 키 — NOT NULL
  • BOOKING_ID (Key2) — 외래 키 → BOOKING.BOOKING_ID — NOT NULL
  • FLIGHTS_ID (Key3) — 외래 키 → FLIGHTS.FLIGHTS_ID — NOT NULL
  • created_at (Field)
  • updated_at (Field2)

NO_FLY_LIST (Untitled4)

  • NO_FLY_LIST_ID (Key) — 기본 키 — NOT NULL
  • PASSENGERS_ID (Key2) — 외래 키 → PASSENGERS.PASSENGERS_ID — NOT NULL
  • active_from (Field)
  • active_to (Field2)
  • no_fly_reason (Field3)
  • created_at (Field4)
  • updated_at (Field5)

PASSENGERS (Untitled)

  • PASSENGERS_ID (Key) — 기본 키 — NOT NULL
  • first_name (Field)
  • last_name (Field2)
  • date_of_birth (Field3)
  • country_of_citizenship (Field4)
  • country_of_residence (Field5)
  • passport_number (Field6)
  • created_at (Field7)
  • updated_at (Field8)

SECORITY_CHECK (Untitled2)

  • SECORITY_CHECK_ID (Key) — 기본 키 — NOT NULL
  • PASSENGERS_ID (Key2) — 외래 키 → PASSENGERS.PASSENGERS_ID — NOT NULL
  • check_result (Field)
  • comments (Field2)
  • created_at (Field3)
  • updated_at (Field4)