Create the database skeleton

[OwenM4]

Points: 2

TODOs:

• [ ] Create the database skeleton so that the movies can be entered into it
• [ ] Fields:
  • (P) Movie ID (TMDB)
  • Date this applies to
  • Movie name
  • Actor names (4)
  • Actor images (4)
  • Possible answers
  • Hints

    Description: Create the initial creation of the database so that the other backend methods pulling from the API can add data to it.

Notes: We need to build a database to store all the movies and information we need to run the game. We will use a SQL database with the Movie ID being the primary key.

[OwenM4]

MovieID: An integer field serving as the primary key for each movie. MovieName: A string field to store the name of the movie. ActorNames: A JSON field to store actor names. You can use this to store multiple actor names in a comma-separated or JSON format. ActorImages: A JSON field to store actor images (file paths or URLs). OtherAnswers: A JSON field for additional answers related to the movie. Hints: A JSON field for storing hints. QuizDate: A date field to store the date when the movie will show in the quiz.