과제
테이블 (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)