class Address(db.Model): __tablename__ = "address" id = db.Column('id', db.Integer, primary_key=True) zip = db.Column('zip', db.Unicode) country = db.Column('country', db.Unicode) address = db.Column('address', db.Unicode) user_id = db.Column('user_id', db.Integer, db.ForeignKey('user.id')) user = db.relationship('User', foreign_keys=user_id)
class Checkout(db.Model): __tablename__ = "checkout" id = db.Column("id", db.Integer, primary_key=True) payment = db.Column("payment", db.Unicode) total = db.Column("total", db.Numeric) created_at = db.Column("created_at", db.DateTime) completed = db.Column("completed", db.Boolean) order_id = db.Column("order_id", db.Integer, db.ForeignKey("order.id")) order = db.relationship("Order", foreign_keys=order_id)
class Items(db.Model): __tablename__ = "items" id = db.Column("id", db.Integer, primary_key=True) name = db.Column("name", db.Unicode) image = db.Column("image", db.LargeBinary) price = db.Column("price", db.Numeric) available = db.Column("available", db.Boolean) store_id = db.Column("store_id", db.Integer, db.ForeignKey("store.id")) store = db.relationship("Store", foreign_keys=store_id)
class Checkout(db.Model): __tablename__ = "checkout" id = db.Column('id', db.Integer, primary_key=True) payment = db.Column('payment', db.Unicode) total = db.Column('total', db.Numeric) created_at = db.Column('created_at', db.DateTime) completed = db.Column('completed', db.Boolean) order_id = db.Column('order_id', db.Integer, db.ForeignKey('order.id')) order = db.relationship('Order', foreign_keys=order_id)
class Items(db.Model): __tablename__ = "items" id = db.Column('id', db.Integer, primary_key=True) name = db.Column('name', db.Unicode) image = db.Column('image', db.Unicode) price = db.Column('price', db.Numeric) store_id = db.Column('store_id', db.Integer, db.ForeignKey('store.id')) available = db.Column('available', db.Boolean) store = db.relationship('Store', foreign_keys=store_id)
class Address(db.Model): __tablename__ = "address" id = db.Column("id", db.Integer, primary_key=True) zip_code = db.Column("zip_code", db.Unicode) state = db.Column("country", db.Unicode) city = db.Column("city", db.Unicode) address = db.Column("address", db.Unicode) number_house = db.Column("number_house", db.Unicode) user_id = db.Column("user_id", db.Integer, db.ForeignKey("user.email")) user = db.relationship("User", foreign_keys=user_id) def __repr__(self): return self.zip_code
class Items(db.Model): __tablename__ = "items" id = db.Column("id", db.Integer, primary_key=True) name = db.Column("name", db.Unicode) quantity = db.Column("quantity", db.Integer) price = db.Column("price", db.Float(asdecimal=True, decimal_return_scale=2)) description = db.Column("description", db.Text(length=None)) store_id = db.Column("store_id", db.Integer, db.ForeignKey("store.name_store")) available = db.Column("available", db.Boolean) store = db.relationship("Store", foreign_keys=store_id) def __repr__(self): return self.name