class OrderModel(db.Model): __tablename__ = 'order' id = db.Column(db.Integer, primary_key=True) amount = db.Column(db.Integer, nullable=False) shipment = db.Column(db.String(100), nullable=False) ship_Address = db.Column(db.String(100), nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
class User(db.Model): __tablename__ = 'user' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100), nullable=False) email = db.Column(db.String(100), nullable=False, unique=True) password = db.Column(db.String(50), nullable=False) role = db.Column(db.String(50), nullable=False)
class UserAddress(db.Model): id = db.Column(db.Integer, primary_key=True) address = db.Column(db.String(250), nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False, Unique=True)
class OrderDetail(db.Model): _tablename__ = 'order_detail' id = db.Column(db.Integer, primary_key=True) order_id = db.Column(db.Integer, db.ForeignKey('orders.id')) product_id = db.Column(db.Integer, db.ForeignKey('product.id')) quantity = db.Column(db.Integer, nullable=False) amount = db.Column(db.Integer, nullable=False) ship_address = db.Column(db.String(100), nullable=False)
class Comments(db.Model): __tablename__='comments' id = db.Column(db.Integer, primary_key=True) comment=db.Column(db.String(255),nullable=False) upvote = db.Column(db.Integer,nullable=True) downvote=db.Column(db.Integer,nullable=True) user_id = db.Column(db.Integer,db.ForeignKey('user.id')) product_id=db.Column(db.Integer,db.ForeignKey('product.id'))
class Productmeta(db.Model): id = db.Column(db.Integer, primary_key=True) image_path = db.Column(db.String(100), nullable=False) product_id = db.Column(db.Integer, db.ForeignKey('product.id'))
class PaymentModel(db.Model): __tablename__ = 'payment' id = db.Column(db.Integer, primary_key=True) payment_type = db.Column(db.String(200), nullable=False) amount = db.Column(db.Integer, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
class Product(db.Model): __tablename__ = 'product' id = db.Column(db.Integer, primary_key=True) product_name = db.Column(db.String(100), nullable=False) product_price = db.Column(db.Float, nullable=False) product_category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
class WhislistModel(db.model): __tablename__ = 'Mywhislist' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100), nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
class Category(db.Model): __tablename__ = 'category' id = db.Column(db.Integer, primary_key=True) category_name = db.Column(db.String(200), unique=True, nullable=False)