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)