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