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