Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
951 B
4
Indexable
Never
class Property(Base):
    __tablename__ = 'properties'
    id = Column(Integer, primary_key=True, index=True)

    street_name = Column(String(80), nullable=True)
    postal_code = Column(String(10), nullable=True)
    city = Column(String(80), nullable=True)

    state_code = Column(String(10), nullable=True)
    country = 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)

    air_construction = Column(String(100), nullable=True)
    air_occupancy = Column(String(100), nullable=True)

    current = Column(Boolean, default=False)
    quote_id = Column(UUIDType, ForeignKey('quotes.id'), index=True)