class TAdBm(db.Model): #广告商模型 __tablename__ = 't_ad_bm' ad_bm_id = db.Column(db.Integer, primary_key=True, autoincrement=True) pwd = db.Column(db.String(255), nullable=False) name = db.Column(db.String(30), nullable=False) ad_num = db.Column(db.Integer, nullable=False) set_time = db.Column(db.DateTime, nullable=False) val_ad_num = db.Column(db.Integer, nullable=False) type = db.Column(db.String(30), nullable=False)
class TSecondSource(db.Model): #二手房源信息表 __tablename__ = 't_second_source' source2_id = db.Column(db.Integer, primary_key=True, autoincrement=True) img_url = db.Column(db.String(255)) pub_date = db.Column(db.DateTime, nullable=False) nearby = db.Column(db.String(50)) region = db.Column(db.String(50)) hu_type = db.Column(db.String(50)) price_s = db.Column(db.Integer) comm_name = db.Column(db.String(30)) area = db.Column(db.Float()) sum_price = db.Column(db.Float()) dis_price = db.Column(db.Float()) sell_rent = db.Column(db.String(30)) rent_money = db.Column(db.Float()) face = db.Column(db.String(30)) details = db.Column(db.String(255)) floors = db.Column(db.Integer) ch_state = db.Column(db.Integer) fav_num = db.Column(db.Integer) comment_num = db.Column(db.Integer) shared_num = db.Column(db.Integer) broker_id = db.Column(db.Integer, db.ForeignKey('t_broker.broker_id'), index=True) ld_id = db.Column(db.Integer, db.ForeignKey('t_landlord.ld_id'), index=True) title = db.Column(db.String(100)) broker = db.relationship('TBroker', backref='t_second_sources', lazy='immediate') ld = db.relationship('TLandlord', backref='t_second_sources', lazy='immediate')
class TUser(db.Model): #***********用户表 __tablename__ = 't_user' user_id = db.Column(db.Integer, primary_key=True, autoincrement=True) #用户id sex = db.Column(db.String(30), nullable=False) #性别 phone = db.Column(db.String(30), nullable=False) #电话 Avatar_path = db.Column(db.String(255)) #头像地址 u_name = db.Column(db.String(50), nullable=False) #用户名 u_pwd = db.Column(db.String(255), nullable=False) #密码 status = db.Column(db.Integer, nullable=False) #在线状态,默认给个1,表示在线 balance = db.Column(db.Float(asdecimal=True), nullable=False) #账户余额 regi_date = db.Column(db.DateTime, nullable=False) #注册时间 last_date = db.Column(db.DateTime, nullable=False) #修改时间 times = db.Column(db.Integer) #分享次数 code = db.Column(db.String(20)) #推荐码 code_num = db.Column(db.Integer) #推荐成功次数 mes_text = db.Column(db.String(50)) mes_title = db.Column(db.String(255))
class TLandlord(db.Model): #房东信息表 __tablename__ = 't_landlord' ld_id = db.Column(db.Integer, primary_key=True, autoincrement=True) #房东编号 l_name = db.Column(db.String(30), nullable=False) #房东姓名 sex = db.Column(db.String(30), nullable=False) #性别 phone = db.Column(db.String(30), nullable=False) #电话 l_uname = db.Column(db.String(30), nullable=False) #账号 l_pwd = db.Column(db.String(100), nullable=False) #密码 Avatar_path = db.Column(db.String(255), default='') #头像 regi_date = db.Column(db.DateTime, nullable=False) #创建时间 last_date = db.Column(db.DateTime, nullable=False) #修改时间 status = db.Column(db.Integer, nullable=False) #在线状态,默认给个1 sou_num = db.Column(db.Integer, nullable=False) #发布房源数 mes_text = db.Column(db.String(255)) #推送消息 mes_title = db.Column(db.String(100)) #推送消息标题