class New_activity_prize_info(db.Model):
__tablename__ = "tjtyy_new_activity_prize_info"
id = db.Column(db.String(36), primary_key=True) # 奖品ID
prize_name = db.Column(db.String(50)) # 奖品名称
amount = db.Column(db.Integer) # 库存
class New_activity_score_reward(db.Model):
__tablename__ = "tjtyy_new_activity_score_reward"
id = db.Column(db.String(36), primary_key=True)
score_rank = db.Column(db.Integer) # 积分等级
prize_id = db.Column(db.String(36)) # 奖品id
class New_activity_member_score(db.Model):
__tablename__ = "tjtyy_new_activity_member_score"
id = db.Column(db.Integer, primary_key=True)
phone = db.Column(db.String(50)) # 用户手机号
score_total = db.Column(db.Integer) # 积分总数
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 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 Borrow_attachment(db.Model):
__tablename__ = "t_s_attachment"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
attachmenttitle = db.Column(db.String(128))
realpath = db.Column(db.String(128))
class Contract(db.Model):
__tablename__ = "tjtyy_contract"
id = db.Column(db.GUID, primary_key=True)
content = db.Column(db.Text)
contract_name = db.Column(db.String(128))
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 Order_dict(db.Model):
__tablename__ = "tjtyy_hashcode"
id = db.Column(db.Integer, primary_key=True)
order_id = db.Column(db.String(20))
is_use = db.Column(db.Boolean)
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 Province_city(db.Model):
__tablename__ = "tjtyy_city"
id = db.Column(db.Integer, primary_key=True)
province = db.Column(db.String(128))
city = db.Column(db.String(128))
code = db.Column(db.String(128))
class Feature_info(db.Model):
__tablename__ = "tjtyy_feature_info"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
feature_name = db.Column(db.String(128))
detail = db.Column(db.String(128))
logo = db.Column(db.String(128))
class New_activity_prize_give_record(db.Model):
__tablename__ = "tjtyy_new_activity_prize_give_record"
id = db.Column(db.String(50), primary_key=True)
member_id = db.Column(db.String(50)) # 用户ID
prize_id = db.Column(db.String(36)) # 奖品ID
create_time = db.Column(db.DateTime) # 创建时间
class New_activity_score_record(db.Model):
__tablename__ = "tjtyy_new_activity_score_record"
id = db.Column(db.Integer, primary_key=True)
phone = db.Column(db.String(50)) # 用户手机号
activity_id = db.Column(db.String(36)) # 活动ID
create_time = db.Column(db.DateTime) # 创建时间
score = db.Column(db.Integer) # 得分
class Sign_record(db.Model):
__tablename__ = 'tjtyy_activity_sign_record'
id = db.Column(db.Integer, primary_key=True)
phone = db.Column(db.String(32))
check_time = db.Column(db.String(128))
check_number = db.Column(db.Integer, default=1)
integral = db.Column(db.Integer, default=2)
class Error_log(db.Model):
__tablename__ = "tjtyy_error_log"
id = db.Column(db.Integer, primary_key=True)
creat_time = db.Column(db.DateTime)
description = db.Column(db.String(255))
type = db.Column(db.String(64))
phone = db.Column(db.String(64))
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 Sort(db.Model):
__tablename__ = "tjtyy_article_sort"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(128))
metakeyword = db.Column(db.String(128))
label = db.Column(db.String(128))
news_infos = db.relationship('News',
backref="tjtyy_article_sort",
lazy="dynamic")
class Member_red_pocket_type(db.Model):
__tablename__ = "tjtyy_hongbao"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
type = db.Column(db.String(128))
name = db.Column(db.String(128))
rules = db.Column(db.String(128))
validtime = db.Column(db.String(128))
money = db.Column(db.Float)
start_money = db.Column(db.Float)
invest_days = db.Column(db.Float)
code = db.Column(db.String(24))
rate = db.Column(db.Float)
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 Prize_product(db.Model):
__tablename__ = 'tjtyy_activity_prize_product'
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
name = db.Column(db.String(128))
number = db.Column(db.Integer) # 期号
remain = db.Column(db.Integer) # 剩余
total = db.Column(db.Integer) # 总共需要的菠萝
type = db.Column(db.Integer)
start_time = db.Column(db.String(128))
end_time = db.Column(db.String(128))
location = db.Column(db.Integer)
issue = db.Column(db.String(128))
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 Member_bank_logo(db.Model):
__tablename__ = "tjtyy_bank_logo"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
bank = db.Column(db.String(128))
logo = db.Column(db.String(128))
sign = db.Column(db.String(1))
bank_code = db.Column(db.String(32))
single_amt = db.Column(db.String(128))
day_amt = db.Column(db.String(128))
month_amt = db.Column(db.String(128))
bank_code2 = db.Column(db.String(32)) # 新网bank_code
class Product_new(db.Model):
__tablename__ = "tjtyy_newhand"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
product_name = db.Column(db.String(128))
rate = db.Column(db.Float)
time_limit = db.Column(db.String(128))
limit_mount = db.Column(db.Float)
rate_increase = db.Column(db.Float, default=0)
product_status = db.Column(db.String(128))
product_detail = db.Column(db.String(128))
repay_type = db.Column(db.String(128))
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 Member_bussnes(db.Model):
__tablename__ = "tjtyy_business"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
business_name = db.Column(db.String(128))
linkman = db.Column(db.String(128))
phone = db.Column(db.String(128))
linkman_post = db.Column(db.String(128))
money = db.Column(db.Integer)
cycle = db.Column(db.Integer)
content = db.Column(db.String(128))
class Prize_product_invest(db.Model):
__tablename__ = 'tjtyy_activity_product_invest'
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
phone = db.Column(db.String(128))
product_number = db.Column(db.String(128))
number = db.Column(db.Integer)
is_lucky = db.Column(db.Integer, default=0)
create_time = db.Column(db.String(128))
prize = db.Column(db.String(128))
order_id = db.Column(db.String(128))
class Account_info(db.Model):
__tablename__ = "tjtyy_account_info"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
user_name = db.Column(db.String(255)) # 担保人姓名
account = db.Column(db.String(50)) # 银行卡号
product_id = db.Column(db.String(50)) # 产品ID
borrow_id = db.Column(db.String(50)) # 借款人ID
MEMBER_ID = db.Column(db.String(50))
id_card = db.Column(db.String(50)) # 身份证号
class Points_change(db.Model):
__tablename__ = 'tjtyy_activity_points_change'
id = db.Column(db.Integer, primary_key=True)
phone = db.Column(db.String(32))
type = db.Column(db.Integer, default=0)
num = db.Column(db.Integer, default=0)
time = db.Column(db.String(128), default=datetime.now())
score = db.Column(db.Integer, default=0)
description = 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))
