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)