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)