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_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 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 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 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 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 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 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 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 Activity(db.Model):
__tablename__ = "tjtyy_activity"
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
name = db.Column(db.String(128))
end_time = db.Column(db.DateTime)
start_time = db.Column(db.DateTime)
prize_ids = db.Column(db.String(1024))
default_num = db.Column(db.Integer, nullable=1, default=1)
class Rank_list(db.Model):
__tablename__ = 'tjtyy_rank'
id = db.Column(db.GUID, primary_key=True, default=uuid.uuid4)
phone = db.Column(db.String(128))
money = db.Column(db.Integer)
is_send = db.Column(db.Float)
month = db.Column(db.String(128))
rank = db.Column(db.Integer)
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 New_activity_sort(db.Model):
__tablename__ = "tjtyy_new_activity_sort"
id = db.Column(db.Integer, primary_key=True)
activity_name = db.Column(db.String(50)) # 活动名称
activity_type = db.Column(db.String(36)) # 活动类型
start_time = db.Column(db.DateTime) # 活动开始时间
end_time = db.Column(db.DateTime) # 活动结束时间
score = db.Column(db.Integer) # 参加一次活动得分
class Integral_record(db.Model):
__tablename__ = 'tjtyy_integral_record'
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.String(28))
events = db.Column(db.String(28))
integral = db.Column(db.Integer)
time = db.Column(db.DateTime)
activity_id = db.Column(db.String(28))
class Activity_status(db.Model):
__tablename__ = 'tjtyy_activity_status'
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.String(28))
events = db.Column(db.String(28))
remain = db.Column(db.Float)
score = db.Column(db.Integer)
activity_id = db.Column(db.String(28))
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 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 Message_info(db.Model):
__tablename__ = "tjtyy_message"
id = db.Column(db.Integer, primary_key=True)
ip = db.Column(db.String(50))
phone = db.Column(db.String(36))
template_id = db.Column(db.String(36))
verify_code = db.Column(db.String(36))
send_time = db.Column(db.DateTime)
is_verify = db.Column(db.Boolean)
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 Push_info(db.Model):
__tablename__ = "tjtyy_push_info_log"
id = db.Column(db.String(36), primary_key=True)
user_type = db.Column(db.String(50))
theme = db.Column(db.String(200))
content = db.Column(db.String(500))
create_date = db.Column(db.DateTime)
push_date = db.Column(db.DateTime)
state = db.Column(db.Integer)
class Lottery_record(db.Model):
__tablename__ = 'tjtyy_activity_lottery_log'
id = db.Column(db.Integer, primary_key=True)
phone = db.Column(db.String(32))
activity_id = db.Column(db.String(32))
lottery_time = db.Column(db.String(128), default=datetime.now())
lottery_result = db.Column(db.String(255))
money = db.Column(db.Float, default=0.0)
type = db.Column(db.Integer, default=0)
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 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 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 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 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))
