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)
