class Inspections(db.Model): __tablename__ = 'inspections' id = db.Column(db.Integer, primary_key=True) week_ending = db.Column(db.Date) fiscal_month = db.Column(db.String(20)) fiscal_year = db.Column(db.Integer) week_of_month = db.Column(db.Integer) week_of_year = db.Column(db.Integer) quarter = db.Column(db.Integer) concept = db.Column(db.String(15)) location = db.Column(db.String(15)) date_measured = db.Column(db.Date) score = db.Column(db.Float) def __init__(self, week_ending, fiscal_month, fiscal_year, week_of_month, week_of_year, quarter, concept, location, date_measured, score): self.week_ending = week_ending self.fiscal_month = fiscal_month self.fiscal_year = fiscal_year self.week_of_month = week_of_month self.week_of_year = week_of_year self.quarter = quarter self.concept = concept self.location = location self.date_measured = date_measured self.score = score
class CashierEfficiency(db.Model): __tablename__ = 'ce' id = db.Column(db.Integer, primary_key=True) week_ending = db.Column(db.Date) fiscal_week = db.Column(db.Integer) fiscal_month = db.Column(db.String(20)) fiscal_year = db.Column(db.Integer) week_of_month = db.Column(db.Integer) location = db.Column(db.String(20)) date_measured = db.Column(db.Date) tm_name = db.Column(db.String(50)) tm_sales = db.Column(db.Float) tm_minutes = db.Column(db.Integer) tm_efficiency = db.Column(db.Float) mod_one = db.Column(db.String(50)) mod_two = db.Column(db.String(50)) def __init__(self, week_ending, fiscal_week, fiscal_month, fiscal_year, week_of_month, location, date_measured, tm_name, tm_sales, tm_minutes, tm_efficiency, mod_one, mod_two): self.week_ending = week_ending self.fiscal_week = fiscal_week self.fiscal_month = fiscal_month self.fiscal_year = fiscal_year self.week_of_month = week_of_month self.location = location self.date_measured = date_measured self.tm_name = tm_name self.tm_sales = tm_sales self.tm_minutes = tm_minutes self.tm_efficiency = tm_efficiency self.mod_one = mod_one self.mod_two = mod_two
class StoreAssessments(db.Model): __tablename__='storeassessments' id=db.Column(db.Integer,primary_key=True) month_ending=db.Column(db.Date) fiscal_month=db.Column(db.String(20)) location=db.Column(db.String(20)) score=db.Column(db.Float)
class FoodVariance(db.Model): __tablename__='foodvariance' id=db.Column(db.Integer,primary_key=True) month_ending=db.Column(db.Date) fiscal_month=db.Column(db.String(20)) location=db.Column(db.String(20)) score=db.Column(db.Float)
class GMTimes(db.Model): __tablename__ = 'gmtimes' id = db.Column(db.Integer, primary_key=True) week_ending = db.Column(db.Date) fiscal_week = db.Column(db.Integer) location = db.Column(db.String(20)) date_measured = db.Column(db.Date) time_measure = db.Column(db.DateTime(40)) order_type = db.Column(db.String(20)) score = db.Column(db.Integer) paid = db.Column(db.Boolean)
class FiscalCalendar(db.Model): __tablename__='fiscalcalendar' id=db.Column(db.Integer,primary_key=True) date=db.Column(db.Date) week_ending=db.Column(db.Date) fiscal_year=db.Column(db.Integer) fiscal_quarter=db.Column(db.Integer) fiscal_month=db.Column(db.String(20)) fiscal_week=db.Column(db.Integer) week_of_month=db.Column(db.Integer) day_of_week=db.Column(db.String(15))
class Users(UserMixin, db.Model): __tablename__='users' id=db.Column(db.Integer,primary_key=True) email=db.Column(db.String(50), unique=True) username=db.Column(db.String(20), unique=True) hashed_password=db.Column(db.String(256)) def set_password(self, password): self.hashed_password = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.hashed_password, password)
class OrderAccuracy(db.Model): __tablename__ = 'orderaccuracy' id = db.Column(db.Integer, primary_key=True) week_ending = db.Column(db.Date) fiscal_month = db.Column(db.String(20)) fiscal_year = db.Column(db.Integer) week_of_month = db.Column(db.Integer) week_of_year = db.Column(db.Integer) quarter = db.Column(db.Integer) location = db.Column(db.String(15)) concept = db.Column(db.String(15)) inaccurate_count = db.Column(db.Integer)
class BagTimes(db.Model): __tablename__ = 'bagtimes' id = db.Column(db.Integer, primary_key=True) week_ending = db.Column(db.Date) fiscal_month = db.Column(db.String(20)) fiscal_year = db.Column(db.Integer) week_of_month = db.Column(db.Integer) week_of_year = db.Column(db.Integer) quarter = db.Column(db.Integer) location = db.Column(db.String(20)) week_avg = db.Column(db.Integer) month_avg = db.Column(db.Integer) quarter_avg = db.Column(db.Integer)
class ToGoLabel(db.Model): __tablename__ = 'tgl' id = db.Column(db.Integer, primary_key=True) week_ending = db.Column(db.Date) fiscal_month = db.Column(db.String(20)) fiscal_year = db.Column(db.Integer) week_of_month = db.Column(db.Integer) week_of_year = db.Column(db.Integer) quarter = db.Column(db.Integer) location = db.Column(db.String(15)) date_measured = db.Column(db.Date) number_measured = db.Column(db.Integer) number_passed = db.Column(db.Integer)
class TacoTimes(db.Model): __tablename__ = 'tacotimes' id = db.Column(db.Integer, primary_key=True) week_ending = db.Column(db.Date) fiscal_month = db.Column(db.String(20)) fiscal_year = db.Column(db.Integer) week_of_month = db.Column(db.Integer) week_of_year = db.Column(db.Integer) quarter = db.Column(db.Integer) concept = db.Column(db.String(20)) location = db.Column(db.String(20)) date_measured = db.Column(db.Date) score = db.Column(db.DateTime(40)) time_in_seconds = db.Column(db.Integer)
class GameFilm(db.Model): __tablename__ = 'gamefilm' id = db.Column(db.Integer, primary_key=True) week_ending = db.Column(db.Date) fiscal_month = db.Column(db.String(20)) fiscal_year = db.Column(db.Integer) week_of_month = db.Column(db.Integer) week_of_year = db.Column(db.Integer) quarter = db.Column(db.Integer) concept = db.Column(db.String(20)) location = db.Column(db.String(20)) date_measured = db.Column(db.Date) type = db.Column(db.String(50)) score = db.Column(db.Integer)
class Sales(db.Model): __tablename__ = 'sales' id = db.Column(db.Integer, primary_key=True) week_ending = db.Column(db.Date) fiscal_month = db.Column(db.String(20)) fiscal_year = db.Column(db.Integer) week_of_month = db.Column(db.Integer) week_of_year = db.Column(db.Integer) concept = db.Column(db.String(15)) location = db.Column(db.String(15)) sales = db.Column(db.Float) bbq_sales = db.Column(db.Float) taco_sales = db.Column(db.Float) group_meal_sales = db.Column(db.Float) mavn_sales = db.Column(db.Float) doordash_sales = db.Column(db.Float) total_guest_count = db.Column(db.Integer) bbq_guest_count = db.Column(db.Integer) taco_guest_count = db.Column(db.Integer) def __init__(self, week_ending, fiscal_month, fiscal_year, week_of_month, week_of_year, concept, location, sales, bbq_sales, taco_sales, group_meal_sales, mavn_sales, doordash_sales, total_guest_count, bbq_guest_count, taco_guest_count): self.week_ending = week_ending self.fiscal_month = fiscal_month self.fiscal_year = fiscal_year self.week_of_month = week_of_month self.week_of_year = week_of_year self.concept = concept self.location = location self.sales = sales self.bbq_sales = bbq_sales self.taco_sales = taco_sales self.group_meal_sales = group_meal_sales self.mavn_sales = mavn_sales self.doordash_sales = doordash_sales self.total_guest_count = total_guest_count self.bbq_guest_count = bbq_guest_count self.taco_guest_count = taco_guest_count
class LineTimes(db.Model): __tablename__ = 'linetimes' id = db.Column(db.Integer, primary_key=True) week_ending = db.Column(db.Date) fiscal_week = db.Column(db.Integer) location = db.Column(db.String(20)) date_measured = db.Column(db.Date) am_taken = db.Column(db.Integer) am_out = db.Column(db.Integer) am_over_11 = db.Column(db.Integer) pm_taken = db.Column(db.Integer) pm_out = db.Column(db.Integer) pm_over_11 = db.Column(db.Integer)