RailloV2 ERD

Tables (26)

BATCH_JOB_EXECUTION

  • JOB_EXECUTION_ID — bigint — NOT NULL
  • VERSION — bigint
  • JOB_INSTANCE_ID — bigint — NOT NULL
  • CREATE_TIME — datetime(6) — NOT NULL
  • START_TIME — datetime(6)
  • END_TIME — datetime(6)
  • STATUS — varchar(10)
  • EXIT_CODE — varchar(2500)
  • EXIT_MESSAGE — varchar(2500)
  • LAST_UPDATED — datetime(6)

BATCH_JOB_EXECUTION_CONTEXT

  • JOB_EXECUTION_ID — bigint — NOT NULL
  • SHORT_CONTEXT — varchar(2500) — NOT NULL
  • SERIALIZED_CONTEXT — text

BATCH_JOB_EXECUTION_PARAMS

  • JOB_EXECUTION_ID — bigint — NOT NULL
  • PARAMETER_NAME — varchar(100) — NOT NULL
  • PARAMETER_TYPE — varchar(100) — NOT NULL
  • PARAMETER_VALUE — varchar(2500)
  • IDENTIFYING — char — NOT NULL

BATCH_JOB_EXECUTION_SEQ

  • ID — bigint — NOT NULL
  • UNIQUE_KEY — char — NOT NULL

BATCH_JOB_INSTANCE

  • JOB_INSTANCE_ID — bigint — NOT NULL
  • VERSION — bigint
  • JOB_NAME — varchar(100) — NOT NULL
  • JOB_KEY — varchar(32) — NOT NULL

BATCH_JOB_SEQ

  • ID — bigint — NOT NULL
  • UNIQUE_KEY — char — NOT NULL

BATCH_STEP_EXECUTION

  • STEP_EXECUTION_ID — bigint — NOT NULL
  • VERSION — bigint — NOT NULL
  • STEP_NAME — varchar(100) — NOT NULL
  • JOB_EXECUTION_ID — bigint — NOT NULL
  • CREATE_TIME — datetime(6) — NOT NULL
  • START_TIME — datetime(6)
  • END_TIME — datetime(6)
  • STATUS — varchar(10)
  • COMMIT_COUNT — bigint
  • READ_COUNT — bigint
  • FILTER_COUNT — bigint
  • WRITE_COUNT — bigint
  • READ_SKIP_COUNT — bigint
  • WRITE_SKIP_COUNT — bigint
  • PROCESS_SKIP_COUNT — bigint
  • ROLLBACK_COUNT — bigint
  • EXIT_CODE — varchar(2500)
  • EXIT_MESSAGE — varchar(2500)
  • LAST_UPDATED — datetime(6)

BATCH_STEP_EXECUTION_CONTEXT

  • STEP_EXECUTION_ID — bigint — NOT NULL
  • SHORT_CONTEXT — varchar(2500) — NOT NULL
  • SERIALIZED_CONTEXT — text

BATCH_STEP_EXECUTION_SEQ

  • ID — bigint — NOT NULL
  • UNIQUE_KEY — char — NOT NULL

booking

  • booking_id — bigint — 예매 ID' primary ke
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • booking_code — varchar(255) — NOT NULL — 고객용 예매 코드
  • booking_status — enum — NOT NULL — 예매 상태
  • cancelled_at — datetime(6) — 반환(취소) 시간
  • arrival_stop_id — bigint — NOT NULL — 도착 정류장 ID
  • departure_stop_id — bigint — NOT NULL — 출발 정류장 ID
  • member_id — bigint — NOT NULL — 멤버 ID
  • order_id — bigint — NOT NULL — 주문 ID
  • train_schedule_id — bigint — NOT NULL — 운행 일정 ID

member

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • is_deleted — bit — NOT NULL
  • birth_date — date
  • email — varchar(255)
  • gender — varchar(1)
  • member_no — varchar(255)
  • name — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • phone_number — varchar(255) — NOT NULL
  • role — enum

order_booking

  • order_booking_id — bigint — 주문 예약 ID' primary ke
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • pending_booking_id — varchar(255) — NOT NULL — 예약 ID
  • total_fare — decimal(38, 2) — NOT NULL — 총 운임
  • arrival_stop_id — bigint — NOT NULL — 도착 정류장 ID
  • departure_stop_id — bigint — NOT NULL — 출발 정류장 ID
  • order_id — bigint — NOT NULL — 주문 ID
  • train_schedule_id — bigint — NOT NULL — 운행 일정 ID

order_seat_booking

  • order_seat_booking_id — bigint — 주문 좌석 예약 ID' primary ke
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • fare — decimal(38, 2) — NOT NULL — 좌석별 운임
  • passenger_type — enum — NOT NULL — 승객 유형
  • seat_id — bigint — NOT NULL — 좌석 ID
  • order_booking_id — bigint — NOT NULL — 주문 예약 ID

orders

  • order_id — bigint — 주문 ID' primary ke
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • expired_at — datetime(6) — 주문 만료 시간
  • order_code — varchar(255) — NOT NULL — 주문번호 (토스 페이먼츠 orderId)
  • order_status — enum — NOT NULL — 주문 상태
  • total_amount — decimal(38, 2) — NOT NULL — 총 주문 금액
  • member_id — bigint — NOT NULL — 멤버 ID

payment

  • payment_id — bigint — 결제 ID' primary ke
  • amount — decimal(38, 2) — NOT NULL — 결제 금액
  • cancelled_at — datetime(6) — 결제 취소 일자
  • failed_at — datetime(6) — 결제 실패 일시
  • failure_code — varchar(255) — PG 실패 코드, ex) REJECT_CARD_PAYMENT
  • failure_reason — varchar(255) — 결제 실패 사유
  • order_code — varchar(255) — NOT NULL — 주문번호 (토스 결제 요청 시 사용, TempBooking의 bookingCode)
  • paid_at — datetime(6) — 결제 일자
  • payment_key — varchar(255) — 토스페이먼츠 결제 고유 키 (결제 승인 후 발급)
  • payment_method — enum
  • payment_status — enum — NOT NULL — 결제 상태
  • refunded_at — datetime(6) — 환불 처리 일자
  • member_id — bigint — 멤버 ID
  • order_id — bigint — 주문 ID

schedule_stop

  • schedule_stop_id — bigint
  • arrival_time — time(6)
  • departure_time — time(6)
  • stop_order — int — NOT NULL
  • station_id — bigint
  • train_schedule_id — bigint

schedule_stop_template

  • arrival_time — time(6)
  • departure_time — time(6)
  • stop_order — int — NOT NULL
  • station_id — bigint
  • schedule_stop_template_id — binary(16) — NOT NULL
  • train_schedule_id — binary(16)

seat

  • seat_id — bigint
  • is_accessible — varchar(1)
  • is_available — varchar(1)
  • seat_column — varchar(1) — 좌석 열 문자(A, B, C, D)
  • seat_row — int — NOT NULL — 좌석 행 (1, 2, 3, 4)
  • seat_type — enum
  • train_car_id — bigint

seat_booking

  • seat_booking_id — bigint — 예매 좌석 ID' primary ke
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • arrival_station_id — bigint — NOT NULL — 도착역 ID
  • arrival_stop_order — int — NOT NULL — 도착 정차 순서
  • car_type — enum — NOT NULL — 객차 타입
  • departure_station_id — bigint — NOT NULL — 출발역 ID
  • departure_stop_order — int — NOT NULL — 출발 정차 순서
  • passenger_type — enum — NOT NULL — 승객 유형
  • booking_id — bigint — NOT NULL — 예매 ID
  • seat_id — bigint — NOT NULL — 좌석 ID
  • train_schedule_id — bigint — NOT NULL — 운행 일정 ID

station

  • station_id — bigint
  • station_name — varchar(255)

station_fare

  • first_class_fare — decimal(38, 2)
  • standard_fare — decimal(38, 2)
  • arrival_station_id — bigint
  • departure_station_id — bigint
  • station_fare_id — bigint

ticket

  • ticket_id — bigint — 승차권 ID' primary ke
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • fare — decimal(38, 2) — NOT NULL — 운임
  • passenger_type — enum — NOT NULL — 승객 유형
  • ticket_number — varchar(255) — NOT NULL — 승차권 번호
  • ticket_status — enum — NOT NULL — 승차권 상태
  • booking_id — bigint — NOT NULL — 예매 ID
  • seat_id — bigint — 좌석 ID

train

  • total_cars — int — NOT NULL
  • train_number — int — NOT NULL
  • train_id — bigint
  • train_name — varchar(255) — KTX, KTX-산천, ITX-청춘 등
  • train_type — enum

train_car

  • car_number — int — NOT NULL
  • seat_row_count — int — NOT NULL
  • total_seats — int — NOT NULL
  • train_car_id — bigint
  • train_id — bigint
  • seat_arrangement — varchar(255) — 2+2, 2+1
  • car_type — enum

train_schedule

  • train_schedule_id — bigint
  • arrival_time — time(6)
  • delay_minutes — int — NOT NULL
  • departure_time — time(6)
  • operation_date — date
  • operation_status — enum
  • schedule_name — varchar(255)
  • arrival_station_id — bigint
  • departure_station_id — bigint
  • train_id — bigint

train_schedule_template

  • arrival_time — time(6)
  • departure_time — time(6)
  • operating_day — int — NOT NULL
  • arrival_station_id — bigint
  • departure_station_id — bigint
  • train_id — bigint
  • train_schedule_template_id — binary(16) — NOT NULL
  • schedule_name — varchar(255)