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