Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
3.5 kB
4
Indexable
Never
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)