class Portfolio(Model):
__table__ = 'portfolio'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
user_id = IntegerField()
name = StringField(ddl='varchar(30)', default="")
read_num = IntegerField(default=0)
init_assets = IntegerField(default=1000000)
allocations = StringField(ddl='blob', default="")
allocations_history = StringField(ddl='blob', default="")
entire_history = FloatField(default=0.0)
pre_roi = FloatField(default=1000000)
pre_date = StringField(ddl='varchar(20)', default="")
hour_24_history = FloatField(default=0.0)
max_history = FloatField(default=0.0)
day_7_history = FloatField(default=0.0)
day_30_history = FloatField(default=0.0)
day_60_history = StringField(ddl='varchar(20)', default="0.0%")
day_90_history = StringField(ddl='varchar(20)', default="0.0%")
day_182_history = StringField(ddl='varchar(20)', default="0.0%")
day_365_history = StringField(ddl='varchar(20)', default="0.0%")
max_drawdown = StringField(ddl='varchar(20)', default="")
day_7_drawdown = StringField(ddl='varchar(20)', default="")
day_7_volatility = StringField(ddl='varchar(20)', default="")
volatility = StringField(ddl='varchar(20)', default="")
data_num = IntegerField(default=0)
modify_at = FloatField(default=time.time)
created_at = FloatField(default=time.time)
class IPSamplingAllot(Model):
__table__ = 'ipSamplingAllot'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
owner = StringField(ddl='varchar(32)', updatable=False)
allotNum = IntegerField(default=0, ddl='int(11)')
accuracy = FloatField(ddl='float(5,4)')
createAt = FloatField(updatable=False, default=time.time)
updateAt = FloatField(default=time.time)
class RMS(Model):
__table__ = 'rms'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
name = StringField(ddl='varchar(256)')
uid = StringField(ddl='varchar(32)')
mobile = StringField(ddl='varchar(32)')
stillwork = IntegerField(default=0, ddl='int(4)')
crm = StringField(ddl='varchar(256)')
class IPBlacklistVote(Model):
__table__ = 'ipBlacklistVote'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
ipId = IntegerField(default=0, ddl='int(11)')
voterId = StringField(ddl='varchar(32)', updatable=False)
voterName = StringField(ddl='varchar(128)')
result = IntegerField(default=0, ddl='tinyint(5)')
reason = StringField(ddl='varchar(1024)')
createAt = FloatField(updatable=False, default=time.time())
updateAt = FloatField(default=time.time())
class IPSamplingVerify(Model):
__table__ = 'ipSamplingVerify'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
samplingAllotId = IntegerField(default=0, ddl='int(11)')
verifyPerson = StringField(ddl='varchar(32)', updatable=False)
verifyType = IntegerField(default=0,
updatable=False,
nullable=True,
ddl='tinyint(5)')
objectId = StringField(ddl='varchar(32)', updatable=False)
verifyResult = IntegerField(default=0, nullable=True, ddl='tinyint(5)')
createAt = FloatField(updatable=False, default=time.time)
updateAt = FloatField(default=time.time)
class IPVerify(Model):
__table__ = 'ipVerify'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
objectId = StringField(ddl='varchar(32)', updatable=False)
ipAllotId = IntegerField(default=0, updatable=False, ddl='int(11)')
verifyType = IntegerField(default=0,
updatable=False,
nullable=True,
ddl='tinyint(5)')
adminId = StringField(ddl='varchar(32)', updatable=False)
username = StringField(ddl='varchar(256)', updatable=False)
verifyResult = IntegerField(default=0, nullable=True, ddl='tinyint(2)')
createAt = FloatField(updatable=False, default=time.time)
updateAt = FloatField(default=time.time)
class User(Model):
__table__ = 'user'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
username = StringField(ddl='text')
person_nickname = StringField(ddl='text')
mobilePhoneNumber = StringField(ddl='varchar(64)')
class IpPoolAdmin(Model):
__table__ = 'ipPoolAdmin'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
uid = StringField(ddl='varchar(32)', updatable=False)
accuracy = FloatField(default=0, ddl='float(5,4)')
createAt = FloatField(default=time.time)
updateAt = FloatField(default=time.time)
class User(Model):
__table__ = 'user'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
user_id = IntegerField()
name = StringField(ddl='varchar(30)')
nickname = StringField(ddl='varchar(30)', default="")
head_image_url = StringField(ddl='varchar(30)', default="")
option_one = StringField(ddl='varchar(20)', default="")
option_two = StringField(ddl='varchar(20)', default="")
option_three = StringField(ddl='varchar(20)', default="")
score = IntegerField(default=0)
ratio = FloatField(default=0.0)
state = IntegerField(default=0)
created_at = FloatField(default=time.time)
class FolioPerformance(Model):
__table__ = 'folio_performance'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
folio_id = StringField(ddl='varchar(50)')
user_id = StringField(ddl='varchar(50)')
performance_data = StringField(ddl='blob', default="")
state = IntegerField(default=0)
modify_at = FloatField(default=time.time)
created_at = FloatField(default=time.time)
class NewWriterVerifyRecord(Model):
__table__ = 'newWriterVerifyRecord'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
uid = StringField(ddl='varchar(32)', updatable=False)
newWriterId = IntegerField(ddl='int(11)', updatable=False)
story = IntegerField(default=0, ddl='int(5)')
structure = IntegerField(default=0, ddl='int(5)')
character = IntegerField(default=0, ddl='int(5)')
market = IntegerField(default=0, ddl='int(5)')
status = IntegerField(default=0, nullable=True, ddl='tinyint(2)')
createAt = FloatField(updatable=False, default=time.time)
updateAt = FloatField(default=time.time)
class IPPool(Model):
__table__ = 'ipPools'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
objectId = StringField(ddl='varchar(32)', updatable=False)
ippreId = StringField(ddl='varchar(32)', updatable=False)
verifyType = IntegerField(default=0, nullable=True, ddl='tinyint(5)')
authorId = StringField(updatable=False, ddl='varchar(32)')
author = StringField(updatable=False, ddl='varchar(256)')
status = IntegerField(default=0, nullable=True, ddl='tinyint(2)')
createAt = FloatField(updatable=False, default=time.time)
updateAt = FloatField(default=time.time)
title = StringField(updatable=False, ddl='varchar(256)')
workType = StringField(updatable=False, ddl='varchar(256)')
cat = StringField(updatable=False, ddl='varchar(256)')
hasOutline = IntegerField(default=0, ddl='tinyint(1)')
firstOldStatus = IntegerField(default=0, nullable=True, ddl='tinyint(2)')
secondOldStatus = IntegerField(default=0, nullable=True, ddl='tinyint(2)')
thirdOldStatus = IntegerField(default=0, nullable=True, ddl='tinyint(2)')
class IPBlacklist(Model):
__table__ = 'ipBlacklist'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
objectId = StringField(ddl='varchar(32)')
packagerId = StringField(ddl='varchar(32)')
operatorId = StringField(ddl='varchar(32)')
batch = IntegerField(default=0, ddl='int(10)')
title = StringField(ddl='varchar(256)')
voteTurnout = FloatField(ddl='float(5,4)')
status = IntegerField(default=0, ddl='tinyint(10)')
voteEnd = IntegerField(default=0, ddl='tinyint(1)')
isShortcut = IntegerField(default=0, ddl='tinyint(1)')
uptime = IntegerField(default=0, ddl='int(11)')
blacklistUpdateAt = FloatField(default=time.time())
createAt = FloatField(updatable=False, default=time.time())
updateAt = FloatField(default=time.time())
class NewWriterPool(Model):
__table__ = 'newWriterPool'
id = IntegerField(primary_key=True, default=0, ddl='int(11)')
ippreId = StringField(ddl='varchar(32)', updatable=False)
uid = StringField(ddl='varchar(32)', updatable=False)
type = IntegerField(default=0, updatable=True, ddl='tinyint(5)')
phone = StringField(ddl='varchar(32)', updatable=False)
verifyAdmin = StringField(ddl='text')
status = IntegerField(default=0, nullable=True, ddl='tinyint(2)')
oldStatus = IntegerField(default=0, nullable=True, ddl='tinyint(2)')
result = IntegerField(default=0.00, nullable=True, ddl='float(5,2)')
finalState = IntegerField(default=0,
updatable=False,
nullable=True,
ddl='tinyint(5)')
createAt = FloatField(updatable=False, default=time.time)
updateAt = FloatField(default=time.time)
class IPStatis(Model):
__table__ = 'ipStatis'
ipId = IntegerField(primary_key=True, default=0, ddl='int(11)')
createAt = FloatField(updatable=False, default=time.time)
updateAt = FloatField(default=time.time)