k-pop-ticketing

테이블 (7)

결제 (payments)

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id (userId) — BIGINT — 외래 키 → 유저.id — NOT NULL
  • amount — INT — NOT NULL
  • status — VARCHAR — NOT NULL
  • type — VARCHAR — NOT NULL
  • created_at (createdAt) — DATETIME — NOT NULL
  • updated_at (updatedAt) — DATETIME — NOT NULL

공연 (shows)

  • id — BIGINT — 기본 키 — NOT NULL
  • concert_id (concertId) — BIGINT — 외래 키 → 콘서트.id — NOT NULL
  • start_date (startDate) — DATETIME — NOT NULL
  • capacity — INT — NOT NULL
  • created_at (createdAt) — DATETIME — NOT NULL
  • updated_at (updatedAt) — DATETIME — NOT NULL

대기열 토큰 (waiting_token)

  • id — BIGINT — 기본 키 — NOT NULL
  • token — VARCHAR — NOT NULL
  • expired_at (expiredAt) — DATETIME — NOT NULL
  • status — VARCHAR — NOT NULL

예약 (reservations)

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id (userId) — BIGINT — 외래 키 → 유저.id — NOT NULL
  • show_id (showId) — BIGINT — 외래 키 → 좌석.show_id — NOT NULL
  • seat_id (seatId) — BIGINT — 외래 키 → 좌석.id — NOT NULL
  • reservation_status (reservationStatus) — VARCHAR — NOT NULL
  • created_at (createdAt) — DATETIME — NOT NULL
  • updated_at (updatedAt) — DATETIME — NOT NULL

유저 (users)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR — NOT NULL
  • balance — INT — NOT NULL
  • created_at (createdAt) — DATETIME — NOT NULL
  • updated_at (updatedAt) — DATETIME — NOT NULL

좌석 (seats)

  • id — BIGINT — 기본 키 — NOT NULL
  • show_id (showId) — BIGINT — 외래 키 → 공연.id — NOT NULL
  • number — INT — NOT NULL
  • amount — INT — NOT NULL
  • status — VARCHAR — NOT NULL
  • created_at (createdAt) — DATETIME — NOT NULL
  • updated_at (updatedAt) — DATETIME — NOT NULL

콘서트 (concerts)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR — NOT NULL
  • created_at (createdAt) — DATETIME — NOT NULL
  • updated_at (updatedAt) — DATETIME — NOT NULL