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)
class Mall(db.Model,UserMixin): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(40), unique=False, nullable=False) desc = db.Column(db.String(200)) addr1 = db.Column(db.String(100)) addr2 = db.Column(db.String(100)) addr3 = db.Column(db.String(100)) phone=db.Column(db.String(25)) open_time=db.Column(db.String(10)) close_time=db.Column(db.String(10)) latitude = db.Column(db.String(40)) Logitude = db.Column(db.String(40)) image_file = db.Column(db.String(50), nullable=False, default='default.jpg') shops = db.relationship('Shop', backref='mall', lazy=True) def __repr__(self): return str(self.id)