심쪽이
테이블 (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)