class Cart(db.Model): id = db.Column(db.Integer, primary_key=True) product_id = db.Column(db.Integer, db.ForeignKey('product.id'), nullable=False) product_name = db.Column(db.String, nullable=False) qty = db.Column(db.Integer, nullable=False) price = db.Column(db.Float(2, 2), nullable=False) owner_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class Feature(db.Model): id = db.Column(db.Integer, primary_key=True) feature = db.Column(db.Text, nullable=False) product_id = db.Column(db.Integer, db.ForeignKey('product.id')) def __repr__(self): return f"Feature('{self.feature}')"
class ContactUs(db.Model): id = db.Column(db.Integer, primary_key=True) subject = db.Column(db.String(100), nullable=False) content = db.Column(db.Text, nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post('{self.title}', '{self.date_posted}')"
class Review(db.Model): review_star = db.Column(db.Integer, primary_key=True) review_meaning = db.Column(db.String, nullable=False) product_id = db.Column(db.Integer, db.ForeignKey('product.id')) def __repr__(self): return f"Review('{self.review_star}', '{self.review_meaning}')"
class Size(db.Model): id = db.Column(db.Integer, primary_key=True) size_number = db.Column(db.Integer, nullable=False) size_name = db.Column(db.String(20), nullable=False) product_id = db.Column(db.Integer, db.ForeignKey('product.id')) def __repr__(self): return f"Size('{self.size_number}', '{self.size_name}')"
class Product(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(60), nullable=False) price = db.Column(db.Integer, nullable=False) quantity = db.Column(db.Integer, nullable=False) image_product = db.Column(db.String(60), nullable=False) feature = db.relationship('Feature', backref='product_features', lazy=True) size = db.relationship('Size', backref='product_size', lazy=True) review = db.relationship('Review', backref='product_review', lazy=True) #Changed gender = db.Column(db.Integer, db.ForeignKey('gender.id')) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id')) seller_id = db.Column(db.Integer, db.ForeignKey('seller.id')) def __repr__(self): return f"Product('{self.name}', '{self.price}', '{self.quantity}')"
class Order(db.Model): id = db.Column(db.Integer, primary_key=True) address = db.Column(db.String(100), nullable=False) postal = db.Column(db.String(100), nullable=False) cardNumber = db.Column(db.String(100), nullable=False) expDate = db.Column(db.String(100), nullable=False) cvv = db.Column(db.String(100), nullable=False) product_name = db.Column(db.String, nullable=False) qty = db.Column(db.Integer, nullable=False) price = db.Column(db.String, nullable=False) totalsum = db.Column(db.Float(2, 2), nullable=False) owner_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class CustomerBought(db.Model): id = db.Column(db.Integer, primary_key=True) price = db.Column(db.Integer, nullable=False) size = db.Column(db.Integer, nullable=False) name = db.Column(db.String(60), nullable=False) quantity = db.Column(db.Integer, nullable=False) date_bought = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) image_product = db.Column(db.String(60), nullable=False) customer_id = db.Column(db.Integer, db.ForeignKey('customer.id')) def __repr__(self): return f"CustomerBought('{self.name}', '{self.date_bought}', '{self.price}', '{self.quantity}')"
class Customer(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(60), nullable=False) is_customer = db.Column(db.Boolean, server_default="1") customer_bought = db.relationship('CustomerBought', backref='customer_bought', lazy=True) #Changed gender = db.Column(db.Integer, db.ForeignKey('gender.id')) def __repr__(self): return f"User('{self.username}', '{self.email}')"