korailtalk

Tables (6)

NomalSeat (일반석)

  • id (Key) — Long — Primary key — NOT NULL
  • id (열차 id) — Long — Foreign key → Train.id — NOT NULL
  • total_seats (일반석 총석) — Integer
  • remaining_seats (일반석 잔여석) — Integer
  • price (가격) — Integer

PreminumSeat (특별석)

  • Key — Long — Primary key — NOT NULL
  • id (열차 id) — Long — Foreign key → Train.id — NOT NULL
  • total_seats (특별석 총석) — Integer
  • total_seats (특별석 잔여석) — Integer
  • price (가격) — Integer

ReservationQueue (예약대기)

  • id (Key) — Long — Primary key — NOT NULL
  • id (열차 id) — Long — Foreign key → Train.id — NOT NULL
  • created_at (예약생성 시간) — LocalDateTime
  • expire_at (예약만료 시간) — LocalDateTime
  • seat_type (열차 종류) — ENUM(NORMAL,PREMIUM)

Train (열차 정보)

  • id (Key) — Long — Primary key — NOT NULL
  • start_at (출발시간) — LocalDateTime
  • arrive_at (도착시간) — LocalDateTime
  • type (열차 종류) — ENUM(KTX, KTX-S, KTX-C, ITX-N, ITX-M, ITX-Y, FLOWER, SRT)
  • train_number (열차 번호) — String
  • origin (출발지) — String
  • destination (도착지) — String

coupon (쿠폰)

  • id (Key) — Long — Primary key — NOT NULL
  • name (쿠폰명) — String
  • discount_rate (할인율) — Integer

national_member (국가보훈자)

  • id (Key) — Long — Primary key — NOT NULL
  • password (비밀번호) — Integer
  • birthdate (생년월일) — LocalDate
  • national_id (보훈번호) — Varchar