Spring_booking
Tables (8)
Orders
- id — bigint — Primary key
- USER_ID — BIGINT — Foreign key → USERS.USER_ID
- scheduleId — bigint — Foreign key → Schedule.id
- userId — BIGINT
- orderDate — date
Payment
- payment_id — BIGINT — Primary key
- CUSTOMER (USER_ID) — BIGINT — Foreign key → USERS.USER_ID
- order_id — bigint — Foreign key → Orders.id
- pay_type — ENUM('CASH', 'CARD', 'POINT') — NOT NULL
- pay_amount — BIGINT — NOT NULL
- pay_name — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- pay_success_yn — BOOLEAN — NOT NULL
- payment_key — VARCHAR(255)
- fail_reason — VARCHAR(255)
- cancel_yn — BOOLEAN — NOT NULL
- cancel_reason — VARCHAR(255)
- user_email — VARCHAR(255)
Schedule
- id — bigint — Primary key
- startStationId — bigint — Foreign key → StationInfo.stationId
- endStationId — bigint — Foreign key → StationInfo.stationId
- departureTime — varchar(10)
- arrivalTime — varchar(10)
- frequency — varchar(255)
- price — int
- carrier — varchar(255)
SeatAvailability
- id — bigint — Primary key
- scheduleId — bigint — Foreign key → Schedule.id
- seatMap — JSON
StationInfo
- stationId — bigint — Primary key
- stationtype — bigint — Foreign key → stationType.id
- stationName — varchar(255) — NOT NULL
- x — double — NOT NULL
- y — double — NOT NULL
USERS
- USER_ID — BIGINT — Primary key
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- role — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
- point — BIGINT
stationType
- id — bigint — Primary key
- stationType — varchar(255)
trainPrice
- id — bigint — Primary key
- trainScheduleId — bigint — Foreign key → Schedule.id
- general — int(10)
- special — int(10)