Simple digram

[peterdudfield]

---
title: SQLAlchemy relationships
---
classDiagram

    class LocationSQL{
        + location_uuid : UUID ≪ PK ≫
        + client_location_id : Integer
        + client_location_name : String
        + latitude : Float
        + longitude : Float
        + capacity_kw : Float
        + ml_id : Integer ≪ U ≫
        + ml_model_uuid : UUID ≪ FK ≫
    }

    class GenerationSQL{
        + generation_uuid : UUID ≪ PK ≫
        + location_uuid : UUID ≪ FK ≫
        + generation_power_kw : Float
        + start_utc : DateTime
        + end_utc : DateTime
    }

    class ForecastSQL{
        + forecast_uuid : UUID ≪ PK ≫
        + location_uuid : UUID ≪ FK ≫
        + timestamp_utc : DateTime
        + forecast_version : String
    }

    class ForecastValueSQL{
        + forecast_value_uuid : UUID ≪ PK ≫
        + start_utc : DateTime
        + end_utc : DateTime
        + forecast_power_kw : Float
        + horizon_minutes : Integer
        + forecast_uuid : UUID ≪ FK ≫
    }

    class MLModelSQL{
        + uuid : UUID ≪ PK ≫
        + mode_name : String
        + model_version : UUID ≪ FK ≫
    }

    LocationSQL "1" -- "N" GenerationSQL : generates
    LocationSQL "1" -- "N" ForecastSQL : forecasts
    LocationSQL "N" -- "0" MLModelSQL : ml_model
    ForecastSQL "1" -- "N" ForecastValueSQL : contains

Loading