how to design movies with show times database structure
I would also suggest the following:


Add a movie genres table - as a movie can have one or more genres
Split up the movie_showing table as follows:


movie_showing - id, movie_id, cinema_id, details and restrictions at cinema level (this means the movie is showing at a specific cinema)
movie_showing_times - movie_showing_id, availability_status, showdate, showtime,  show details (prices, cinema showing, 3D or not, other offers for example half price etc)