Booking
Tables (9)
EventCategories
- category_id — INTEGER — Primary key
- category_name — VARCHAR(255) — NOT NULL
- description — TEXT
EventSeats
- event_id — VARCHAR(255) — Foreign key → Events.event_id
- seat_type_name — VARCHAR(255) — Foreign key → SeatTypes.seat_type_name
- seat_count — INTEGER — NOT NULL
Events
- event_id — VARCHAR(255) — Primary key
- title — VARCHAR(255) — NOT NULL
- event_date — DATETIME — NOT NULL
- venue — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- category_id — INTEGER — Foreign key → EventCategories.category_id
Payments
- payment_id — INTEGER — Primary key
- amount — int — NOT NULL
- payment_method — VARCHAR(255) — NOT NULL
- reservation_id — INTEGER — Foreign key → Reservations.reservation_id
- user_id (user_id2) — VARCHAR(255) — Foreign key → Users.user_id
Purchases
- purchase_id — INTEGER — Primary key
- user_id — VARCHAR(255) — Foreign key → Users.user_id
- seat_type_name — VARCHAR(255) — Foreign key → SeatTypes.seat_type_name
- event_id — VARCHAR(255) — Foreign key → Events.event_id
Reservations
- reservation_id — INTEGER — Primary key
- user_id — VARCHAR(255) — Foreign key → Users.user_id
- seat_type_name — VARCHAR(255) — Foreign key → SeatTypes.seat_type_name
- event_id — VARCHAR(255) — Foreign key → Events.event_id
SeatPrices
- event_id — VARCHAR(255) — Foreign key → Events.event_id
- seat_type_name — VARCHAR(255) — Foreign key → SeatTypes.seat_type_name
- price — int — NOT NULL
SeatTypes
- seat_type_name — VARCHAR(255) — Primary key
Users
- user_id — VARCHAR(255) — Primary key
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20)