AirplaneReservation
Tables (6)
Airline (airline)
- airline_id (Key) — BIG INT — Primary key — NOT NULL — 기본키
- name (Field) — VARCHAR(255) — 항공사명
- country (Field2) — VARCHAR(255) — 항공사국적
Airplane (airplane)
- airplane_id (Key) — BIG INT — Primary key — NOT NULL
- airline_id (Key2) — BIG INT — Foreign key → Airline.airline_id — NOT NULL
- name (Field) — VARCHAR(255)
- takeOff (Field2) — VARCHAR(255) — 착륙지
- landing (Field3) — VARCHAR(255)
- takeOffTime (Field5) — TIMESTAMP
- landingTime (Field6) — TIMESTAMP
- airplainType (Field4) — VARCHAR(255)
Reservation (reservation)
- reservation_id (Key) — BIG INT — Primary key — NOT NULL
- user_id (Key2) — BIG INT — Foreign key → User.user_id — NOT NULL
- seat_id (Key3) — BIG INT — Foreign key → Seat.seat_id — NOT NULL
- airplain_id (Key22) — BIG INT — Foreign key → Seat.airplain_id — NOT NULL
- createdAt (Field) — TIMESTAMP
- price (Field2)
Seat (seat)
- seat_id (Key) — BIG INT — Primary key — NOT NULL
- airplain_id (Key2) — BIG INT — Foreign key → Airplane.airplane_id — NOT NULL
- seatstatus (Field) — VARCHAR(255)
- seatClass (Field2) — VARCHAR(255)
- seatRow (Field3) — TINYINT(2)
- alphabet (Field4) — VARCHAR(255)
User (user)
- user_id (Key) — BIG INT — Primary key — NOT NULL
- login_id (Field) — VARCHAR(30)
- password (Field2) — VARCHAR(30)
- name (Field3) — VARCHAR(255)
UserHistory (userHistory)
- userHitory_id (Key) — BIG INT — Primary key — NOT NULL
- user_id (Key2) — BIG INT — Foreign key → User.user_id — NOT NULL
- createdAt (Field) — TIMESTAMP
- lastModifiedAt (Field2) — TIMESTAMP
- Field3