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