class Good(db.Model): __tablename__ = "goods" good_id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(), nullable=False) brand = db.Column(db.String(), nullable=False) price = db.Column(db.Integer, nullable=False)
class Store(db.Model): __tablename__ = "stores" store_id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(), nullable=False) city = db.Column(db.String(), nullable=False) address = db.Column(db.String(), nullable=False) manager_id = db.Column(db.Integer, db.ForeignKey("users.user_id"), nullable=False) orders = db.relationship("Order", backref="store")
class User(db.Model, UserMixin): __tablename__ = "users" user_id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(), nullable=False) email = db.Column(db.String(), nullable=False) password = db.Column(db.String(), nullable=False) def __repr__(self): return f"<id: {self.user_id}, name: {self.name}, email: {self.email}>" def get_id(self): return self.user_id
class User(db.Model, UserMixin): __tablename__ = "users" user_id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(), nullable=False) email = db.Column(db.String(), nullable=False) password = db.Column(db.String(), nullable=False) orders = db.relationship('Order', backref='user') manage_stores = db.relationship('Store', backref='user') def __repr__(self): return f"<id: {self.user_id}, name: {self.name}, email: {self.email}>" def get_id(self): return self.user_id