콘서트예약_서비스

테이블 (9)

CONCERT (콘서트)

  • id — int — 기본 키 — NOT NULL — auto increment
  • name (콘서트명) — varchar(100) — NOT NULL

CONCERT_SCHEDULE (콘서트 일정)

  • id — int — 기본 키 — NOT NULL — auto increment
  • concert_id (콘서트id) — int — 외래 키 → CONCERT.id — NOT NULL — auto increment, unique1-1
  • schedule_at (일시) — timestamp — NOT NULL — unique1-2
  • total_seats (좌석수) — int — NOT NULL

PAY_HISTORY (결제 내역)

  • id — int — 기본 키 — NOT NULL — auto increment
  • user_id (회원id) — BINARY(16) — UUID, idx1-1
  • email (이메일) — varchar(255)
  • concert_id (콘서트id) — int
  • concert_name (콘서트명) — varchar(100)
  • concert_schedule_id (콘서트일정id) — int — idx2
  • schedule_at (콘서트일시) — timestamp
  • seat_id (좌석id) — int
  • seat_number (좌석번호) — int
  • seat_price (좌석가격) — int
  • amount (결제금액) — int
  • pay_at (결제일시) — timestamp — idx1-2(desc)
  • status (결제상태) — varchar(20) — SUCCESS, FAILED, CANCELED
  • reason (사유) — varchar(255) — 포인트부족, 임시배정만료,사용자취소 등

POINT_HISTORY (포인트 내역)

  • id — int — 기본 키 — NOT NULL — auto increment
  • user_id (회원id) — BINARY(16) — 외래 키 → USER.id — NOT NULL — UUID, idx1-1
  • type (종류) — varchar(20) — NOT NULL — CHARGE, USE
  • amount (금액) — int — NOT NULL
  • current_point (현재포인트) — int — NOT NULL — 충전,사용 후 보유 포인트
  • created_at (생성일시) — timestamp — NOT NULL — idx1-2(desc)

REFRESH_TOKEN (리프레시토큰)

  • id — int — 기본 키 — NOT NULL — auto increment
  • user_id (회원id) — BINARY(16) — 외래 키 → USER.id — NOT NULL — UUID, idx1
  • token (토큰값) — varchar(600) — NOT NULL — unique
  • issued_at (발행일시) — timestamp — NOT NULL
  • expired_at (만료일시) — timestamp

RESERVATION_TOKEN (대기열토큰)

  • id — BINARY(16) — 기본 키 — NOT NULL — UUID
  • user_id (회원id) — BINARY(16) — 외래 키 → USER.id — NOT NULL — UUID
  • status (상태) — varchar(20) — NOT NULL — WAITING, ALLOWED, TIMEOUT, COMPLETED
  • updated_at (수정일시) — timestamp — NOT NULL
  • issued_at (발행일시) — timestamp — NOT NULL
  • expired_at (만료일시) — timestamp

SEAT (좌석)

  • id — int — 기본 키 — NOT NULL — auto increment
  • concert_schedule_id (콘서트일정id) — int — 외래 키 → CONCERT_SCHEDULE.id — NOT NULL — auto increment, unique1-1, idx2-1
  • number (좌석번호) — int — NOT NULL — 1~50번, unique1-2
  • price (가격) — int — NOT NULL
  • user_id (회원id) — BINARY(16) — 외래 키 → USER.id — UUID, idx1
  • status (상태) — varchar(20) — NOT NULL — AVAILABLE, TEMP_RESERVED, RESERVED, EXPIRED, HOLD (idx2-2)
  • released_at (배정해제일시) — timestamp
  • reserved_at (예약일시) — timestamp

USER (회원)

  • id — BINARY(16) — 기본 키 — NOT NULL — UUID
  • email (이메일) — varchar(255) — NOT NULL — unique
  • password (비밀번호) — varchar(255) — NOT NULL
  • name (이름) — varchar(50) — NOT NULL
  • phone (휴대폰번호) — varchar(20) — NOT NULL
  • point (포인트) — int — NOT NULL
  • role (권한) — varchar(20) — NOT NULL — USER, ADMIN
  • created_at (생성일시) — timestamp — NOT NULL
  • updated_at (수정일시) — timestamp — NOT NULL

Untitled