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)) #推送消息标题
