class User(Model):
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
email = StringField(updatable=False, ddl='varchar(50)')
password = StringField(ddl='varchar(50)')
admin = BooleanField()
name = StringField(ddl='varchar(50)')
created_at = FloatField(updatable=False,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 ReferenceData(Model):
__table__ = 'reference_data'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
code = StringField(ddl='varchar(20)')
data = StringField(ddl='blob', default="")
created_at = FloatField(default=time.time)
class FactorModel(Model):
__table__ = 'factor_model'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
code = StringField(ddl='varchar(20)')
factors = StringField(ddl='blob', default="")
created_at = 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 RiskFactor(Model):
__table__ = 'risk_factor'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
coin_id = StringField(ddl='varchar(50)')
ticker = StringField(ddl='varchar(20)')
name = StringField(ddl='varchar(20)')
created_at = FloatField(default=time.time)
class Comments(Model):
__table__ = 'comments'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
blog_id = StringField(updatable=False, ddl='varchar(50)')
user_id = StringField(updatable=False, ddl='varchar(50)')
user_name = StringField(ddl='varchar(50)')
user_image = StringField(ddl='varchar(500)')
content = TextField()
created_at = FloatField(updatable=False, default=time.time)
class PerformanceHour(Model):
__table__ = 'performance_hour'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
coin_id = StringField(ddl='varchar(50)')
close_value = FloatField()
net_return = FloatField()
effective_date = FloatField(default=time.time)
created_at = FloatField(default=time.time)
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 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 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 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 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 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 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 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 RegimeModel(Model):
"""
{
"factorCode": "BANCA",
"ngegimes": 5.0,
"modelName": "BIG date",
"history": [
{
"Regime": "Regime 3",
"Date": 1493510400.0
}
]
}
"""
__table__ = 'regime_model'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
factor_code = StringField(ddl='varchar(20)')
model_name = StringField(ddl='varchar(20)')
ngegimes = FloatField(default=1.0)
history = StringField(ddl='blob', default="")
created_at = 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 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 Blog(Model):
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
name = StringField(ddl='varchar(50)')
content = TextField()
created_at = FloatField(updatable=False, default=time.time)
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 Coin(Model):
__table__ = 'coin'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
name = StringField(ddl='varchar(50)')
simple_name = StringField(ddl='varchar(20)')
website_slug = StringField(ddl='varchar(50)')
market_cap = StringField(ddl='varchar(30)')
market_cap_btc = StringField(ddl='varchar(30)')
price = StringField(ddl='varchar(20)')
pre_price = StringField(ddl='varchar(20)', default="")
supply_pvolume = StringField(ddl='varchar(20)')
trading_24_volume = StringField(ddl='varchar(20)')
hours_1_index = StringField(ddl='varchar(10)')
hours_24_index = StringField(ddl='varchar(10)')
day_7_index = StringField(ddl='varchar(10)')
price_rate = StringField(ddl='varchar(20)')
price_btc = StringField(ddl='varchar(20)')
pre_price_btc = StringField(ddl='varchar(20)')
price_btc_rate = StringField(ddl='varchar(20)')
trading_24_btc_volume = StringField(ddl='varchar(20)')
modify_at = FloatField(default=time.time)
created_at = FloatField(default=time.time)