class Department(db.Model): __tablename__ = 'departments' department_id = db.Column(db.Integer, primary_key=True) name = db.Column(CIText(), unique=True, nullable=False) products = db.relationship('Product', backref="department", lazy=True) def __repr__(self): return f'Department({self.department_id}, {self.name})'
class UserJwt(db.Model): __tablename__ = 'user_jwts' user_jwt_id = db.Column(db.Integer, primary_key=True) jwt = db.Column(CIText(), nullable=False) date_created = db.Column(db.DateTime, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('users.user_id'), nullable = False) def __repr__(self): return f'UserJwt({self.user_jwt_id}, {self.jwt}, {self.date_created}, {self.user_id})'
class User(db.Model): __tablename__ = 'users' user_id = db.Column(db.Integer, primary_key=True) email = db.Column(CIText(), unique=True, nullable=False) first_name = db.Column(CIText(), nullable=False) password = db.Column(CIText(), nullable=False) date_created = db.Column(db.DateTime, default=datetime.utcnow) jwts = db.relationship('UserJwt', backref="user", lazy=True) def __repr__(self): return f'User({self.user_id}, {self.email}, {self.password}, {self.date_created})'
class ProductView(db.Model): __tablename__ = 'products_view' product_id = db.Column(db.Integer, primary_key=True) description = db.Column(CIText(), unique=True, nullable=False) last_sold = db.Column(db.Date, nullable=True) shelf_life_days = db.Column(db.Integer, nullable=True) sell_price = db.Column(db.Float, nullable=False) cost_expense = db.Column(db.Float, nullable=False) qty_sold_in = db.Column(db.Integer, nullable=False) department = db.Column(db.String(50), nullable=False) unit = db.Column(db.String(50), nullable=False) def __repr__(self): return f'ProductView({self.product_id}, {self.description}, {self.last_sold}, {self.shelf_life_days}, {self.sell_price}, {self.cost_expense}, {self.qty_sold_in}, {self.department}, {self.unit})'
class Product(db.Model): __tablename__ = 'products' product_id = db.Column(db.Integer, primary_key=True) description = db.Column(CIText(), unique=True, nullable=False) last_sold = db.Column(db.Date, nullable=True) shelf_life_days = db.Column(db.Integer, nullable=True) sell_price = db.Column(db.Float, nullable=False) cost_expense = db.Column(db.Float, nullable=False) qty_sold_in = db.Column(db.Integer, nullable=False) department_id = db.Column(db.Integer, db.ForeignKey('departments.department_id'), nullable=False) unit_id = db.Column(db.Integer, db.ForeignKey('units.unit_id'), nullable=False) def __repr__(self): return f'Product({self.product_id}, {self.description}, {self.last_sold}, {self.shelf_life_days}, {self.sell_price})'