과제

테이블 (7)

airplane (Untitled3)

  • id (Key) — 기본 키 — NOT NULL
  • airplane_id (Field)
  • total_no_of_seats (Field2)
  • airplane_type_id (Key2) — 외래 키 → airplane_type.id — NOT NULL

airplane_type (CopyOfUntitled)

  • id (Key) — 기본 키 — NOT NULL
  • company (Field)
  • type_name (Field2)
  • max_seats (Field3)

airport (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • airport_code (Field)
  • city (Field2)
  • state (Field3)
  • name (Field4)

airport_airplane_type (Untitled2)

  • airport_id (Key) — 외래 키 → airport.id — NOT NULL
  • airplane_type_id (Key2) — 외래 키 → airplane_type.id — NOT NULL

flight (Untitled5)

  • id (Key) — 기본 키 — NOT NULL
  • airline (Field)
  • number (Field2)
  • weekdays (Field3)

flight_legs (Untitled4)

  • flight_id (Key) — 외래 키 → flight.id — NOT NULL
  • leg_no (Field)
  • departure_airport_id (Key2) — 외래 키 → airport.id — NOT NULL
  • arrival_airport_id (Key3) — 외래 키 → airport.id — NOT NULL

leg_instance (Untitled6)

  • flight_id (Key) — 외래 키 → flight_legs.flight_id — NOT NULL
  • date (Field)
  • no_of_avail_seats (Field2)