class Category(db.Model):
__tablename__ = "du_category"
category_id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), unique=True)
def __init__(self, name):
self.name = name
def __repr__(self):
return self.name
class Marketing_activity(db.Model):
__bind_key__ = 'marketing'
__tablename__ = 'activity_time_config'
id = db.Column(db.Integer, primary_key=True)
activity_id = db.Column(db.String)
begin_time = db.Column(db.DateTime)
end_time = db.Column(db.DateTime)
def __repr__(self):
return '%r' % self.begin_time
class User(db.Model):
__tablename__ = "du_user"
user_id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), unique=True)
phone = db.Column(db.String(64), unique=True)
password = db.Column(db.String(64), unique=True)
update_time = db.Column(db.DateTime, unique=True)
def __init__(self, username, phone, password, update_time):
self.username = username
self.phone = phone
self.password = password
self.update_time = update_time
def __repr__(self):
return self.username
class Link_home(db.Model):
__tablename__ = "du_link"
link_id = db.Column(db.Integer, primary_key=True)
link_name = db.Column(db.String(64), unique=True)
link_address = db.Column(db.String(64), unique=True)
link_belong_service = db.Column(db.String(64), unique=True)
update_time = db.Column(db.DateTime, unique=True)
def __init__(self, link_name, link_belong_service, update_time,
link_address):
self.link_name = link_name
self.link_belong_service = link_belong_service
self.link_address = link_address
self.update_time = update_time
def __repr__(self):
return self.link_name
class Node_activity_withdraw(db.Model):
__bind_key__ = 'jimu'
__tablename__ = 'user_daily_draw_times'
id = db.Column(db.Integer, primary_key=True)
activityId = db.Column(db.Integer)
userId = db.Column(db.Integer)
drawDate = db.Column(db.Integer)
maxTimes = db.Column(db.Integer)
drawTimes = db.Column(db.Integer)
addCalledTimes = db.Column(db.Integer)
createdAt = db.Column(db.DateTime)
updatedAt = db.Column(db.DateTime)
def __repr__(self):
return '%r' % self.maxTimes, self.drawDate
class Node_activity(db.Model):
__bind_key__ = 'jimu'
__tablename__ = 'activity_def'
activityId = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
activityType = db.Column(db.Integer)
investList = db.Column(db.String)
lockPeriod = db.Column(db.String)
onlineAt = db.Column(db.DateTime)
offlineAt = db.Column(db.DateTime)
createdAt = db.Column(db.DateTime)
updatedAt = db.Column(db.DateTime)
def __repr__(self):
return '%r' % self.activityId
class Uplan_repay_record(db.Model):
__bind_key__ = 'plan'
__tablename__ = 'uplan_repay_record'
id = db.Column(db.Integer, primary_key=True)
sub_point_id = db.Column(db.Integer)
phase_number = db.Column(db.Integer)
due_date = db.Column(db.DateTime)
interest = db.Column(db.Float)
recovery_interest = db.Column(db.Float)
unpaid_interest = db.Column(db.Float)
reminded = db.Column(db.Integer)
version = db.Column(db.Integer)
def __repr__(self):
return "<dun_info(interest='%s', recovery_interest='%s', unpaid_interest='%s', sub_point_id='%s')>" % (
self.interest, self.recovery_interest, self.unpaid_interest,
self.sub_point_id)
class User_(db.Model):
__bind_key__ = 'ywcs'
__tablename__ = 'user_'
userId = db.Column(db.Integer, primary_key=True)
basicInfoFinished = db.Column(db.Integer)
detailInfoFinished = db.Column(db.Integer)
registerTime = db.Column(db.DateTime)
roles = db.Column(db.Integer)
username = db.Column(db.String)
mobile = db.Column(db.String)
account_id = db.Column(db.Integer)
def __repr__(self):
# return "<user_(userId='%s', mobile='%s', username='******',registerTime='%s')>" % (
# self.userId, self.mobile, self.username, self.registerTime)
return "%s" % self.userId
class Duty(db.Model):
__tablename__ = "du_duty"
duty_id = db.Column(db.Integer, primary_key=True)
category_id = db.Column(db.Integer, unique=True)
user_id = db.Column(db.Integer, unique=True)
parm = db.Column(db.String(5000), unique=True)
return_parm = db.Column(db.String(5000), unique=True)
title = db.Column(db.String(64), unique=True)
status = db.Column(db.Integer, unique=True)
is_show = db.Column(db.Integer, unique=True)
update_time = db.Column(db.DateTime, unique=True)
# def __init__(self,duty_id, category_id, user_id, parm, return_parm, title, status, is_show, update_time):
# self.duty_id = duty_id
# self.category_id = category_id
# self.user_id = user_id
# self.parm = parm
# self.return_parm = return_parm
# self.title = title
# self.status = status
# self.is_show = is_show
# self.update_time = update_time
def __init__(self, category_id, user_id, parm, return_parm, title, status,
is_show, update_time):
self.category_id = category_id
self.user_id = user_id
self.parm = parm
self.return_parm = return_parm
self.title = title
self.status = status
self.is_show = is_show
self.update_time = update_time
def __repr__(self):
return self.parm
class Case_info(db.Model):
__tablename__ = "du_case"
caseid = db.Column(db.Integer, primary_key=True)
casename = db.Column(db.String(512), unique=True)
case_param = db.Column(db.String(5000), unique=True)
case_belong_suite = db.Column(db.String(64), unique=True)
create_user = db.Column(db.String(64), unique=True)
create_time = db.Column(db.DateTime, unique=True)
update_time = db.Column(db.DateTime, unique=True)
def __init__(self, casename, case_param, case_belong_suite, create_user,
create_time):
self.casename = casename
self.case_param = case_param
self.case_belong_suite = case_belong_suite
self.create_user = create_user
self.create_time = create_time
def __repr__(self):
return self.case_param
class Jimu_prize(db.Model):
__bind_key__ = 'jimu'
__tablename__ = 'prize'
id = db.Column(db.Integer, primary_key=True)
groupId = db.Column(db.Integer)
name = db.Column(db.String)
type = db.Column(db.Integer)
totalNum = db.Column(db.Integer)
residueNum = db.Column(db.Integer)
probability = db.Column(db.Integer)
img = db.Column(db.String)
imgPc = db.Column(db.String)
success = db.Column(db.String)
whiteListRuleId = db.Column(db.String)
extra = db.Column(db.Integer)
isDefault = db.Column(db.Integer)
updatedAt = db.Column(db.DateTime)
createdAt = db.Column(db.DateTime)
def __repr__(self):
return '%s' % self.name
class Finance_plan(db.Model):
__bind_key__ = 'plan'
__tablename__ = 'finance_plan'
id = db.Column(db.Integer, primary_key=True)
actual_amount = db.Column(db.Float)
category = db.Column(db.String)
allow_access = db.Column(db.Integer)
amount = db.Column(db.Float)
append_multiple_amount = db.Column(db.Integer)
begin_selling_time = db.Column(db.DateTime)
buy_in_rate = db.Column(db.Float)
cashdraw_day = db.Column(db.Integer)
cashdraw_isfree = db.Column(db.Integer)
close_time = db.Column(db.DateTime)
contract_id = db.Column(db.Integer)
create_time = db.Column(db.DateTime)
create_user = db.Column(db.String)
end_locking_time = db.Column(db.DateTime)
end_selling_time = db.Column(db.DateTime)
expected_rate = db.Column(db.String)
expected_rate_uplan = db.Column(db.Float)
interest_rate = db.Column(db.Float)
introduce = db.Column(db.String)
loan_highest_rate = db.Column(db.Float)
loan_hightest_period = db.Column(db.Integer)
loan_lowest_period = db.Column(db.Integer)
loan_lowest_rate = db.Column(db.Float)
lock_period = db.Column(db.Integer)
max_invest_rate = db.Column(db.Float)
min_append_amount = db.Column(db.Float)
min_invest_rate = db.Column(db.Float)
min_register_amount = db.Column(db.Float)
name = db.Column(db.String)
picture = db.Column(db.String)
products_json = db.Column(db.String)
quit_rate = db.Column(db.Float)
quit_rate_advance = db.Column(db.Float)
register_multiple_amount = db.Column(db.Integer)
sale_period = db.Column(db.Integer)
single_max_register_amount = db.Column(db.Float)
status = db.Column(db.String)
update_time = db.Column(db.DateTime)
update_user = db.Column(db.String)
version = db.Column(db.Integer)
plan_begin_selling_time = db.Column(db.DateTime)
min_invest_amount = db.Column(db.Float)
actual_reserve_amount = db.Column(db.Float)
max_ucode_amount = db.Column(db.Float)
deposit_rate = db.Column(db.Float)
max_deposit_amount = db.Column(db.Float)
end_reserving_time = db.Column(db.DateTime)
end_payment_time = db.Column(db.DateTime)
balance_payment_time = db.Column(db.DateTime)
begin_reselling_time = db.Column(db.DateTime)
balance_payment_flag = db.Column(db.String)
actual_reserving_full_time = db.Column(db.DateTime)
actual_balance_payment_end_time = db.Column(db.DateTime)
end_reserving_process_flag = db.Column(db.String)
contract_rsv_id = db.Column(db.Integer)
is_roll_over = db.Column(db.Integer)
novice = db.Column(db.Integer)
extra_interest_rate = db.Column(db.Float)
base_interest_rate = db.Column(db.Float)
tag = db.Column(db.String)
finance_plan_type = db.Column(db.String)
compound_rate = db.Column(db.Float)
weight = db.Column(db.Integer)
style = db.Column(db.String)
is_show_amount = db.Column(db.Integer)
is_show_countdown = db.Column(db.Integer)
label = db.Column(db.Integer)
final_period = db.Column(db.Integer)
apply_quit_days = db.Column(db.Integer)
reserve_time = db.Column(db.DateTime)
reserve_amount = db.Column(db.Float)
allow_advance_quit = db.Column(db.Integer)
def __repr__(self):
return '%r' % self.id