airline_reservation_ERD

Tables (9)

Flights (비행)

  • 비행_id (id) — int — Primary key — NOT NULL
  • 비행기_id (plane_id) — int — Foreign key → Plane.비행기_id — NOT NULL
  • 출발시간 (departure_time) — datetime — NOT NULL
  • 도착시간 (arrival_time) — datetime — NOT NULL
  • 승객수 (number_of_passengers) — int — NOT NULL

Location (위치)

  • 위치id (id) — int — Primary key — NOT NULL
  • 도시이름 (city_name) — varchar — NOT NULL
  • 인구수 (population) — int — NOT NULL
  • 국가 (country) — varchar — NOT NULL
  • 공항이름 (airport_name) — varchar — NOT NULL

Mileage (마일리지)

  • 승객id (passenger_id) — int — Foreign key → Passenger.승객id — NOT NULL
  • 적립양 (amount) — int — NOT NULL

Passenger (승객)

  • 승객id (id) — int — Primary key — NOT NULL
  • 이름 (name) — varchar — NOT NULL
  • 성별 (gender) — varchar — NOT NULL
  • 번호 (phone_number) — varchar — NOT NULL
  • 흡연여부 (smoking_preference) — tinyint — NOT NULL

Plane (비행기)

  • 비행기_id (id) — int — Primary key — NOT NULL
  • 타입 (type) — varchar — NOT NULL
  • 생산일자 (year_manufactured) — datetime — NOT NULL
  • 엔진타입 (engine_type) — varchar — NOT NULL
  • 좌석수 (seat_capacity) — int — NOT NULL

Reservation (예약)

  • 예약id (id) — int — Primary key — NOT NULL
  • 처리상태 (status) — tinyint — NOT NULL

Seats (좌석)

  • 좌석Id (id) — int — Primary key — NOT NULL
  • 타입 (type) — varchar — NOT NULL
  • 예약여부 (reservatino_status) — tinyint — NOT NULL

departure (출발지)

  • 위치id (id) — int — Foreign key → Location.위치id — NOT NULL
  • 비행_id (id2) — int — Foreign key → Flights.비행_id — NOT NULL
  • 비행기_id (plane_id) — int — Foreign key → Flights.비행기_id — NOT NULL

destination (도착지)

  • 위치id (id) — int — Foreign key → Location.위치id — NOT NULL
  • 비행_id (id2) — int — Foreign key → Flights.비행_id — NOT NULL
  • 비행기_id (plane_id) — int — Foreign key → Flights.비행기_id — NOT NULL