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)