mobile = db.Column(db.String(11), unique=True, nullable=False) real_name = db.Column(db.String(32)) id_card = db.Column(db.String(20)) # 用户头像路径 avatar_url = db.Column(db.String(128)) # 在一表中,或者多表中写relationship houses = db.relationship('House', backref='user') orders = db.relationship('Order', backref='user') # 房屋设施表,建立房屋与设施的多对多关系 # 没有设置id, 联合主键做id house_facility = db.Table( 'ihome_python_house_facility', db.Column('id', db.Integer, primary_key=True), db.Column('house_id', db.Integer, db.ForeignKey('ihome_python_house_info.id')), db.Column('facility_id', db.Integer, db.ForeignKey('ihome_python_facility_info.id')) ) class House(BaseModel): __tablename__ = 'ihome_python_house_info' id = db.Column(db.Integer, primary_key=True) # 在多表中建立外键 user_id = db.Column(db.Integer, db.ForeignKey('ihome_python_user_profile.id'), nullable=False) area_id = db.Column(db.Integer, db.ForeignKey('ihome_python_area_info.id'), nullable=False) title = db.Column(db.String(64), nullable=False) # 标题 price = db.Column(db.Integer, default=0) # 单价,单位:分 address = db.Column(db.String(512), default="") # 地址
houses = db.relationship("House", backref="area") # 区域的房屋 def area_dict(self): area_dict = {'aid': self.id, 'aname': self.name} return area_dict # 房屋设施表,建立房屋与设施的多对多关系 # 如果是多对多, 直接操作底层的表 house_facility = db.Table( "ih_house_facility", db.Column("house_id", db.Integer, db.ForeignKey("ih_house_info.id"), primary_key=True), # 房屋编号 db.Column("facility_id", db.Integer, db.ForeignKey("ih_facility_info.id"), primary_key=True) # 设施编号 ) class House(BaseModel, db.Model): """房屋信息""" __tablename__ = "ih_house_info" id = db.Column(db.Integer, primary_key=True) # 房屋编号 title = db.Column(db.String(64), nullable=False) # 标题
id = db.Column(db.Integer, primary_key=True) # 区域编号 name = db.Column(db.String(32), nullable=False) # 城区名字 hourses = db.relationship('House', backref='area') # 城区的房屋 def to_dict(self): area_dict = {'aid': self.id, 'aname': self.name} return area_dict # 房屋设施表,建立房屋与设施的多对多关系 house_facility = db.Table( 'ih_house_facility', db.Column('hourse_id', db.Integer, db.ForeignKey('ih_house_info.id'), primary_key=True), # 房屋编号 db.Column('facility_id', db.Integer, db.ForeignKey('ih_facility_info.id'), primary_key=True) # 设施编号 ) class House(BaseModel, db.Model): """房屋信息""" __tablename__ = "ih_house_info" id = db.Column(db.Integer, primary_key=True) # 房屋编号 user_id = db.Column(db.Integer, db.ForeignKey("ih_user_profile.id"),