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 Suggest(Model): __table__='suggest' __primary_key__='id' id=IntegerField('id',False) detail=StringField('detail',True) phone=StringField('phone',True) time=IntegerField('time',True)
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Officer(Model): __table__ = 'officer' __primary_key__ = 'id' id = IntegerField('id', True) name = StringField('name', True) title = IntegerField('title', 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 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 Conversation(Model): cid = IntPrimaryField() id = IntField(required=True) name = StringField(required=False) last_ts = IntField(required=True) class Meta: table_name = 'conversations'
class Notification(Model): rid = IntPrimaryField() type = StringField(required=True) whom = IntField(required=True) ts = IntField(required=True) class Meta: table_name = 'notifications'
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 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 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 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 User(Model): __table__ = 'user' __primary_key__ = 'id' id=IntegerField('id',True) sname = StringField('sname',True) fun_list = StringField('fun_list',True) create_org_list = StringField('create_org_list',True) create_act_list = IntegerField('create_act_list',True) join_act_list = IntegerField('join_act_list',True) join_org_list = StringField('join_org_list',True) befun_list = StringField('befun_list',True) sex = IntegerField('sex',True) grade = IntegerField('grade',True) college = IntegerField('college',True) apply_org_list = StringField('apply_org_list',True) apply_act_list = StringField('apply_act_list',True) apply_create_org_list = StringField('apply_create_org_list',True) apply_create_act_list = StringField('apply_create_act_list',True) # photo = IntegerField('photo',True) photo = StringField('photo',True)
class Warehouse(Model): __table__ = "warehouse" __primary_key__ = "id" # 库存编号 id = IntegerField('id', False) # 商品名 p_name = StringField('p_name', True) # 批次ID p_id = IntegerField('p_id', True) # 入库时间 inTime = StringField('inTime', True) # 仓库时间 outTime = StringField('outTime', True) # 仓库ID w_id = IntegerField('w_id', True) # 入库公司ID in_c_id = IntegerField('in_c_id', True) # 批次ID out_c_id = IntegerField('p_id', True) # 存量 stock = IntegerField('stock', True)
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)