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))