ticket_booking_erd

Tables (11)

bookings

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • performance_id — BIGINT — Foreign key → performances.id — NOT NULL
  • seat_id — BIGINT — Foreign key → seats.id — NOT NULL
  • user_coupon_id — BIGINT — Foreign key → user_coupons.id
  • total_price — INT — NOT NULL
  • status — ENUM('PENDING', 'CONFIRMED', 'CANCELLED', 'EXPIRED') — NOT NULL
  • booked_at — DATETIME — NOT NULL
  • expired_at — DATETIME

coupons

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — ENUM('FIXED', 'RATE') — NOT NULL
  • discount_value — INT — NOT NULL
  • total_quantity — INT — NOT NULL
  • issued_quantity — INT — NOT NULL
  • valid_from — DATETIME — NOT NULL
  • valid_until — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

events

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • venue — VARCHAR(200) — NOT NULL
  • category — ENUM('CONCERT', 'SPORTS', 'MUSICAL', 'EXHIBITION') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notifications

  • id — BIGINT — Primary key — NOT NULL
  • booking_id — BIGINT — Foreign key → bookings.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — ENUM('BOOKING_CONFIRMED', 'BOOKING_CANCELLED', 'PAYMENT_SUCCESS', 'PAYMENT_FAILED', 'REMINDER') — NOT NULL
  • channel — ENUM('EMAIL', 'SMS', 'PUSH') — NOT NULL
  • status — ENUM('PENDING', 'SUCCESS', 'FAILED') — NOT NULL
  • content — TEXT — NOT NULL
  • retry_count — INT — NOT NULL
  • sent_at — DATETIME
  • created_at — DATETIME — NOT NULL

payments

  • id — BIGINT — Primary key — NOT NULL
  • booking_id — BIGINT — Foreign key → bookings.id — NOT NULL
  • amount — INT — NOT NULL
  • method — ENUM('CARD', 'KAKAO_PAY', 'TOSS', 'NAVER_PAY') — NOT NULL
  • status — ENUM('PENDING', 'SUCCESS', 'FAILED', 'REFUNDED') — NOT NULL
  • pg_transaction_id — VARCHAR(255)
  • paid_at — DATETIME
  • created_at — DATETIME — NOT NULL

performances

  • id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → events.id — NOT NULL
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • total_seats — INT — NOT NULL
  • available_seats — INT — NOT NULL
  • status — ENUM('SCHEDULED', 'OPEN', 'SOLD_OUT', 'CANCELLED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

seats

  • id — BIGINT — Primary key — NOT NULL
  • zone_id — BIGINT — Foreign key → zones.id — NOT NULL
  • seat_number — VARCHAR(20) — NOT NULL
  • status — ENUM('AVAILABLE', 'RESERVED', 'BOOKED') — NOT NULL
  • reserved_at — DATETIME
  • reserved_by — BIGINT — Foreign key → users.id

user_coupons

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • coupon_id — BIGINT — Foreign key → coupons.id — NOT NULL
  • is_used — TINYINT(1) — NOT NULL
  • issued_at — DATETIME — NOT NULL
  • used_at — DATETIME

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • role — ENUM('USER', 'ADMIN') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

waiting_queue

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • performance_id — BIGINT — Foreign key → performances.id — NOT NULL
  • queue_rank — INT — NOT NULL
  • status — ENUM('WAITING', 'ENTERED', 'EXPIRED') — NOT NULL
  • entered_at — DATETIME — NOT NULL
  • expired_at — DATETIME

zones

  • id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → events.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • grade — ENUM('VIP', 'R', 'S', 'A', 'STANDING') — NOT NULL
  • price — INT — NOT NULL
  • total_seats — INT — NOT NULL