ONLINE_BOOKING_SITE

Tables (7)

Bookings

  • booking_id — INT
  • user_id — INT
  • schedule_id — INT
  • seat_id — INT
  • booking_time — TIMESTAMP
  • status — ENUM('Reserved', 'Cancelled')

Movies

  • movie_id — INT
  • title — VARCHAR(100) — NOT NULL
  • genre — VARCHAR(50)
  • duration — INT — NOT NULL
  • release_date — DATE
  • created_at — TIMESTAMP

Payments

  • payment_id — INT
  • booking_id — INT
  • amount — DECIMAL(10, 2) — NOT NULL
  • payment_method — ENUM('Credit Card', 'Debit Card', 'PayPal', 'Cash') — NOT NULL
  • payment_status — ENUM('Pending', 'Completed', 'Failed')
  • payment_time — TIMESTAMP

Schedules

  • schedule_id — INT
  • movie_id — INT
  • theater_id — INT
  • show_time — DATETIME — NOT NULL
  • available_seats — INT — NOT NULL

Seats

  • seat_id — INT
  • theater_id — INT
  • seat_number — VARCHAR(10) — NOT NULL
  • seat_type — ENUM('Regular', 'VIP')

Theaters

  • theater_id — INT
  • name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(255) — NOT NULL
  • total_seats — INT — NOT NULL
  • created_at — TIMESTAMP

Users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP