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)