심쪽이

테이블 (5)

Cancellation (Untitled3)

  • cancellation_id (Key) — 기본 키 — NOT NULL
  • member_number (회원번호) — 외래 키 → Member.member_number — NOT NULL
  • seat_class_id (Key2) — 외래 키 → SeatClass.seat_class_id — NOT NULL
  • cancellation_datetime (Field)
  • refund_amount (Field2)

Flight (항공편)

  • flight_id (항공편 PK) — 기본 키 — NOT NULL
  • name (항공기이름)
  • departure_airport (출발공항)
  • arrival_airport (도착공항)
  • departure_datetime (출발날짜시간)
  • arrival_datetime (도착날짜시간)

Member (회원)

  • member_number (회원번호) — 기본 키 — NOT NULL
  • name (이름)
  • password (비밀번호)
  • email (이메일)
  • passport_number (여권번호)

Reservation (Untitled2)

  • reservation_id (Key) — 기본 키 — NOT NULL
  • member_number (회원번호) — 외래 키 → Member.member_number — NOT NULL
  • seat_class_id (Key2) — 외래 키 → SeatClass.seat_class_id — NOT NULL
  • price (Field2)
  • reservation_datetime (Field)

SeatClass (Untitled)

  • seat_class_id (Key) — 기본 키 — NOT NULL
  • flight_id (항공편 PK) — 외래 키 → Flight.flight_id — NOT NULL
  • seat_class (Field)
  • total_seats (Field2)
  • remaining_seats (Field4)
  • price (Field3)