class Invest_info(db.Model):
__tablename__ = "tjtyy_invest_info"
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.String(36), db.ForeignKey('tjtyy_member.id'))
product_id = db.Column(db.String(36), db.ForeignKey('tjtyy_borrow.id'))
money = db.Column(db.Float)
hongbao = db.Column(db.Float, nullable=0, default=0)
profit = db.Column(db.Float)
interest = db.Column(db.Float)
activity_interest = db.Column(db.Float)
contract = db.Column(db.String(36), db.ForeignKey("tjtyy_contract.id"))
time = db.Column(db.DateTime)
expect_time = db.Column(db.DateTime)
is_effect = db.Column(db.SmallInteger)
status = db.Column(db.String(1))
order_id = db.Column(db.String(50))
member_name = db.Column(db.String(128))
NEWHAND_ID = db.Column(db.String(36), db.ForeignKey('tjtyy_newhand.id'))
bluuid = db.Column(db.String(200))
equipment = db.Column(db.String(128))
channel_id = db.Column(db.String(10))
preservationId = db.Column(db.String(128))
activity = db.Column(db.String(256))
rate_security = db.Column(db.Float)
extra_rate = db.Column(db.Float)
yaoqing_money = db.Column(db.Float)
hongbao_source = db.Column(db.String(256))
hongbao_info_id = db.Column(db.String(128))
class Prize(db.Model):
__tablename__ = "tjtyy_member_prize"
id = db.Column(db.Integer, primary_key=True)
phone = db.Column(db.String(128))
prize_id = db.Column(db.String(128), db.ForeignKey("tjtyy_prize.id"))
time = db.Column(db.DateTime)
is_grant = db.Column(db.Integer, nullable=0, default=0)
activity_id = db.Column(db.String(128), db.ForeignKey("tjtyy_activity.id"))
class Member_invite_info(db.Model):
__tablename__ = "tjtyy_invite_info"
id = db.Column(db.Integer, primary_key=True)
inviter_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
invited_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
sign = db.Column(db.Integer, nullable=0, default=0)
inviter_time = db.Column(db.DateTime)
is_invest = db.Column(db.Integer, nullable=0, default=0)
class Member_invite_profit(db.Model):
__tablename__ = "tjtyy_invite_profit"
id = db.Column(db.Integer, primary_key=True)
inviter_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
invited_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
order_id = db.Column(db.GUID, db.ForeignKey("tjtyy_invest_info.id"))
product_id = db.Column(db.GUID, db.ForeignKey("tjtyy_borrow.id"))
# time = db.Column(db.DateTime)
# money = db.Column(db.Float)
invite_profit = db.Column(db.Float)
class Member_red_pocket(db.Model):
__tablename__ = "tjtyy_hongbao_info"
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
is_use = db.Column(db.Integer, nullable=0, default=0)
sort_id = db.Column(db.GUID, db.ForeignKey("tjtyy_hongbao.id"))
product_id = db.Column(db.GUID, db.ForeignKey("tjtyy_borrow.id"))
generate_time = db.Column(db.DateTime)
is_freeze = db.Column(db.Integer, nullable=0, default=0)
INSPECTOR = db.Column(db.String(50))
SEND_TIME = db.Column(db.DateTime)
class Prize_order(db.Model):
__tablename__ = 'tjtyy_activity_prize_order'
id = db.Column(db.Integer, primary_key=True)
phone = db.Column(db.String(32))
prize_id = db.Column(db.String(32), db.ForeignKey("tjtyy_prize.id"))
prize_name = db.Column(db.String(128))
score = db.Column(db.Integer, default=0)
money = db.Column(db.Float, default=0.0)
status = db.Column(db.Integer, default=0)
time = db.Column(db.String(32))
activity_id = db.Column(db.String(128), db.ForeignKey("tjtyy_activity.id"))
channel_num = db.Column(db.Integer)
class Product_image(db.Model):
__tablename__ = "tjtyy_borrow_image"
id = db.Column(db.Integer, primary_key=True)
image = db.Column(db.String(128))
borrow_id = db.Column(db.String(36), db.ForeignKey("tjtyy_borrow.id"))
class Prize_image(db.Model):
__tablename__ = 'tjtyy_activity_prize_image'
id = db.Column(db.Integer, primary_key=True)
prize_id = db.Column(db.String(32), db.ForeignKey("tjtyy_prize.id"))
image = db.Column(db.String(256))
class Member_email_info(db.Model):
__tablename__ = "tjtyy_member_email"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
member_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
email = db.Column(db.String(128))
class Product_borrower_image(db.Model):
__tablename__ = "tjtyy_borrower_image"
id = db.Column(db.Integer, primary_key=True)
image_url = db.Column(db.String(256))
borrower_id = db.Column(db.String(36),
db.ForeignKey("tjtyy_borrower_info.id"))
class PrizeShare(db.Model):
__tablename__ = "tjtyy_prize_num"
id = db.Column(db.Integer, primary_key=True)
phone = db.Column(db.String(128))
is_share = db.Column(db.Integer, nullable=0, default=0)
total_num = db.Column(db.Integer, nullable=1, default=1)
activity_id = db.Column(db.String(128), db.ForeignKey("tjtyy_activity.id"))
class Member_log(db.Model):
__tablename__ = 'tjtyy_member_log'
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.Integer, db.ForeignKey("tjtyy_member.id"))
log_ip = db.Column(db.String(128))
log_time = db.Column(db.String(128))
log_event = db.Column(db.String(128))
log_result = db.Column(db.String(128))
class DoLine(db.Model):
__tablename__ = "tjtyy_doLine"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
member_id = db.Column(db.String(36), db.ForeignKey('tjtyy_member.id'))
member_name = db.Column(db.String(128))
money = db.Column(db.Float)
time = db.Column(db.String(128))
inspector = db.Column(db.String(50))
order_id = db.Column(db.String(32))
class News(db.Model):
__tablename__ = "tjtyy_article_content"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
sortid = db.Column(db.Integer, db.ForeignKey("tjtyy_article_sort.id"))
title = db.Column(db.String(128))
image = db.Column(db.String(128))
content = db.Column(db.Text)
hits = db.Column(db.Integer)
posttime = db.Column(db.DateTime)
can_link = db.Column(db.Integer)
end_time = db.Column(db.DateTime)
class Product_info(db.Model):
__tablename__ = "tjtyy_borrow"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
product_name = db.Column(db.String(128))
product_type = db.Column(db.String(128))
organ_id = db.Column(db.String(36), db.ForeignKey("tjtyy_organ.id"))
borrow_id = db.Column(db.String(36),
db.ForeignKey("tjtyy_borrower_info.id"))
feature_id = db.Column(db.String(512))
rate = db.Column(db.Float)
time_limit = db.Column(db.String(128))
total_mount = db.Column(db.Float)
limit_mount = db.Column(db.Float)
rate_increase = db.Column(db.Float)
start_time = db.Column(db.DateTime)
sell_time = db.Column(db.DateTime)
end_time = db.Column(db.DateTime)
pro_time = db.Column(db.DateTime)
audit_time = db.Column(db.DateTime) # 审计时间
product_status = db.Column(db.String(
128)) # 产品状态（1为审核中、2为融资中、3为满标、4为还款中，5为已结束，6为未筹集成功，7为已退款，8为待上线）
product_detail = db.Column(db.String(128))
loan_use = db.Column(db.String(128))
repay_type = db.Column(db.String(128))
raise_limit = db.Column(db.String(128))
interest_num = db.Column(db.Integer)
interest_time = db.Column(db.DateTime)
invest_infos = db.relationship('Invest_info',
backref='tjtyy_borrow',
lazy="dynamic")
product_images = db.relationship('Product_image',
backref="tjtyy_borrow",
lazy="dynamic")
is_recommend = db.Column(db.Integer)
guarantee_id = db.Column(db.String(50))
car_message = db.Column(db.String(255))
class Member_income_statement(db.Model):
__tablename__ = "tjtyy_user_log"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
member_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
type = db.Column(db.String(128))
money = db.Column(db.Float)
balance = db.Column(db.Float)
time = db.Column(db.DateTime)
info = db.Column(db.String(128))
order_id = db.Column(db.String(20))
product_info = db.Column(db.String(128))
phone = db.Column(db.String(128))
bin_order_id = db.Column(db.String(128))
class Member_real_info(db.Model):
__tablename__ = "tjtyy_member_real_info"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
member_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
real_name = db.Column(db.String(128))
real_identid = db.Column(db.String(128))
real_idcar_image = db.Column(db.String(128))
address = db.Column(db.String(128))
sex = db.Column(db.String(1))
birthday = db.Column(db.String(10))
create_time = db.Column(db.String(128))
people_name = db.Column(db.String(50))
people_phone = db.Column(db.String(20))
people_address = db.Column(db.String(200))
class Member_asset_info(db.Model):
__tablename__ = "tjtyy_member_assets"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
member_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
member_name = db.Column(db.String(128))
rechargeamount = db.Column(db.Float, nullable=0, default=0)
remainamount = db.Column(db.Float, nullable=0, default=0)
freezeamount = db.Column(db.Float, nullable=0, default=0)
uncollectedamount = db.Column(db.Float, nullable=0, default=0)
totalamount = db.Column(db.Float, nullable=0, default=0)
experiamount = db.Column(db.Float, nullable=0, default=0)
score = db.Column(db.Integer, default=0)
bluuid = db.Column(db.String(200))
inveter_profile = db.Column(db.Float, nullable=0, default=0)
order_id = db.Column(db.String(50))
class Member_login(db.Model):
__tablename__ = 'tjtyy_member_login'
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.GUID, db.ForeignKey(Member.id))
member_name = db.Column(db.String(128))
login_times = db.Column(db.Integer)
last_ip = db.Column(db.String(128))
last_time = db.Column(db.String(128))
up_ip = db.Column(db.String(128))
up_time = db.Column(db.String(128))
equipment_name = db.Column(db.String(128))
equipment_token = db.Column(db.String(128), default='123456789')
login_token = db.Column(db.String(128))
isblack = db.Column(db.String(128))
over_time = db.Column(db.String(128))
is_hdimg = db.Column(db.Integer, default=0)
class Member_loan(db.Model):
__tablename__ = "tjtyy_member_loan"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
member_id = db.Column(db.String(50), db.ForeignKey("tjtyy_member.id"))
money_loan = db.Column(db.Float)
loaner_name = db.Column(db.String(50))
limit_loan = db.Column(db.String(20))
time_loan = db.Column(db.DateTime)
loan_status = db.Column(db.String(32), default=0)
nature_house = db.Column(db.String(50))
village_name = db.Column(db.String(50))
area_house = db.Column(db.Float)
remain_loan = db.Column(db.Float)
property_id = db.Column(db.String(32))
property_name = db.Column(db.String(32))
property_idnum = db.Column(db.String(32))
class Member_recharge_info(db.Model):
__tablename__ = 'tjtyy_member_recharge'
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
member_name = db.Column(db.String(128))
recharge_id = db.Column(db.String(128))
time = db.Column(db.DateTime)
is_effect = db.Column(db.Integer)
money = db.Column(db.Float, nullable=0, default=0)
type = db.Column(db.String(128))
equipment = db.Column(db.String(128))
bangka = db.Column(db.String(128))
code = db.Column(db.String(128))
bluuid = db.Column(db.String(200))
device_info = db.Column(db.String(50))
channel_id = db.Column(db.String(50))
class Member_reflect_info(db.Model):
__tablename__ = "tjtyy_member_reflect_info"
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
member_name = db.Column(db.String(128))
reflect_id = db.Column(db.String(128))
money = db.Column(db.Float, nullable=0, default=0)
fee = db.Column(db.Float, nullable=0, default=0)
time = db.Column(db.DateTime)
type = db.Column(db.String(128))
batchdate = db.Column(db.DateTime)
batchcurrnum = db.Column(db.String(128))
reason = db.Column(db.String(128))
bluuid = db.Column(db.String(200))
device_info = db.Column(db.String(50))
channel_id = db.Column(db.String(50))
class Member_pay_info(db.Model):
__tablename__ = "tjtyy_member_pay_info"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
member_id = db.Column(db.GUID, db.ForeignKey("tjtyy_member.id"))
pay_bankcard = db.Column(db.String(128))
account_holder = db.Column(db.String(128))
bank_name = db.Column(db.String(128))
bank_deposit = db.Column(db.String(128))
bank_address = db.Column(db.String(128))
bank_code = db.Column(db.String(128))
phone = db.Column(db.String(16))
card_type = db.Column(db.String(16))
province = db.Column(db.String(128))
city = db.Column(db.String(128))
sort = db.Column(db.Integer, nullable=0, default=0)
single_amt = db.Column(db.String(128))
day_amt = db.Column(db.String(128))
month_amt = db.Column(db.String(128))
class Zillionaire_info(db.Model):
__tablename__ = 'tjtyy_activity_zillionaire'
id = db.Column(db.Integer, primary_key=True)
phone = db.Column(db.String(32))
activity_id = db.Column(db.GUID, db.ForeignKey("tjtyy_activity.id"))
use_number = db.Column(db.Integer, default=0)
use_number02 = db.Column(db.Integer, default=0)
investment = db.Column(db.Float, default=0.0)
integral_total = db.Column(db.Integer, default=0)
has_friends = db.Column(db.Integer, default=0)
create_time = db.Column(db.String(128), default=datetime.now())
prize_id = db.Column(db.String(50), default='0')
sign_number = db.Column(db.Integer, default=0)
use_number_max = db.Column(db.Integer, default=0)
investment02 = db.Column(db.Float, default=0.0)
pineapple_small = db.Column(db.Integer, default=0)
pineapple_big = db.Column(db.Integer, default=0)
national_store = db.Column(db.Float, default=0.0)
class PrizeType(db.Model):
__tablename__ = "tjtyy_prize"
id = db.Column(db.String(64), primary_key=True)
name = db.Column(db.String(128))
hongbao_id = db.Column(db.String(128), db.ForeignKey("tjtyy_hongbao.id"))
ptype = db.Column(db.String(128))
money = db.Column(db.Float)
sort = db.Column(db.Integer)
status = db.Column(db.Integer)
valid_desc = db.Column(db.String(256))
deadline = db.Column(db.String(256))
input_time = db.Column(db.String(256))
score = db.Column(db.Integer)
stock = db.Column(db.Integer)
description = db.Column(db.String(256))
probability = db.Column(db.Float)
dice = db.Column(db.String(256))
exchange_process = db.Column(db.String(1024))
introduce = db.Column(db.String(256))
