class DataUpload(SQLModel, table=True): __tablename__ = "data_upload" __table_args__ = {"schema": "customer"} id: Optional[int] = Field(sa_column=Column(Integer, primary_key=True, autoincrement=True)) data_type: str = Field(sa_column=Column(Text, nullable=False)) upload_type: str = Field(sa_column=Column(Text, nullable=False)) upload_grid_ids: Optional[List[str]] = Field( sa_column=Column(ARRAY(Text()), nullable=False, server_default=text("'{}'::text[]")) ) upload_size: int = Field(nullable=False) creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP")) ) user_id: int = Field( sa_column=Column( Integer, ForeignKey("customer.user.id", ondelete="CASCADE"), nullable=False ) ) study_area_id: int = Field( sa_column=Column( Integer, ForeignKey("basic.study_area.id"), nullable=False ) ) reached_poi_heatmap_computed: Optional[bool] user: "******" = Relationship(back_populates="data_uploads") study_area: "StudyArea" = Relationship(back_populates="data_uploads") pois_user: List["PoiUser"] = Relationship(back_populates="data_upload") aois_user: List["AoiUser"] = Relationship(back_populates="data_upload")
class Scenario(SQLModel, table=True): __tablename__ = "scenario" __table_args__ = {"schema": "customer"} id: Optional[int] = Field(sa_column=Column(Integer, primary_key=True, autoincrement=True)) scenario_name: str = Field(sa_column=Column(Text, nullable=False)) routing_heatmap_computed: Optional[bool] creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP")) ) user_id: int = Field( sa_column=Column( Integer, ForeignKey("customer.user.id", ondelete="CASCADE"), nullable=False ), ) data_upload_ids: Optional[List[int]] = Field( sa_column=Column(ARRAY(Integer()), server_default=text("'{}'::int[]")) ) study_area_id: int = Field( sa_column=Column(Integer, ForeignKey("basic.study_area.id"), nullable=False) ) user: "******" = Relationship(back_populates="scenarios") isochrone_calculations: List["IsochroneCalculation"] = Relationship(back_populates="scenario") pois_modified: List["PoiModified"] = Relationship(back_populates="scenario") aois_modified: List["AoiModified"] = Relationship(back_populates="scenario") populations_modified: List["PopulationModified"] = Relationship(back_populates="scenario") buildings_modified: List["BuildingModified"] = Relationship(back_populates="scenario") edges: List["Edge"] = Relationship(back_populates="scenario") ways_modified: List["WayModified"] = Relationship(back_populates="scenario") nodes: List["Node"] = Relationship(back_populates="scenario")
class BuildingModified(BuildingBase, table=True): __tablename__ = "building_modified" __table_args__ = {"schema": "customer"} creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP")) ) building_id: Optional[int] = Field( sa_column=Column( Integer, ForeignKey("basic.building.id", ondelete="CASCADE"), default=None ), ) scenario_id: int = Field( sa_column=Column( Integer, ForeignKey("customer.scenario.id", ondelete="CASCADE"), index=True, nullable=False, ), ) population: Optional[float] = Field(sa_column=Column(Float(53))) building: Optional["Building"] = Relationship(back_populates="buildings_modified") scenario: "Scenario" = Relationship(back_populates="buildings_modified") populations_modified: Optional[List["PopulationModified"]] = Relationship( back_populates="building_modified" ) edit_type: str = Field(sa_column=Column(Text, nullable=False, index=True)) outdated: Optional[bool] = Field(sa_column=Column(Boolean, default=False))
class IsochroneCalculation(SQLModel, table=True): __tablename__ = "isochrone_calculation" __table_args__ = {"schema": "customer"} id: Optional[int] = Field( sa_column=Column(Integer, primary_key=True, autoincrement=True)) calculation_type: str = Field(sa_column=Column(Text, nullable=False)) starting_point: str = Field(sa_column=Column(Text, nullable=False)) routing_profile: str = Field(sa_column=Column(Text, nullable=False)) speed: float = Field(sa_column=Column(Float(53), nullable=False)) modus: str = Field(sa_column=Column(Text, nullable=False)) creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP"))) parent_id: Optional[int] = Field(sa_column=Column( Integer, ForeignKey("customer.isochrone_calculation.id", ondelete="CASCADE"))) scenario_id: Optional[int] = Field(sa_column=Column( Integer, ForeignKey("customer.scenario.id", ondelete="CASCADE"))) user_id: int = Field( sa_column=Column(Integer, ForeignKey("customer.user.id", ondelete="CASCADE"), nullable=False)) scenario: Optional["Scenario"] = Relationship( back_populates="isochrone_calculations") user: "******" = Relationship(back_populates="isochrone_calculations") isochrone_features: "IsochroneFeature" = Relationship( back_populates="isochrone_calculation")
class User(UserBase, table=True): __tablename__ = "user" __table_args__ = {"schema": "customer"} id: Optional[int] = Field( sa_column=Column(Integer, primary_key=True, autoincrement=True)) hashed_password: Optional[str] = Field( sa_column=Column(Text, nullable=False)) is_active: Optional[bool] = Field(default=False) newsletter: Optional[bool] = Field(default=False) occupation: Optional[str] = Field(sa_column=Column(Text, nullable=True)) domain: Optional[str] = Field(sa_column=Column(Text, nullable=True)) creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP"))) organization_id: int = Field(sa_column=Column( Integer, ForeignKey("customer.organization.id", ondelete="CASCADE"), nullable=False)) active_study_area_id: int = Field(sa_column=Column( Integer, ForeignKey("basic.study_area.id"), nullable=False)) language_preference: str = Field(sa_column=Column(Text, nullable=False)) organization: "Organization" = Relationship(back_populates="users") roles: List["Role"] = Relationship(back_populates="users", link_model=UserRole) scenarios: List["Scenario"] = Relationship(back_populates="user") study_areas: List["StudyArea"] = Relationship(back_populates="users", link_model=UserStudyArea) data_uploads: List["DataUpload"] = Relationship(back_populates="user") isochrone_calculations: List["IsochroneCalculation"] = Relationship( back_populates="user") user_customizations: List["UserCustomization"] = Relationship( back_populates="users") opportunity_user_configs: List["OpportunityUserConfig"] = Relationship( back_populates="user")
class UserCustomization(SQLModel, table=True): __tablename__ = "user_customization" __table_args__ = {"schema": "customer"} id: Optional[int] = Field(sa_column=Column(Integer, primary_key=True, autoincrement=True)) setting: dict = Field(sa_column=Column(JSONB, nullable=False)) creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP")) ) user_id: int = Field( sa_column=Column( Integer, ForeignKey("customer.user.id", ondelete="CASCADE"), nullable=False ) ) customization_id: int = Field( sa_column=Column( Integer, ForeignKey("customer.customization.id", ondelete="CASCADE"), nullable=False ) ) study_area_id: int = Field( sa_column=Column( Integer, ForeignKey("basic.study_area.id"), nullable=False ) ) customizations: "Customization" = Relationship(back_populates="user_customizations") users: "User" = Relationship(back_populates="user_customizations") study_areas: "StudyArea" = Relationship(back_populates="user_customizations")
class Organization(SQLModel, table=True): __tablename__ = "organization" __table_args__ = {"schema": "customer"} id: Optional[int] = Field(sa_column=Column(Integer, primary_key=True, autoincrement=True)) name: Optional[str] = Field(sa_column=Column(Text, nullable=False)) creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP")) ) users: List["User"] = Relationship(back_populates="organization")
class AoiModified(AoiBase, table=True): __tablename__ = "aoi_modified" __table_args__ = {"schema": "customer"} creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP"))) scenario_id: Optional[int] = Field(sa_column=Column( Integer, ForeignKey("customer.scenario.id", ondelete="CASCADE"), index=True)) scenario: Optional["Scenario"] = Relationship( back_populates="aois_modified")
class AoiUser(AoiBase, table=True): __tablename__ = "aoi_user" __table_args__ = {"schema": "customer"} creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP"))) data_upload_id: int = Field(sa_column=Column( Integer, ForeignKey("customer.data_upload.id", ondelete="CASCADE"), index=True, nullable=False, )) data_upload: Optional["DataUpload"] = Relationship( back_populates="aois_user")
class UserBase(SQLModel): name: str = Field(sa_column=Column(Text, nullable=False)) surname: str = Field(sa_column=Column(Text, nullable=False)) email: EmailStr = Field(sa_column=Column(Text, nullable=False)) organization_id: int = Field(sa_column=Column( Integer, ForeignKey("customer.organization.id", ondelete="CASCADE"), nullable=False)) active_study_area_id: int = Field(sa_column=Column( Integer, ForeignKey("basic.study_area.id"), nullable=False)) active_data_upload_ids: List[int] = Field( sa_column=Column(ARRAY(Integer()), server_default=text("'{}'::int[]"))) storage: int = Field(sa_column=Column(Integer), nullable=False) limit_scenarios: int = Field(sa_column=Column(Integer), nullable=False)
class UserStudyArea(SQLModel, table=True): __tablename__ = "user_study_area" __table_args__ = {"schema": "customer"} id: Optional[int] = Field( sa_column=Column(Integer, primary_key=True, autoincrement=True)) creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP"))) user_id: int = Field(sa_column=Column(Integer, ForeignKey("customer.user.id", ondelete="CASCADE"), nullable=False), ) study_area_id: int = Field( sa_column=Column(Integer, ForeignKey("basic.study_area.id", ondelete="CASCADE"), nullable=False))
class WayModified(EdgeBase, table=True): __tablename__ = "way_modified" __table_args__ = {"schema": "customer"} id: Optional[int] = Field(sa_column=Column(Integer, primary_key=True, autoincrement=True)) way_type: Optional[str] = Field(sa_column=Column(Text)) edit_type: Optional[str] = Field(sa_column=Column(Text)) creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP")) ) way_id: Optional[int] = Field(index=True, default=None, foreign_key="basic.edge.id") scenario_id: Optional[int] = Field( sa_column=Column( Integer, ForeignKey("customer.scenario.id", ondelete="CASCADE"), index=True ) ) outdated: Optional[bool] = Field(sa_column=Column(Boolean, default=False)) scenario: Optional["Scenario"] = Relationship(back_populates="ways_modified")
class PoiModified(PoiBase, table=True): __tablename__ = "poi_modified" __table_args__ = {"schema": "customer"} uid: str = Field(sa_column=Column(Text, nullable=False, index=True)) edit_type: str = Field(sa_column=Column(Text, nullable=False, index=True)) creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP"))) scenario_id: Optional[int] = Field(sa_column=Column( Integer, ForeignKey("customer.scenario.id", ondelete="CASCADE"), nullable=False, index=True), ) data_upload_id: Optional[int] = Field(sa_column=Column( Integer, ForeignKey("customer.data_upload.id", ondelete="CASCADE"), index=True), ) outdated: Optional[bool] = Field(sa_column=Column(Boolean, default=False)) scenario: Optional["Scenario"] = Relationship( back_populates="pois_modified")
class IsochroneFeature(SQLModel, table=True): __tablename__ = "isochrone_feature" __table_args__ = {"schema": "customer"} id: Optional[int] = Field( sa_column=Column(Integer, primary_key=True, autoincrement=True)) step: int = Field(nullable=False) reached_opportunities: Optional[dict] = Field( sa_column=Column(JSONB, server_default=text("1::jsonb"))) geom: str = Field(sa_column=Column( Geometry( geometry_type="MultiPolygon", srid="4326", spatial_index=False), nullable=False, )) isochrone_calculation_id: int = Field(sa_column=Column( Integer, ForeignKey("customer.isochrone_calculation.id", ondelete="CASCADE"), index=True, nullable=False, )) isochrone_calculation: "IsochroneCalculation" = Relationship( back_populates="isochrone_features")
class PopulationModified(PopulationBase, table=True): __tablename__ = "population_modified" __table_args__ = {"schema": "customer"} creation_date: Optional[datetime] = Field( sa_column=Column(DateTime, server_default=text("CURRENT_TIMESTAMP"))) building_modified_id: int = Field(sa_column=Column( Integer, ForeignKey("customer.building_modified.id", ondelete="CASCADE"), index=True, nullable=False, ), ) scenario_id: Optional[int] = Field(sa_column=Column( Integer, ForeignKey("customer.scenario.id", ondelete="CASCADE"), index=True, nullable=False, ), ) building_modified: "BuildingModified" = Relationship( back_populates="populations_modified") scenario: Optional["Scenario"] = Relationship( back_populates="populations_modified")