class Order(db.Model): __tablename__ = 'weshop_order' id = db.Column(db.Integer, primary_key=True, autoincrement=True) paid = db.Column(db.Boolean) user_id = db.Column(db.Integer, db.ForeignKey('weshop_user.id')) goods_id = db.Column(db.Integer, db.ForeignKey('weshop_goods.id')) address_id = db.Column(db.Integer, db.ForeignKey('weshop_user_address.id')) quantity = db.Column(db.Integer) delivery_date = db.Column(db.Integer) delivery_time = db.Column(db.Integer)
class User(db.Model): __tablename__ = 'weshop_user' id = db.Column(db.Integer, primary_key=True, autoincrement=True) role = db.Column(db.Integer) openid = db.Column(db.String(64), unique=True) username = db.Column(db.String(64), unique=True, index=True) headimgurl = db.Column(db.String(128)) city = db.Column(db.String(32)) sex = db.Column(db.Integer) def __init__(self, **kwargs): super().__init__(**kwargs)
class Address(db.Model): __tablename__ = 'weshop_user_address' id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(64)) phone = db.Column(db.String(16)) address = db.Column(db.String(128))
class Goods(db.Model): __tablename__ = 'weshop_goods' id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(64), unique=True) image_url = db.Column(db.String(128)) category = db.Column(db.String(64), unique=True)
class Address(db.Model): __tablename__ = 'weshop_user_addr' id = db.Column(db.Integer, primary_key=True) address = db.Column(db.String(128))
class Order(db.Model): __tablename__ = 'weshop_order' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('weshop_user.id')) address = db.Column(db.Integer, db.ForeignKey('weshop_user_addr.id')) datetime = db.Column(db.DateTime)
class Goods(db.Model): __tablename__ = 'weshop_goods' id = db.Column(db.Integer, primary_key=True)