class User(db.Model): __tablename__ = 'user' Host = db.Column(db.String(60, 'utf8_bin'), primary_key=True, nullable=False, server_default=db.FetchedValue()) User = db.Column(db.String(32, 'utf8_bin'), primary_key=True, nullable=False, server_default=db.FetchedValue()) ssl_cipher = db.Column(db.LargeBinary, nullable=False) x509_issuer = db.Column(db.LargeBinary, nullable=False) x509_subject = db.Column(db.LargeBinary, nullable=False) max_questions = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) max_updates = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) max_connections = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) max_user_connections = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) plugin = db.Column(db.String(64, 'utf8_bin'), nullable=False, server_default=db.FetchedValue()) authentication_string = db.Column(db.Text(collation='utf8_bin')) password_last_changed = db.Column(db.DateTime) password_lifetime = db.Column(db.SmallInteger)
class FoodStockChangeLog(db.Model): __tablename__ = 'food_stock_change_log' id = db.Column(db.Integer, primary_key=True) food_id = db.Column(db.Integer, nullable=False, index=True) unit = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) total_stock = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) note = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
class BookCat(db.Model): __tablename__ = 'book_cat' id = db.Column(db.Integer, primary_key=True, unique=True) name = db.Column(db.String(32), nullable=False) weight = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
class JzkAdvertising(db.Model): __tablename__ = 'jzk_advertising' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255)) content = db.Column(db.String(500)) link = db.Column(db.String(500)) time = db.Column(db.DateTime, server_default=db.FetchedValue())
class StockList(db.Model): __tablename__ = 'stock_list' id = db.Column(db.BigInteger, primary_key=True, info='id') symbol = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue(), info='symbol')
class QqGroup(db.Model): __tablename__ = 'qq_group' id = db.Column(db.BigInteger, primary_key=True) group_name = db.Column(db.String(100), nullable=False, unique=True, server_default=db.FetchedValue()) group_number = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
class FoodCat(db.Model): __tablename__ = 'food_cat' id = db.Column(db.Integer, primary_key=True, unique=True) name = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue(), info='类别名称') weight = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='权重') status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='状态 1:有效 0:无效') updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='最后一次更新时间') created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='插入时间') @property def status_desc(self): status_mapping = { '0': '已删除', '1': '正常' } return status_mapping[str(self.status)]
class Account(db.Model): __tablename__ = 'account' id = db.Column(db.Integer, primary_key=True) userName = db.Column(db.String(50), nullable=False) password = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) createTime = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) remarks = db.Column(db.String(50)) def __init__(self, **items): for key in items: if hasattr(self, key): setattr(self, key, items[key])
class Shop(db.Model): __tablename__ = 'shop' Shopid = db.Column(db.BigInteger, primary_key=True) # 商店ID Aid = db.Column(db.BigInteger, nullable=False, server_default=db.FetchedValue()) # 商户ID ShopName = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 商户名称 ShopImage = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 商户图片 ShopCategory = db.Column(db.BigInteger, nullable=False, server_default=db.FetchedValue()) # 店铺分类 ShopProvince = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 省 ShopCity = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 市 ShopCountry = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 地区
class OauthMemberBind(db.Model): __tablename__ = 'oauth_member_bind' __table_args__ = (db.Index('idx_type_openid', 'type', 'openid'), ) id = db.Column(db.Integer, primary_key=True) member_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='会员id') client_type = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue(), info='客户端来源类型。qq,weibo,weixin') type = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='类型 type 1:wechat ') openid = db.Column(db.String(80), nullable=False, server_default=db.FetchedValue(), info='第三方id') unionid = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) extra = db.Column(db.Text, nullable=False, info='额外字段') updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='最后更新时间') created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='插入时间')
class Product(db.Model): __tablename__ = 'product_info' Id = db.Column(db.BigInteger, primary_key=True) # id号码 ProductName = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 商品名称 ShopId = db.Column(db.BigInteger, primary_key=True) # 商品店主ID ProductMerchanName = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue()) # 商品店主名字 ProductCategory = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue()) # 商品分类 ProductInfo = db.Column(db.String(5000), nullable=False, server_default=db.FetchedValue()) # 商品信息 ProdectPrice = db.Column(DECIMAL, nullable=False, server_default=db.FetchedValue()) # 商品价格 ProductImage = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 商品图片 ProductStock = db.Column(Integer, nullable=False, unique=True, server_default=db.FetchedValue()) # 商品库存 ProductSold = db.Column(Integer, nullable=False, server_default=db.FetchedValue()) # 商品已售数 ProductStatus = db.Column(Integer, nullable=False, server_default=db.FetchedValue()) # 商品状态 1为已过审
class UserBuyHistory(db.Model): __tablename__ = 'user_buy_history' id = db.Column(db.Integer, primary_key=True) openid = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) nickname = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) cat_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) product = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) price = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue()) buy_count = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
class AllAddres(db.Model): __tablename__ = 'all_address' id = db.Column(db.Integer, primary_key=True) school_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) school_str = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) grade_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) grade_str = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) class_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) class_str = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) status = db.Column(db.Integer, nullable=False, index=True, server_default=db.FetchedValue())
class Work(db.Model): __tablename__ = 'works' id = db.Column(db.BigInteger, primary_key=True, info='??id') nickname = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue(), info='???') uid = db.Column(db.String(11), nullable=False, server_default=db.FetchedValue(), info='????id') worksOK = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='???? 0???? 1????2?????? 3??????') photo_imageurl = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue(), info='???????') transfer_photo_imageurl = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue(), info='?????????') style = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue(), info='??') tag = db.Column(db.Text, info='????') time = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue(), info='??????') status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='?? 1????? 0??????') updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='????????') created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='????')
class MemberCart(db.Model): __tablename__ = 'member_cart' id = db.Column(db.Integer, primary_key=True) member_id = db.Column(db.BigInteger, nullable=False, index=True, server_default=db.FetchedValue()) course_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) register_status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) payment_status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) quantity = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) @property def payment_status_desc(self): payment_status_mapping = {"0": '未付', '1': '已付'} return payment_status_mapping[str(self.payment_status)]
class User(db.Model): __tablename__ = 'user' id = db.Column(db.Integer, primary_key=True, info='??') nickname = db.Column(db.String(30), nullable=False, server_default=db.FetchedValue(), info='??') login_name = db.Column(db.String(20), nullable=False, unique=True, server_default=db.FetchedValue(), info='?????') login_pwd = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='??????') login_salt = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='?????????') status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='?? 0??? 1???') updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='????????') created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='????')
class Commodity(db.Model): __tablename__ = 'commodity' id = db.Column(db.Integer, primary_key=True, info='主键-商品id') name = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='商品名称') origin = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='商品产地') seller = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='卖家') trans = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='运输') warehouse = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='仓库') buyer = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='买家') status = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='商品状态')
class Sysconfig(db.Model): __tablename__ = 'sysconfig' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20, 'utf8mb4_general_ci'), nullable=False, server_default=db.FetchedValue(), info='配置描述') tip = db.Column(db.String(100, 'utf8mb4_general_ci'), nullable=False, server_default=db.FetchedValue()) k_field = db.Column(db.String(20, 'utf8mb4_general_ci'), nullable=False, server_default=db.FetchedValue(), info='配置名称key') k_val = db.Column(db.String(500, 'utf8mb4_general_ci'), nullable=False, server_default=db.FetchedValue(), info='配置对应的值') status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='状态 1:有效 0:无效') updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='最后一次更新时间') created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='插入时间') def __init__(self, **items): for key in items: if hasattr(self, key): setattr(self, key, items[key])
class AppAccessLog(db.Model): __tablename__ = 'app_access_log' id = db.Column(db.Integer, primary_key=True) uid = db.Column(db.BigInteger, nullable=False, index=True, server_default=db.FetchedValue(), info='uid') referer_url = db.Column(db.String(255), nullable=False, server_default=db.FetchedValue(), info='当前访问的refer') target_url = db.Column(db.String(255), nullable=False, server_default=db.FetchedValue(), info='访问的url') query_params = db.Column(db.Text, nullable=False, info='get和post参数') ua = db.Column(db.String(255), nullable=False, server_default=db.FetchedValue(), info='访问ua') ip = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='访问ip') note = db.Column(db.String(1000), nullable=False, server_default=db.FetchedValue(), info='json格式备注字段') created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
class OauthMemberBind(db.Model): __tablename__ = 'oauth_member_bind' __table_args__ = (db.Index('idx_type_openid', 'type', 'openid'), ) id = db.Column(db.Integer, primary_key=True) member_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) client_type = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue()) type = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) openid = db.Column(db.String(80), nullable=False, server_default=db.FetchedValue()) unionid = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) extra = db.Column(db.Text, nullable=False) updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
class Address(db.Model): __tablename__ = 'address' Id = db.Column(db.BigInteger, primary_key=True) # ID号码 Cid = db.Column(db.BigInteger, nullable=False, server_default=db.FetchedValue()) # 顾客ID Addressee = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 收件人姓名 AddresseePhone = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 收件人电话 Province = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 省份 City = db.Column(db.String(20), primary_key=True) # 市区 County = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue()) # 县 Details = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue()) # 地址详细 Status = db.Column(Integer, nullable=False, server_default=db.FetchedValue()) # 是否为默认地址 1位默认
class AppAccessLog(db.Model): # db.create_all() __tablename__ = 'app_access_log' id = db.Column(db.Integer, primary_key=True) uid = db.Column(db.BigInteger, nullable=False, index=True, server_default=db.FetchedValue()) referer_url = db.Column(db.String(255), nullable=False, server_default=db.FetchedValue()) target_url = db.Column(db.String(255), nullable=False, server_default=db.FetchedValue()) query_params = db.Column(db.Text, nullable=False) ua = db.Column(db.String(255), nullable=False, server_default=db.FetchedValue()) ip = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue()) note = db.Column(db.String(1000), nullable=False, server_default=db.FetchedValue()) created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
class StatDailySite(db.Model): __tablename__ = 'stat_daily_site' id = db.Column(db.Integer, primary_key=True) date = db.Column(db.Date, nullable=False, index=True) total_pay_money = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue()) total_member_count = db.Column(db.Integer, nullable=False) total_new_member_count = db.Column(db.Integer, nullable=False) total_order_count = db.Column(db.Integer, nullable=False) total_shared_count = db.Column(db.Integer, nullable=False) updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
class FoodCat(db.Model): __tablename__ = 'food_cat' id = db.Column(db.Integer, primary_key=True, unique=True) name = db.Column(db.String(50), nullable=False, server_default=db.FetchedValue()) weight = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) @property def status_desc(self): status_map = {"0": "已删除", "1": "正常"} return status_map[str(self.status)]
class FoodSaleChangeLog(db.Model): __tablename__ = 'food_sale_change_log' id = db.Column(db.Integer, primary_key=True) food_id = db.Column(db.Integer, nullable=False, index=True, server_default=db.FetchedValue()) quantity = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) price = db.Column(db.Numeric(10, 2), nullable=False) member_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
class UserInfo(db.Model): __tablename__ = 'user_info' __table_args__ = ( db.Index('USER_STOCK_DATE', 'user_id', 'hold_stock', 'buy_date'), ) id = db.Column(db.BigInteger, primary_key=True, info='id') hold_stock = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue(), info='持有股票代码') name = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue(), info='股票名称') user_id = db.Column(db.ForeignKey('user.uid'), nullable=False, server_default=db.FetchedValue(), info='用户id fk') buy_price = db.Column(db.Float, nullable=False, server_default=db.FetchedValue(), info='卖出价格') sold_price = db.Column(db.Float, info='卖出价格') sale_point = db.Column(db.Float, info='卖点') strategy = db.Column(db.String(2000), info='当前交易策略') buy_date = db.Column(db.String(20), info='买入日期') hold_time = db.Column(db.Float, info='卖出日期') user = db.relationship('User', primaryjoin='UserInfo.user_id == User.uid', backref='user_infos')
class AppErrorLog(db.Model): __tablename__ = 'app_error_log' id = db.Column(db.Integer, primary_key=True) referer_url = db.Column(db.String(255), nullable=False, server_default=db.FetchedValue(), info='当前访问的refer') target_url = db.Column(db.String(255), nullable=False, server_default=db.FetchedValue(), info='访问的url') query_params = db.Column(db.Text, nullable=False, info='get和post参数') content = db.Column(db.String, nullable=False, info='日志内容') created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='插入时间')
class Member(db.Model): __tablename__ = 'member' id = db.Column(db.Integer, primary_key=True) nickname = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue(), info='会员名') mobile = db.Column(db.String(11), nullable=False, server_default=db.FetchedValue(), info='会员手机号码') sex = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='性别 1:男 2:女') avatar = db.Column(db.String(200), nullable=False, server_default=db.FetchedValue(), info='会员头像') salt = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='随机salt') reg_ip = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue(), info='注册ip') status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='状态 1:有效 0:无效') updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='最后一次更新时间') created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='插入时间') @property def status_desc(self): return app.config['STATUS_MAPPING'][str(self.status)] @property def sex_desc(self): SEX_MAPPING = {'0': '未知', '1': '男', '2': '女'} return SEX_MAPPING[str(self.sex)]
class Member(db.Model): __tablename__ = 'member' id = db.Column(db.Integer, primary_key=True) nickname = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue(), info='???') mobile = db.Column(db.String(11), nullable=False, server_default=db.FetchedValue(), info='??????') sex = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='?? 1?? 2??') avatar = db.Column(db.String(200), nullable=False, server_default=db.FetchedValue(), info='????') salt = db.Column(db.String(32), nullable=False, server_default=db.FetchedValue(), info='??salt') reg_ip = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue(), info='??ip') status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='?? 1??? 0???') updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='????????') created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='????') @property def status_desc(self): return app.config["STATUS_MAPPING"][str(self.status)] @property def sex_desc(self): sex_mapping = {"0": "未知", "1": "男", "2": "女"} return sex_mapping[str(self.sex)]
class News(db.Model): __tablename__ = 'news' id = db.Column(db.Integer, primary_key=True) created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue()) title = db.Column(db.String(30), nullable=False, server_default=db.FetchedValue()) content = db.Column(db.String(280), nullable=False, server_default=db.FetchedValue()) status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue()) location = db.Column(db.String(20), nullable=False, server_default=db.FetchedValue())