class TReportComplaint(db.Model): #举报投诉表
__tablename__ = 't_report_complaints'
report_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
content = db.Column(db.String)
phone = db.Column(db.String(30))
date = db.Column(db.DateTime, nullable=False)
is_pass = db.Column(db.Integer, nullable=False)
pt_id = db.Column(db.Integer,
db.ForeignKey('t_pt_admin.pt_id'),
index=True)
source_id = db.Column(db.Integer,
db.ForeignKey('t_source.source_id'),
index=True)
source2_id = db.Column(db.Integer,
db.ForeignKey('t_second_source.source2_id'),
index=True)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
nullable=False,
index=True)
pt = db.relationship('TPtAdmin', backref='t_report_complaints')
source2 = db.relationship('TSecondSource', backref='t_report_complaints')
source = db.relationship('TSource', backref='t_report_complaints')
user = db.relationship('TUser', backref='t_report_complaints')
class TUserComment(db.Model): #用户评论表
__tablename__ = 't_user_comment'
comment_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
content = db.Column(db.String, nullable=False)
comment_type = db.Column(db.String(100), nullable=False)
date = db.Column(db.DateTime, nullable=False)
post_id = db.Column(db.Integer,
db.ForeignKey('t_user_post.post_id'),
nullable=False,
index=True)
source_id = db.Column(db.Integer,
db.ForeignKey('t_source.source_id'),
index=True)
source2_id = db.Column(db.Integer,
db.ForeignKey('t_second_source.source2_id'),
index=True)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
nullable=False,
index=True)
post = db.relationship('TUserPost', backref='t_user_comments')
source2 = db.relationship('TSecondSource', backref='t_user_comments')
source = db.relationship('TSource', backref='t_user_comments')
user = db.relationship('TUser', backref='t_user_comments')
class TAdNew(db.Model): #广告商推送消息
__tablename__ = 't_ad_news'
ad_news_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
news_title = db.Column(db.String(50))
content = db.Column(db.String(255))
date = db.Column(db.DateTime, nullable=False)
ad_id = db.Column(db.Integer, db.ForeignKey('t_ad.ad_id'), index=True)
sup_id = db.Column(db.Integer, db.ForeignKey('t_sup.sup_id'), index=True)
ad = db.relationship('TAd', backref='t_ad_news')
sup = db.relationship('TSup', backref='t_ad_news')
class TUserLd(db.Model): #用户房东聊天历史
__tablename__ = 't_user_ld'
user_ld_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
content = db.Column(db.String)
date = db.Column(db.DateTime, nullable=False)
ld_id = db.Column(db.Integer,
db.ForeignKey('t_landlord.ld_id'),
index=True)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
index=True)
ld = db.relationship('TLandlord', backref='t_user_lds')
user = db.relationship('TUser', backref='t_user_lds')
class TAdCheckRecord(db.Model): #广告审核记录表
__tablename__ = 't_ad_check_record'
ad_check_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
is_pass = db.Column(db.Integer, nullable=False)
ad_id = db.Column(db.Integer,
db.ForeignKey('t_ad.ad_id'),
nullable=False,
index=True)
pt_id = db.Column(db.Integer,
db.ForeignKey('t_pt_admin.pt_id'),
nullable=False,
index=True)
ad = db.relationship('TAd', backref='t_ad_check_records')
pt = db.relationship('TPtAdmin', backref='t_ad_check_records')
class TUserServ(db.Model): #用户客服聊天历史
__tablename__ = 't_user_serv'
user_serv_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
content = db.Column(db.String)
date = db.Column(db.DateTime, nullable=False)
serv_id = db.Column(db.Integer,
db.ForeignKey('t_serv.serv_id'),
index=True)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
index=True)
serv = db.relationship('TServ', backref='t_user_servs')
user = db.relationship('TUser', backref='t_user_servs')
class TSource(db.Model): #新房源信息
__tablename__ = 't_source'
source_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
title = db.Column(db.String(30), nullable=False)
img_url = db.Column(db.String(255), nullable=False)
pub_date = db.Column(db.DateTime, nullable=False)
nearby = db.Column(db.String(255))
region = db.Column(db.String(30), nullable=False)
hu_type = db.Column(db.String(30))
price_s = db.Column(db.Float())
comm_name = db.Column(db.String(30))
area = db.Column(db.String(30))
sum_price = db.Column(db.String(30))
face = db.Column(db.String(30))
details = db.Column(db.String(255))
floors = db.Column(db.Integer)
k_time = db.Column(db.DateTime)
ch_state = db.Column(db.Integer)
broker_id = db.Column(db.Integer,
db.ForeignKey('t_broker.broker_id'),
nullable=False,
index=True)
broker = db.relationship('TBroker', backref='t_sources', lazy='immediate')
class TRentalTransaction(db.Model): #租房定金交易表
__tablename__ = 't_rental_transaction'
rental_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
deposit_amount = db.Column(db.Float(asdecimal=True), nullable=False)
deposit_date = db.Column(db.DateTime, nullable=False)
source2_id = db.Column(db.Integer,
db.ForeignKey('t_second_source.source2_id'),
nullable=False,
index=True)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
nullable=False,
index=True)
source2 = db.relationship('TSecondSource', backref='t_rental_transactions')
user = db.relationship('TUser', backref='t_rental_transactions')
class TNewTransaction(db.Model): #新房交易记录表
__tablename__ = 't_new_transaction'
new_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
deposit_amount = db.Column(db.Float(asdecimal=True), nullable=False)
deposit_date = db.Column(db.DateTime, nullable=False)
source_id = db.Column(db.Integer,
db.ForeignKey('t_source.source_id'),
nullable=False,
index=True)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
nullable=False,
index=True)
source = db.relationship('TSource', backref='t_new_transactions')
user = db.relationship('TUser', backref='t_new_transactions')
class TForwardNew(db.Model): #用户推送消息
__tablename__ = 't_forward_news'
message_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
mess_title = db.Column(db.String(50), nullable=False)
content = db.Column(db.String(255), nullable=False)
date = db.Column(db.DateTime, nullable=False)
sup_id = db.Column(db.Integer,
db.ForeignKey('t_sup.sup_id'),
nullable=False,
index=True)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
nullable=False,
index=True)
sup = db.relationship('TSup', backref='t_forward_news')
user = db.relationship('TUser', backref='t_forward_news')
class TCommunity(db.Model): #小区精选
__tablename__ = 't_community'
comm_hpk_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
source_id = db.Column(db.Integer,
db.ForeignKey('t_source.source_id'),
index=True)
source = db.relationship('TSource', backref='t_communities')
class TUserHistory(db.Model): #用户浏览记录
__tablename__ = 't_user_history'
history_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
date = db.Column(db.DateTime, nullable=False)
source_id = db.Column(db.Integer,
db.ForeignKey('t_source.source_id'),
index=True)
source2_id = db.Column(db.Integer,
db.ForeignKey('t_second_source.source2_id'),
index=True)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
nullable=False,
index=True)
source2 = db.relationship('TSecondSource', backref='t_user_histories')
source = db.relationship('TSource', backref='t_user_histories')
user = db.relationship('TUser', backref='t_user_histories')
class TCheckHousetie(db.Model): #房源审核记录表
__tablename__ = 't_check_housetie'
check_house_id = db.Column(db.Integer,
primary_key=True,
autoincrement=True)
is_pass = db.Column(db.Integer, nullable=False)
pt_id = db.Column(db.Integer,
db.ForeignKey('t_pt_admin.pt_id'),
index=True)
source_id = db.Column(db.Integer,
db.ForeignKey('t_source.source_id'),
index=True)
source2_id = db.Column(db.Integer,
db.ForeignKey('t_second_source.source2_id'),
index=True)
pt = db.relationship('TPtAdmin', backref='t_check_houseties')
source2 = db.relationship('TSecondSource', backref='t_check_houseties')
source = db.relationship('TSource', backref='t_check_houseties')
class TSecondGoodHouse(db.Model): #二手好房推荐
__tablename__ = 't_second_good_house'
source2_good_id = db.Column(db.Integer,
primary_key=True,
autoincrement=True)
source2_id = db.Column(db.Integer,
db.ForeignKey('t_second_source.source2_id'),
index=True)
source2 = db.relationship('TSecondSource', backref='t_second_good_houses')
class TAdExpireRenew(db.Model): #广告到期续费表
__tablename__ = 't_ad_expire_renew'
ad_renew_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
is_renew = db.Column(db.Integer)
ad_id = db.Column(db.Integer,
db.ForeignKey('t_ad.ad_id'),
nullable=False,
index=True)
ad = db.relationship('TAd', backref='t_ad_expire_renews')
class TUserIntegral(db.Model): #积分表
__tablename__ = 't_user_integral'
integ_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
integral = db.Column(db.Integer)
VIP_grade = db.Column(db.Integer)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
nullable=False,
index=True)
user = db.relationship('TUser', backref='t_user_integrals')
class TUserRecharge(db.Model): #冲值表
__tablename__ = 't_user_recharge'
recharge_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
recharge_type = db.Column(db.String(50))
recharge_amount = db.Column(db.Float(asdecimal=True), nullable=False)
date = db.Column(db.DateTime, nullable=False)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
nullable=False,
index=True)
user = db.relationship('TUser', backref='t_user_recharges')
class TAd(db.Model): #广告模型
__tablename__ = 't_ad'
ad_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
title = db.Column(db.String(30), nullable=False)
img_url = db.Column(db.String(255), nullable=False)
ad_url = db.Column(db.String(255), nullable=False)
fabu_time = db.Column(db.DateTime)
val = db.Column(db.DateTime)
audit_state = db.Column(db.Integer)
ad_bm_id = db.Column(db.Integer,
db.ForeignKey('t_ad_bm.ad_bm_id'),
index=True)
ad_pos_id = db.Column(db.Integer,
db.ForeignKey('t_ad_pos.ad_pos_id'),
nullable=False,
index=True)
note = db.Column(db.String, nullable=False)
# lazy = 'select' 表示查看属性时，才会执行selet查询语句, 如果是immediate 表示同当前所在的模型数据一起查询出来。
ad_bm = db.relationship('TAdBm', backref='t_ads', lazy='immediate')
ad_pos = db.relationship('TAdPo', backref='t_ads', lazy='immediate')
class TUserPost(db.Model): #用户发帖表
__tablename__ = 't_user_post'
post_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
title = db.Column(db.String(255), nullable=False)
content = db.Column(db.String, nullable=False)
date = db.Column(db.DateTime, nullable=False)
user_id = db.Column(db.Integer,
db.ForeignKey('t_user.user_id'),
nullable=False,
index=True)
tie_pic = db.Column(db.String(500))
user = db.relationship('TUser', backref='t_user_posts')
class TSecImgDetail(db.Model): #二手房详情
__tablename__ = 't_sec_img_details'
second_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
pic_url = db.Column(db.String(255), nullable=False)
title = db.Column(db.String(100), nullable=False)
width = db.Column(db.Float(asdecimal=True))
height = db.Column(db.Float(asdecimal=True))
source2_id = db.Column(db.Integer,
db.ForeignKey('t_second_source.source2_id'),
nullable=False,
index=True)
source2 = db.relationship('TSecondSource', backref='t_sec_img_details')
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 TBroker(db.Model): #经纪人
__tablename__ = 't_broker'
broker_id = db.Column(db.Integer, primary_key=True,
autoincrement=True) #经纪人编号
b_name = db.Column(db.String(30), nullable=False) #姓名
sex = db.Column(db.String(30), nullable=False) #性别
phone = db.Column(db.String(30), nullable=False) #电话
b_uname = db.Column(db.String(30), nullable=False) #账户
b_pwd = db.Column(db.String(255), nullable=False) #密码
Avatar_path = db.Column(db.String(255)) #头像
regi_date = db.Column(db.DateTime, nullable=False) #创建时间
status = db.Column(db.Integer, nullable=False) #在线状态
clinch_num = db.Column(db.Integer, nullable=False) #
sou_num = db.Column(db.Integer, nullable=False) #发布数量
years = db.Column(db.Integer, nullable=False) #从业年限
company_id = db.Column(db.Integer,
db.ForeignKey('t_company.company_id'),
nullable=False,
index=True) #关联的公司id
company = db.relationship('TCompany',
backref='t_brokers',
lazy='immediate')