데베설 팀플

테이블 (14)

AIRLINE (Untitled)

  • AIRLINE_NUM (Key) — 기본 키 — NOT NULL
  • AIRPORT_NUM (Key2) — 외래 키 → AIRPORT.AIRPORT_NUM — NOT NULL
  • AIRLINE_NAME (Field)
  • AIRLINE_ADDRESS (Field2)

AIRPORT (Untitled2)

  • AIRPORT_NUM (Key) — 기본 키 — NOT NULL
  • AIRPORT_NAME (Field)
  • AIRPORT_ADDRESS (Field2)

AIRPORTBUS (Untitled9)

  • AIRPORTBUS_NUM (Key) — 기본 키 — NOT NULL
  • AIRPORT_NUM (Key2) — 외래 키 → AIRPORT.AIRPORT_NUM — NOT NULL
  • AIRPORTBUS_DEPARTURE_TIME (Field)
  • AIRPORTBUS_ ARRIVAL_TIME (Field2)

CABIN_CREW (Untitled6)

  • EMPLOYEE_NUM (Key) — 기본 키 — NOT NULL

DEPARTMENT (Untitled3)

  • DEPARTMENT_NUM (Key) — 기본 키 — NOT NULL
  • AIRLINE_NUM (Key2) — 외래 키 → AIRLINE.AIRLINE_NUM — NOT NULL
  • DEPARTMENT_NAME (Field)

EMPLOYEE (Untitled4)

  • EMPLOYEE_NUM (Key) — 기본 키 — NOT NULL
  • DEPARTMENT_NUM (Key2) — 외래 키 → DEPARTMENT.DEPARTMENT_NUM — NOT NULL
  • EMPLOYEE_NAME (Field)
  • EMPLOYEE_ADDRESS (Field2)
  • EMPLOYEE_PHONENUM (Field3)
  • EMPLOYEE_TYPE (Field4)

FLIGHT (Untitled8)

  • FLIGHT_NUM (Key) — 기본 키 — NOT NULL

LUGGAGE (Untitled14)

  • LUGGAGE_NUM (Key) — 기본 키 — NOT NULL
  • PASSEGER_ID (Key2) — 외래 키 → PASSEGER.PASSEGER_ID — NOT NULL
  • LUGGAGE_WEIGHT (Field)
  • LUGGAGE_PRICE (Field2)

PASSEGER (Untitled13)

  • PASSEGER_ID (Key) — 기본 키 — NOT NULL
  • PASSEGER_NAME (Field)
  • PASSEGER_PHONENUM (Field2)
  • PASSEGER_ADDRESS (Field4)
  • PASSEGER_MILEAGE (Field3)

PLIOT (Untitled5)

  • EMPLOYEE_NUM (Key) — 기본 키 — NOT NULL

RESERVATION (Untitled12)

  • RESERVATION_NUM (Key) — 기본 키 — NOT NULL
  • AIRPORT_NUM (Key2) — 외래 키 → SCHEDULE.AIRPORT_NUM — NOT NULL
  • RESERVED_SEAT_NUM (Key4) — 외래 키 → RESERVED_SEAT.RESERVED_SEAT_NUM — NOT NULL
  • PASSEGER_ID (Key5) — 외래 키 → PASSEGER.PASSEGER_ID — NOT NULL
  • RESERVATION_DATE (Field)
  • RESERVATION_PRICE (Field2)

RESERVED_SEAT (Untitled10)

  • RESERVED_SEAT_NUM (Key) — 기본 키 — NOT NULL
  • SEAT_NUM (Key2) — 외래 키 → SEAT.SEAT_NUM — NOT NULL
  • FLIGHT_NUM (Key22) — 외래 키 → SEAT.FLIGHT_NUM — NOT NULL

SCHEDULE (Untitled7)

  • AIRPORT_NUM (Key) — 기본 키 — NOT NULL
  • AIRPORT_NUM (Key2) — 외래 키 → AIRPORT.AIRPORT_NUM — NOT NULL
  • FLIGHT_NUM (Key3) — 외래 키 → FLIGHT.FLIGHT_NUM — NOT NULL
  • SCHEDULE_ DEPARTURE_TIME (Field)
  • SCHEDULE_ ARRIVAL_TIME (Field2)
  • SCHEDULE_ DEPARTURE_AIRPORT_NUM (Field3)
  • SCHEDULE_ ARRIVAL_TIME_AIRPOT_NUM (Field4)

SEAT (Untitled11)

  • SEAT_NUM (Key) — 기본 키 — NOT NULL
  • FLIGHT_NUM (Key2) — 외래 키 → FLIGHT.FLIGHT_NUM — NOT NULL