Environmental Profiles

digraph model_graph { // Dotfile by Django-Extensions graph_models // Created: 2025-01-28 09:42 // Cli Options: --output ./source/logical-data-model/profiles.dot profiles --exclude-models ModelBase --rankdir BT --group-models --disable-sort-fields --theme=nmd fontname = "Helvetica" fontsize = 18 splines = true rankdir = "TB" newrank = true ranksep = 1 colorscheme = "greens9" size = 500 label = <<B>Logical Data Model</B>> labelloc = "t" splines = true rankdir = "BT" node [ colorscheme = "greens9" fontname = "Helvetica" fontsize = 8 shape = "plaintext" labelloc = "c" width = 2.5 color = 9 fillcolor = 3 ] edge [ fontname = "Helvetica" fontsize = 8 arrowhead = normal arrowtail = none headport = "_" tailport = "_" arrowhead = none; labeldistance = 1.5; labelangle = -45; ] // Labels subgraph cluster_profiles { label = "profiles"; fontsize = 12; color = 1; style = "filled"; colorscheme = "greens9"; labelloc="t"; profiles_models_EnvironmentalProfile [label=<<TABLE BGCOLOR="#FFFFFF" BORDER="1" BORDERCOLOR="#00441b" CELLBORDER="0" CELLSPACING="0" WIDTH="200"><TR><TD COLSPAN="2" CELLPADDING="5" ALIGN="CENTER" BGCOLOR="#c7e9c0" WIDTH="100%"><FONT FACE="Helvetica" COLOR="#000" POINT-SIZE="10"><B>EnvironmentalProfile</B></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><I><B><FONT>id</FONT></B></I></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><I><B><FONT>UUIDField</FONT></B></I></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><I><FONT>created_at</FONT></I></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><I><FONT>DateTimeField</FONT></I></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><I><FONT>updated_at</FONT></I></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><I><FONT>DateTimeField</FONT></I></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><B><FONT>environmental_declaration</FONT></B></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><B><FONT>ForeignKey (id)</FONT></B></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><FONT>title</FONT></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><FONT>CharField</FONT></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><FONT>amount</FONT></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><FONT>FloatField</FONT></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><FONT>code</FONT></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><FONT>CharField</FONT></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><FONT>order</FONT></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><FONT>PositiveIntegerField</FONT></FONT></TD></TR></TABLE>>] profiles_models_EnvironmentalData [label=<<TABLE BGCOLOR="#FFFFFF" BORDER="1" BORDERCOLOR="#00441b" CELLBORDER="0" CELLSPACING="0" WIDTH="200"><TR><TD COLSPAN="2" CELLPADDING="5" ALIGN="CENTER" BGCOLOR="#c7e9c0" WIDTH="100%"><FONT FACE="Helvetica" COLOR="#000" POINT-SIZE="10"><B>EnvironmentalData</B></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><I><B><FONT>id</FONT></B></I></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><I><B><FONT>UUIDField</FONT></B></I></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><I><FONT>created_at</FONT></I></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><I><FONT>DateTimeField</FONT></I></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><I><FONT>updated_at</FONT></I></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><I><FONT>DateTimeField</FONT></I></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><B><FONT>environmental_profile</FONT></B></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><B><FONT>ForeignKey (id)</FONT></B></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><B><FONT>assessment_strategy</FONT></B></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT FACE="Helvetica"><B><FONT>ForeignKey (id)</FONT></B></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><FONT>score_file</FONT></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><FONT>ProtectedFileField</FONT></FONT></TD></TR><TR><TD ALIGN="LEFT" BORDER="0" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><FONT>scores</FONT></FONT></TD><TD ALIGN="LEFT" WIDTH="100" CELLPADDING="2"><FONT COLOR="#7B7B7B" FACE="Helvetica"><FONT>ArrayField</FONT></FONT></TD></TR></TABLE>>] } // Relations registry_models_EnvironmentalDeclaration [label=< <TABLE BGCOLOR="#fdd0a2" BORDER="0" BORDERCOLOR="#7f2704" CELLBORDER="0" CELLSPACING="0"> <TR><TD COLSPAN="2" CELLPADDING="4" ALIGN="CENTER" BGCOLOR="#fdd0a2"> <FONT FACE="Helvetica" POINT-SIZE="12" COLOR="#000">EnvironmentalDeclaration</FONT> </TD></TR> </TABLE> >] profiles_models_EnvironmentalProfile -> registry_models_EnvironmentalDeclaration [label=" environmental_declaration (environmental_profiles)"] [arrowhead=none, arrowtail=none, taillabel="0..n", headlabel="1" dir=both]; profiles_models_EnvironmentalData -> profiles_models_EnvironmentalProfile [label=" environmental_profile (environmental_data)"] [arrowhead=none, arrowtail=none, taillabel="0..n", headlabel="1" dir=both]; assessment_strategies_models_AssessmentStrategy [label=< <TABLE BGCOLOR="#fdd0a2" BORDER="0" BORDERCOLOR="#7f2704" CELLBORDER="0" CELLSPACING="0"> <TR><TD COLSPAN="2" CELLPADDING="4" ALIGN="CENTER" BGCOLOR="#fdd0a2"> <FONT FACE="Helvetica" POINT-SIZE="12" COLOR="#000">AssessmentStrategy</FONT> </TD></TR> </TABLE> >] profiles_models_EnvironmentalData -> assessment_strategies_models_AssessmentStrategy [label=" assessment_strategy (environmental_data)"] [arrowhead=none, arrowtail=none, taillabel="0..n", headlabel="1" dir=both]; }

Fig. 7 Schematic overview of logical data model for Environmental Profiles

class profiles.models.EnvironmentalData(*args, **kwargs)

Please refer to the conceptual model on Environmental Data.

Parameters
  • id (UUIDField) – Primary key: Id

  • created_at (DateTimeField) – Created at

  • updated_at (DateTimeField) – Updated at

  • score_file (ProtectedFileField) – Score file. This is the PSS file (.xlxs)

  • scores (ArrayField) – Scores

Relationship fields:

Parameters

Reverse relationships:

Parameters

legacyenvironmentaldata (Reverse OneToOneField from LegacyEnvironmentalData) – The legacy environmental data of this Profile data (related name of environmentaldata_ptr)

class profiles.models.EnvironmentalProfile(*args, **kwargs)

Please refer to the conceptual model on Environmental Profile.

Parameters

Relationship fields:

Parameters

environmental_declaration (ForeignKey to EnvironmentalDeclaration) – Environmental declaration (related name: environmental_profiles)

Reverse relationships:

Parameters
  • legacyenvironmentalprofile (Reverse OneToOneField from LegacyEnvironmentalProfile) – The legacy environmental profile of this Environmental Profile (related name of environmentalprofile_ptr)

  • environmental_data (Reverse ForeignKey from EnvironmentalData) – All environmental data of this Environmental Profile (related name of environmental_profile)

  • scaling (Reverse OneToOneField from Scaling) – The scaling of this Environmental Profile (related name of environmental_profile)