class SearchS(db.Model):
__tablename__ = 'search'
id = db.Column('id', db.Integer, primary_key=True)
string = db.Column('string', db.String)
frequency = db.Column('frequency', db.Integer, default=1)
has_recipe = db.Column('has_recipe', db.Boolean, default=False)
class TestRecipe(db.Model):
__tablename__ = 'ScrapyData'
id = db.Column('id', db.Integer, primary_key=True)
title = db.Column('title', db.String)
img_link = db.Column('img_link', db.String)
text = db.Column('text', db.String)
steps = db.Column('steps', db.String)
class Comment(db.Model):
__tablename__ = 'comments'
id = db.Column('id', db.Integer, primary_key=True)
content = db.Column('content', db.String)
user = db.Column('user', db.Integer)
recipe = db.Column('recipe', db.Integer)
update_time = db.Column('update_time', db.DateTime)
class Recipe(db.Model):
__tablename__ = 'recipes'
id = db.Column('id', db.Integer, primary_key=True)
title = db.Column('title', db.String)
img_link = db.Column('img_link', db.String)
steps = db.Column('steps', db.String)
update_time = db.Column('update_time', db.DateTime)
like = db.Column('like', db.Integer, default=0)
author = db.Column('author', db.Integer)
cook_time = db.Column('cook_time', db.Integer)
describe = db.Column('describe', db.String)
img_type = db.Column('img_type', db.String)
class User(db.Model):
__tablename__ = 'users'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
username = db.Column('username', db.String)
password = db.Column('password', db.String)
email = db.Column('email', db.String)
exp = db.Column('exp', db.Integer, default=0)
visit_time = db.Column('visit_time', db.DateTime)
max_exp = db.Column('max_exp', db.Integer, default=0)
class RecType(db.Model):
__tablename__ = 'rec_type'
id = db.Column('id', db.Integer, primary_key=True)
name = db.Column('name', db.String)
class Favorite(db.Model):
__tablename__ = 'favorites'
id = db.Column('id', db.Integer, primary_key=True)
user = db.Column('user', db.Integer)
recipe = db.Column('recipe', db.Integer)
class Ingredient(db.Model):
__tablename__ = 'ingredients'
id = db.Column('id', db.Integer, primary_key=True)
name = db.Column('name', db.String)
class RelRecType(db.Model):
__tablename__ = 'relation_rec_type'
id = db.Column('id', db.Integer, primary_key=True)
r_id = db.Column('r_id', db.Integer)
t_id = db.Column('t_id', db.Integer)
class UserPre(db.Model):
__tablename__ = 'user_pre'
id = db.Column('id', db.Integer, primary_key=True)
user = db.Column('user', db.Integer)
pre = db.Column('pre', db.Integer)
class RecIng(db.Model):
__tablename__ = 'rec_ing'
id = db.Column('id', db.Integer, primary_key=True)
recipe = db.Column('recipe', db.Integer)
ingredient = db.Column('ingredient', db.Integer)
class RelIngType(db.Model):
__tablename__ = 'relation_ing_type'
id = db.Column('id', db.Integer, primary_key=True)
ingredient = db.Column('ingredient', db.Integer)
type = db.Column('type', db.Integer)
