Create a table in the database for Booking details

[gopiraju3]

Table : Booking:

booking_id (Primary Key)
user_id (Foreign Key referencing User table)
showtime_id (Foreign Key referencing Showtime table)
num_tickets

CREATE TABLE Booking ( booking_id INT PRIMARY KEY AUTO_INCREMENT, user_id INT NOT NULL, showtime_id INT NOT NULL, num_tickets INT NOT NULL, FOREIGN KEY (user_id) REFERENCES User(user_id), FOREIGN KEY (showtime_id) REFERENCES Showtime(showtime_id) );

[gopiraju3]

I had reviewed this issue. I didn't find any errors. It will help to complete the project. So, I closed the issue.

[Harishkumar110411]

I have created a table in database for booking details it improves the organization and makes the efficient data management and no errors are found in the code and it ensure the smooth progress of the project

[harikaboppudi10]

It makes the user easily book the tickets and also makes the developer work easy.

[Nallapati25]

This is a valuable addition. With this, user can also fetch the book details if they lost their booking details.