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)
