class Batch(Model): __table__ = "batch" __primary_key__ = "id" # 批次编号 id = IntegerField('id', False) # 商品时间 prodtime = StringField('prodtime', True) # 生产公司id pc_id = IntegerField('pc_id', True) # 商品名 p_name = StringField('p_name', True) # 原料商品批次id组合 mat_list = StringField('mat_list', True) # 过期时间 exptime = StringField('exptime', True) # 该批商品简介 intro = StringField('intro', True) # 订单ID man_id = IntegerField('man_id', True) # 物流id log_id = IntegerField('log_id', True) # 批次含量 amount = IntegerField('amount', True) # 商品图片 pro_img = StringField('pro_img', True) # 二维码图片 qr_img = StringField('qr_img', True) # 条形码图片 br_img = StringField('br_img', True) # 批次产生时间 time = StringField('time', True)
class User(Model): __table__ = 'user' __primary_key__ = 'id' id = IntegerField('id', False) name = StringField('name', True) account = StringField('account', True) password = StringField('password', True) dpassword = StringField('dpassword', True) nick = StringField('nick', True) exp = IntegerField('exp', True) gold = IntegerField('gold', True) money = IntegerField('money', True) headimg = StringField('headimg', True) phone = StringField('phone', True) records = StringField('records', True) assets = StringField('assets', True) room = StringField('room', True) invitetime = StringField('invitetime', True) vcode = StringField('vcode', True) sfz = StringField('sfz', True) realname = StringField('realname', True) luckytime = StringField('luckytime', True) welfaretime = StringField('welfaretime', True) gender = IntegerField('gender', True) rankaward = StringField('rankaward', True) logintime = StringField('logintime', True) gamestate = IntegerField('gamestate', True) totalmoney = IntegerField('totalmoney', True) totalrmb = IntegerField('totalrmb', True) sharetime = StringField('sharetime', True) wincount = IntegerField('wincount', True) totalcount = IntegerField('totalcount', True) mails = StringField('mails', True) actawards = StringField('actawards', True)
class DownloadRecord(Models): table_name = 'download_record' # 字段 id = IntegerField(name='id', primary_key=True) user_id = IntegerField(name='user_id') movie_id = IntegerField(name='movie_id') download_time = StringField(name='download_time')
class Officer(Model): __table__ = 'officer' __primary_key__ = 'id' id = IntegerField('id', True) name = StringField('name', True) title = IntegerField('title', True)
class Suggest(Model): __table__='suggest' __primary_key__='id' id=IntegerField('id',False) detail=StringField('detail',True) phone=StringField('phone',True) time=IntegerField('time',True)
class Operate(Model): __table__ = 'operate' __primary_key__ = 'id' id = IntegerField('id', True) #操作id aid = IntegerField('aid', True) #谁操作的 operate = StringField('operate', True) # 操作类型 time = StringField('time', True) #时间
class Notice(Models): table_name = 'notice' # 字段 id = IntegerField(name='id', primary_key=True) title = StringField(name='title') content = StringField(name='content') user_id = IntegerField(name='user_id') create_time = StringField(name='create_time')
class Record(Model): __table__ = 'record' __primary_key__ = 'id' id = IntegerField('id', False) time = IntegerField('time', True) gameplay = StringField('gameplay', True) gamers = StringField('gamers', True)
class Fj(Model): __table__ = 'fj' __primary_key__ = 'id' id = IntegerField('id', False) fjpath = IntegerField('fjpath', True) eqid = IntegerField('eqid', True) fjname = StringField('fjname', True)
class Mail(Model): __table__='mail' __primary_key__='id' id = IntegerField('id',False) #邮件id uid = IntegerField('uid',True)#谁的邮件 type = IntegerField('type',True) # 邮件类型 content = StringField('content',True) # 邮件内容 time=StringField('time',True)#时间
class ActApply(Model): __table__ = 'actapply' __primary_key__ = 'id' id=IntegerField('id',False) applyer = IntegerField('applyer',True) reason = StringField('reason',True) optype= IntegerField('optype',True) state = IntegerField('state',True) actid = IntegerField('actid',True)
class Activity(Model): __table__ = 'activity' __primary_key__ = 'id' id = IntegerField('id', False) title = StringField('title', True) detail = StringField('detail', True) icon = StringField('icon', True) url = StringField('url', True) time = IntegerField('time', True)
class Admin(Model): __table__ = 'Admin' __primary_key__ = 'id' id = IntegerField("id", True) nickname = StringField("nickname", True) userName = StringField("userName", True) passWord = StringField("passWord", True) token = StringField("token", True) admin = IntegerField("admin", True) type = StringField("type", True)
class OrgApply(Model): __table__ = 'orgapply' __primary_key__ = 'id' id=IntegerField('id',False) applyer = IntegerField('applyer',True) reason = StringField('reason',True) title = StringField('title',True) optype= IntegerField('optype',True) state = IntegerField('state',True) orgid = IntegerField('orgid',True)
class User(Models): # 表名 table_name = 'user' # 字段 id = IntegerField(name='id', primary_key=True) name = StringField(name='name') # pwd, is_vip, is_locked, user_type, register_time pwd = StringField(name='pwd') is_vip = IntegerField(name='is_vip') is_locked = IntegerField(name='is_locked') user_type = StringField(name='user_type') register_time = StringField(name='register_time')
class Movie(Models): # 表名 table_name = 'movie' # 字段 id = IntegerField(name='id', primary_key=True) name = StringField(name='name') # path, is_free, file_md5, user_id, is_delete, upload_time path = StringField(name='path') is_free = IntegerField(name='is_free') # 1 0 file_md5 = StringField(name='file_md5') user_id = IntegerField(name='user_id') is_delete = IntegerField(name='is_delete') upload_time = StringField(name='upload_time')
class Company(Model): __table__ = "company" __primary_key__ = "id" # 公司编号 id = IntegerField('id', False) # 密码 password = StringField('password', True) # 公司地址 name = StringField('name', True) # 公司地址 address = StringField('address', True) # 公司简介 profile = StringField('profile', True) # 营业执照图片路径 blPath = StringField('blPath', True) # 生产许可证图片路径 pcPath = StringField('pcPath', True) # 安全认证图片路径 scPath = StringField('scPath', True) # 联系方式 tel = StringField('tel', True) # 注册时间 rTime = StringField('rTime', True) # 公司类型 type =StringField('type',True)
class Delegate(Model): __table__ = 'delegate' __primary_key__ = 'id' id = IntegerField('id', True) #代理id,就是玩家的id logintime = StringField('logintime', True) # 登录时间 awards = IntegerField('awards', True) shareaward = IntegerField('shareaward', True) # 分享奖励 newaward = IntegerField('newaward', True) # 新人奖励 levelaward = IntegerField('levelaward', True) # 分级活动奖励 actaward = IntegerField('actaward', True) # 活动奖励 level = IntegerField('level', True) # 代理权限 0 表示普通玩家 1,2,3分别代表1,2,3级代理 slevel = IntegerField('slevel', True) # 原始代理级别(初创代理的时候) parent = IntegerField('parent', True) # 推荐上级代理id parentslevel = IntegerField('parentslevel', True) # 推荐上级代理原始级别 children = StringField('children', True) # 下级代理 icode = StringField('icode', True) #邀请码
class User(Model): __table__ = 'users' id = IntegerField(primary_key=True) email = StringField(ddl='varchar(50)') passwd = StringField(ddl='varchar(50)') admin = BooleanField() name = StringField(ddl='varchar(50)') image = StringField(ddl='varchar(500)')
class Act(Model): __table__ = 'act' __primary_key__ = 'id' id = IntegerField('id', False) #通过 . 点方法可以查看属性 id.[name] name = StringField('name', True) begintime = StringField('begintime', True) endtime = StringField('endtime', True) type = IntegerField('type', True) ownertype = IntegerField('ownertype', True) applylist = StringField('applylist', True) area = StringField('area', True) level = IntegerField('level', True) summary = StringField('summary', True) memlist = StringField('memlist', True) max = IntegerField('max', True) photo = StringField('photo', True)
class BoardCast(Model): __table__ = 'boardcast' __primary_key__ = 'id' id = IntegerField('id', False) title = StringField('title', True) detail = StringField('detail', True) icon = StringField('icon', True) url = StringField('url', True) time = StringField('time', True)
class Gly(Model): __table__ = 'gly ' __primary_key__ = 'id' id = IntegerField('id', False) DLM = StringField('DLM', True) MM = StringField('MM', True) XM = StringField('XM', True) DH = StringField('DH', True) YX = StringField('YX', True)
class User(Model): __table__ = "user" __primary_key__ = "id" #用户编号 id = IntegerField('id', False) #用户名 name = StringField('name', True) #密码 password = StringField('password', True) #联系方式 tel = StringField('tel', True) #注册时间 registerTime = StringField('registerTime', True)
class CreateOrg(Model): __table__ = 'createorg' __primary_key__ = 'id' id=IntegerField('id',False) applyer = IntegerField('applyer',True) name = StringField('name',True) max = IntegerField('max',True) starttime = StringField('starttime',True) level = IntegerField('level',True) summary = StringField('summary',True) type = IntegerField('type',True) ownertype = IntegerField('ownertype',True) state = IntegerField('state',True)
class Recharge(Model): __table__='recharge' __primary_key__='id' id=IntegerField('id',False) time=IntegerField('time',True) money=IntegerField('money',True) uid=IntegerField('uid',True) good=StringField('good',True) count=IntegerField('count',True) fromc=IntegerField('fromc',True)
class Org(Model): __table__ = 'org' __primary_key__ = 'id' id = IntegerField('id', False) name = IntegerField('name', True) type = IntegerField('type', True) owntype = IntegerField('owntype', True) summary = StringField('summary', True) memlist = StringField('memlist', True) applylist = StringField('applylist', True) starttime = StringField('starttime', True) level = IntegerField('level', True) max = IntegerField('max', True) photo = IntegerField('photo', True)
class Manifest(Model): __table__ = "manifest" __primary_key__ = "id" # 订单识别码 id = IntegerField('id', False) # 采购商品名 prod_name = StringField('prod_name', True) # 采购员id originatorId = StringField('originatorId', True) # 采购量 amount = FloatField('amount', True) # 采购时间 time = StringField('time', True) # 采购地点 place = StringField('place', True) # 订单状态 confirm = StringField('confirm', True)
class Earthquake(Model): __table__ = 'earthquake ' __primary_key__ = 'id' id = IntegerField('id', False) eqname = StringField('eqname', True) longitude = StringField('longitude', True) latitude = StringField('latitude', True) level = StringField('level', True) leveltype = StringField('leveltype', True) date = IntegerField('date', False) depth = StringField('depth', False) introduction = StringField('introduction', True) Year = IntegerField('Year', True) Month = IntegerField('Month', True) Day = IntegerField('Day', True) hour = IntegerField('hour', True) minute = IntegerField('minute', True) second = IntegerField('second', True)
class Staff(Model): __table__ = "staff" __primary_key__ = "id" # 职员编号 id = IntegerField('id', False) # 职员名 name = StringField('name', True) # 联系方式 tel = StringField('tel', True) # 工作类型 type = StringField('type', True) #照片地址 photoPath = StringField('photoPath', True) # 公司编号 companyId = StringField('companyId', True) # 入职时间 entryTime = StringField('entryTime', True) # 离职时间 leaveTime = StringField('leaveTime', True)
class Logistics(Model): __table__ = "logistics" __primary_key__ = "id" # 物流编号 id = IntegerField('id', False) # 司机Id driverId = StringField('driverId', True) # 车牌号 plateNum = StringField('plateNum', True) # 出发公司 startPlace = StringField('startPlace', True) # 目的公司 endPlace = StringField('endPlace', True) # 该条物流产生时间 time = StringField('time', True) # 物流状态 comfirm = StringField('comfirm', True) # 运输批次号 amount = StringField('amount', True)