데베설 팀플
테이블 (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