ManyToMany -
SQLAlchemy(Flask)
users_groups = db.Table('users_groups',
db.Column("user_id", db.Integer, db.ForeignKey("User.id")),
db.Column("group_id", db.Integer, db.ForeignKey("Group.id"))
)
class User(db.Model):
__tablename__ = "User"
id = db.Column(db.Integer, primary_key=True)
group_id = db.Column(db.Integer, db.ForeignKey('Group.id'))
groups = db.relationship('Group',secondary=users_groups, backref='users')
class Group
__tablename__ = "Group"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(30), default="plz set group name")
46 / 85