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