how to design movies with show times database structure how to design movies with show times database structure

I'm building simple local cinemas guide website using Yii PHP framework.

I need Correct and improve this database, specially for showtimes

Cinema / done
City / done
Country / done

Movie
  id
  title
  year
  imdb_rate
  cast
  director
  summary
  views
  featured
  available_status

Genre
  id
  name
  movie_id

movie_showing
  id
  available_status
  show_time &lt;li&gt;20:00&lt;/li&gt;&lt;li&gt;22:00&lt;/li&gt;
  movie_id  
  cinema_id

movie_video
  id
  youtube_uri
  movie_id
  trailer

movie_photo
  id
  photo_uri
  poster 0 1
  movie_id
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)