class Beer(db.Model): id = db.Column(db.Integer, primary_key=True) beer_name = db.Column(db.String, nullable=False) beer_abv = db.Column(db.Float, nullable=False) brewery = db.Column(db.String, nullable=False) style = db.Column(db.String, nullable=False) votes = db.Column(db.Integer, nullable=False) win = db.Column(db.Integer, nullable=False) username = db.Column(db.String, db.ForeignKey(User.username), nullable=False) session_id = db.Column(db.Integer, db.ForeignKey(Session.id), nullable=False)
class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String, unique=True, nullable=False) password = db.Column("password", db.String, nullable=False) beers = db.relationship("Beer", backref="User", lazy=True)
class Session(db.Model): id = db.Column(db.Integer, primary_key=True) date = db.Column(db.String, nullable=False) beers = db.relationship("Beer", backref="Session", lazy=True)