Chapter 03 심화6

테이블 (12)

Orders

  • id — bigint
  • userId — BIGINT
  • orderDate — date
  • scheduleId — BIGINT — NOT NULL

Payment

  • payment_id — BIGINT
  • pay_type — ENUM('CASH', 'CARD', 'POINT') — NOT NULL
  • pay_amount — BIGINT — NOT NULL
  • pay_name — VARCHAR(255) — NOT NULL
  • order_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • pay_success_yn — BOOLEAN — NOT NULL
  • customer — BIGINT
  • payment_key — VARCHAR(255)
  • fail_reason — VARCHAR(255)
  • cancel_yn — BOOLEAN — NOT NULL
  • cancel_reason — VARCHAR(255)
  • user_email — VARCHAR(255)
  • INDEX — idx_payment_member
  • INDEX — idx_payment_paymentKey

Schedule

  • id — bigint
  • departureTime — varchar(10)
  • arrivalTime — varchar(10)
  • frequency — varchar(255)
  • price — int
  • carrier — varchar(255)
  • startStationId — bigint
  • endStationId — bigint

SeatAvailability

  • id — bigint
  • scheduleId — bigint
  • seatMap — JSON

StationInfo

  • stationId — bigint — 기본 키
  • stationName — varchar(255) — NOT NULL
  • x — double — NOT NULL
  • y — double — NOT NULL

USERS

  • USER_ID — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • picture — VARCHAR(255)
  • provider — VARCHAR(255)
  • providerId — VARCHAR(255)
  • loginId — VARCHAR(255)
  • role — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
  • point — BIGINT
  • INDEX — (email)

stationType

  • id — bigint — 기본 키
  • stationType — varchar(255)

trainPrice

  • id — bigint
  • trainScheduleId — bigint
  • general — int(10)
  • special — int(10)

고객 (Untitled4)

  • 고객번호 (Key) — int — 기본 키 — NOT NULL
  • 이름 (Field) — VARCHAR(30)
  • 주소 (Field2) — VARCHAR(30)

극장 (Untitled)

  • 극장번호 (극장이름) — int — 기본 키 — NOT NULL
  • 극장이름 (Field) — VARCHAR(30)
  • 위치 (Field2) — VARCHAR(30)

상영관 (Untitled2)

  • 상영관번호 (Key) — int — 기본 키 — NOT NULL
  • 극장번호 (Key2) — int — 외래 키 → 극장.극장번호 — NOT NULL
  • 영화제목 (Field) — VARCHAR(30)
  • 가격 (Field2) — int
  • 좌석수 (Field3) — int

예약 (Untitled3)

  • 좌석번호 (Field) — int
  • 날짜 (Field2) — date