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