db schema

users:
  id, username, password

tickets:
  id, booking_id, amount, discount, seat_id, show_id

bookings
  id, user_id, total, ticket_counts

screens
  id, theatre_id, capacity

seats
  id, screen_id, number

theatres
  id, name, city_id

cities
  id, name, state_id

shows
  id, movie_id, screen_id, start_at, close_at, price

movies
  id, movie_name, lanugage