class HotHoldTable(Base):
id = db.Column(db.Integer, primary_key=True)
food_item = db.Column(db.String(20), nullable=False)
temperature = db.Column(db.String(10), nullable=False)
company_id = db.Column(db.Integer,
db.ForeignKey('user.id'),
nullable=False)
class MenuTable(Base):
id = db.Column(db.Integer, primary_key=True)
menu_item = db.Column(db.String(20), nullable=False)
ingredients = db.Column(db.String(100), nullable=False)
method = db.Column(db.String(100), nullable=False)
company_id = db.Column(db.Integer,
db.ForeignKey('user.id'),
nullable=False)
class FoodCoolingTable(Base):
id = db.Column(db.Integer, primary_key=True)
food_item = db.Column(db.String(20), nullable=False)
cooling_method = db.Column(db.String(20), nullable=False)
time_started = db.Column(db.DateTime, nullable=False)
temperature = db.Column(db.String(10), nullable=False)
company_id = db.Column(db.Integer,
db.ForeignKey('user.id'),
nullable=False)
class WastageTable(Base):
id = db.Column(db.Integer, primary_key=True)
food_item = db.Column(db.String(20), nullable=False)
quanitiy = db.Column(db.String(20), nullable=False)
unit = db.Column(db.String(20), nullable=False)
reason = db.Column(db.String(20), nullable=False)
company_id = db.Column(db.Integer,
db.ForeignKey('user.id'),
nullable=False)
class DeliveryTemperatureTable(Base):
id = db.Column(db.Integer, primary_key=True)
food_item = db.Column(db.String(20), nullable=False)
temperature = db.Column(db.String(10), nullable=False)
high_risk_food_item = db.Column(db.String(20), nullable=False)
high_risk_temperature = db.Column(db.String(10), nullable=False)
supplier_name = db.Column(db.String(20), nullable=False)
company_id = db.Column(db.Integer,
db.ForeignKey('user.id'),
nullable=False)
class FridgeFreezerTempTable(Base):
"""
Fridge and Freezer Temperature table.
company_id will return the user id. If we want to get the whole user object instead use
FridgeFreezerTempTable.backref
To accsess the users fridge/freezer records FridgeFreezerTempTable.backref.user_temp_records!
"""
id = db.Column(db.Integer, primary_key=True)
unit_name = db.Column(db.String(50), nullable=False)
unit_type = db.Column(db.String(50), nullable=False)
temperature = db.Column(db.String(10), nullable=False)
company_id = db.Column(db.Integer,
db.ForeignKey('user.id'),
nullable=False)