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