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