Untitled
unknown
plain_text
2 years ago
3.5 kB
6
Indexable
class Property(Base): __tablename__ = 'properties' id = Column(Integer, primary_key=True, index=True) acc_grp_name = Column(String(80), nullable=True) loc_id = Column(String(80), nullable=True) loc_num = Column(String(80), nullable=True) loc_name = Column(String(80), nullable=True) street_name = Column(String(80), nullable=True) postal_code = Column(String(10), nullable=True) city = Column(String(80), nullable=True) county = Column(String(80), nullable=True) state_code = Column(String(10), nullable=True) country = Column(String(80), nullable=True) latitude = Column(String(80), nullable=True) longitude = Column(String(80), nullable=True) cresta_mapping = Column(String(80), nullable=True) number_of_buildings = Column(Integer, nullable=True) number_of_stories = Column(Integer, nullable=True) year_built = Column(String(4), nullable=True) building_scheme = Column(String(80), nullable=True) building_class = Column(String(80), nullable=True) occupancy_scheme = Column(String(80), nullable=True) occupancy_type = Column(String(80), nullable=True) floor_area = Column(Float, nullable=True) building_tiv = Column(Float, nullable=True) contents_tiv = Column(Float, nullable=True) business_interruption_tiv = Column(Float, nullable=True) total_tiv = Column(Float, nullable=True) eq_site_deduction = Column(Float, nullable=True) ws_site_deduction = Column(Float, nullable=True) cs_site_deduction = Column(Float, nullable=True) fl_site_deduction = Column(Float, nullable=True) fr_site_deduction = Column(Float, nullable=True) eq_modelled = Column(Boolean, default=False) ws_modelled = Column(Boolean, default=False) cs_modelled = Column(Boolean, default=False) agg_gu_aal = Column(Float, nullable=True) air_construction = Column(String(100), nullable=True) air_occupancy = Column(String(100), nullable=True) geo_match_level_code = Column(String(80), nullable=True) region = Column(String(80), nullable=True) flood_zone = Column(String(80), nullable=True) fema_flood_zone = Column(String(80), nullable=True) fl_elevation = Column(String(80), nullable=True) eq_soil_type = Column(String(80), nullable=True) eq_cal_doi_zone = Column(String(80), nullable=True) eq_liquefaction_potential = Column(String(80), nullable=True) eq_landslide = Column(String(80), nullable=True) eq_nearest_fault_name = Column(String(80), nullable=True) eq_distance_to_nearest_fault = Column(Float, nullable=True) ws_effective_distance_to_coast = Column(String(80), nullable=True) ws_tier = Column(String(80), nullable=True) eq_covered = Column(Boolean, default=False) ws_covered = Column(Boolean, default=False) cs_covered = Column(Boolean, default=False) wf_covered = Column(Boolean, default=False) fl_covered = Column(Boolean, default=False) ss_covered = Column(Boolean, default=False) ground_up_aal_eq = Column(Float, nullable=True) ground_up_aal_ws = Column(Float, nullable=True) ground_up_aal_cs = Column(Float, nullable=True) hail_risk = Column(String(80), nullable=True) ground_up_aal_eq_unadj = Column(Float, nullable=True) ground_up_aal_ws_unadj = Column(Float, nullable=True) ground_up_aal_cs_unadj = Column(Float, nullable=True) current = Column(Boolean, default=False) quote_id = Column(UUIDType, ForeignKey('quotes.id'), index=True)
Editor is loading...