ticketing

Tables (8)

Event

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • eventDate — DATETIME — NOT NULL
  • location — VARCHAR(255)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Payment

  • id — BIGINT — Primary key — NOT NULL
  • ticket_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • status — ENUM('PENDING', 'COMPLETED', 'FAILED') — NOT NULL
  • paymentMethod — ENUM('CREDIT_CARD', 'PAYPAL', 'BANK_TRANSFER') — NOT NULL
  • createdAt — TIMESTAMP

Reservation

  • id — BIGINT — Primary key — NOT NULL
  • reservationTime — DATETIME — NOT NULL
  • expirationTime — DATETIME — NOT NULL
  • status — ENUM('PENDING', 'CONFIRMED', 'CANCELED') — NOT NULL
  • id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
  • id (event_id) — BIGINT — Foreign key → Event.id — NOT NULL
  • id (seat_id) — BIGINT — Foreign key → Seat.id — NOT NULL

Seat

  • id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT — NOT NULL
  • seatNumber — VARCHAR(50) — NOT NULL
  • section — VARCHAR(50)
  • row — VARCHAR(10)
  • seat_grade_id — BIGINT — NOT NULL
  • status — ENUM('AVAILABLE', 'RESERVED', 'SOLD') — NOT NULL

SeatGrade

  • id — BIGINT — Primary key — NOT NULL
  • gradeName — VARCHAR(50) — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • description — TEXT

Ticket

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • event_id — BIGINT — NOT NULL
  • seat_id — BIGINT — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • status — ENUM('BOOKED', 'PAID', 'CANCELED') — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

User

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — ENUM('CUSTOMER', 'ADMIN') — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Venue

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • capacity — INT — NOT NULL