Question 28: The tables “movies” and “producers” are related to each …

1class Movies(db.Model):
2    id = db.Column(db.Integer(), primary_key = True)
3    movie_name = db.Column(db.String(50), nullable = False, unique = True)
4    movie_year = db.Column(db.Integer, nullable = False)
5    producers = db.relationship('Producer', backref = 'movie', secondary = 'groups')
6
7class Producer(db.Model):
8    id = db.Column(db.Integer(), primary_key = True)
9    producer_name = db.Column(db.String(50), nullable = False, unique = True)
10    productions = db.Column(db.Integer())
11
12class Groups(db.Model):
13    movie_id = db.Column(db.Integer(),db.ForeignKey('movies.id'), primary_key = True)
14    prod_id = db.Column(db.Integer(),db.ForeignKey('producer.id'), primary_key = True)