class Offer(db.Model,UserMixin): id = db.Column(db.Integer,primary_key=True) name = db.Column(db.String(40),unique=False,nullable=False) price = db.Column(db.Integer) desc = db.Column(db.String(199)) dis = db.Column(db.Integer) productid = db.Column(db.Integer, db.ForeignKey('product.id'), nullable=False)
class Product(db.Model,UserMixin): id = db.Column(db.Integer,primary_key=True) name = db.Column(db.String(40),unique=False,nullable=False) owner = db.Column(db.String(40)) price = db.Column(db.Integer) desc = db.Column(db.String(199)) shopid = db.Column(db.Integer, db.ForeignKey('shop.id'), nullable=False) offers = db.relationship('Offer', backref='product', lazy=True) def __repr__(self): return str(self.id)
class Shop(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) owner = db.Column(db.String) name = db.Column(db.String(40), unique=False, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) phoneno = db.Column(db.String(25)) desc = db.Column(db.String(200)) image = db.Column(db.String(20), nullable=False, default='default.jpg') category = db.Column(db.String(50)) mallid = db.Column(db.Integer, db.ForeignKey('mall.id'), nullable=False) pro = db.relationship('Product', backref='shop', lazy=True) def __repr__(self): return str(self.id)