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