Untitled

@startuml
!theme reddress-lightblue
'left to right direction

entity "Input_Agea" {
  =ID_APPE_DETT : [PK]
  ---
   ID_PCG_VERS 
   ID_APPE 
   ID_INTE  
   CUAA 
  -SUPE_DETT
  -ID_ORPA 
  -ANNO_CAMP
  -CODI_OCCU
  -CODI_DEST_USO
  -CODI_USOO
  -CODI_QUAL
  -CODI_OCCU_VARI
  -CODI_CLAS
  -SIGLA_PROV
  -SHAPE_APPE
  +TILES
}


entity "tiles_bbox" {
  =name : [PK]
  ---
  +geom 
}

entity "AGEA_Marker_YYYY" {
  
    event
    zone
    -marker
    min
    max
    +ID_ORPA
    +ANNO_CAMP
    dtime
    perc
    data
    extra1
    gg_consecutivi
    +CODI_CLAS
    finestra
    -dts
    -dte
    extra2
}

entity "zonal_statistcs" {
    =ID_APPE_DETT
    ---
    +ID_ORPA
    +SUPE_DETT
    +ANNO_CAMP
    +CODI_OCCU
    +CODI_DEST_USO
    +CODI_USOO
    +CODI_QUAL
    +CODI_OCCU_VARI
    +CODI_CLAS
    +SIGLA_PROV
    +TILES
    +data : [ARRAY]
    +count : [ARRAY]
    +mean : [ARRAY]
    +median : [ARRAY]
    +stdev : [ARRAY]
    
}
entity "Output" {
    =ID_APPE_DETT : [PK]
    ---
    +id_inte : [ARRAY]
    +marker : [ARRAY]
    +esito : [ARRAY]
    +dts : [ARRAY]
    +dte : [ARRAY]
    +data : [ARRAY]
}


entity "Python_Statistcs"{
    =TILES
    ---
    +SHAPE_APPE
    -count : [ARRAY]
    -mean : [ARRAY]
    -median : [ARRAY]
    -stdev : [ARRAY]
    -data : [ARRAY]
}

' Relazione fra le colonne -----------------------------------
Input_Agea::SHAPE_APPE --> tiles_bbox::geom  : intersect


Input_Agea::TILES -> Python_Statistcs::TILES #blue
Input_Agea::SHAPE_APPE -> Python_Statistcs::SHAPE_APPE #blue

AGEA_Marker_YYYY::dts  --> Output::dts : popolamento 
AGEA_Marker_YYYY::dte  --> Output::dte : popolamento 
AGEA_Marker_YYYY::marker  --> Output::marker : popolamento 

Input_Agea::ID_APPE_DETT  --> zonal_statistcs::ID_APPE_DETT #purple
Input_Agea::SUPE_DETT --> zonal_statistcs::SUPE_DETT
Input_Agea::ID_ORPA --> zonal_statistcs::ID_ORPA
Input_Agea::ANNO_CAMP --> zonal_statistcs::ANNO_CAMP
Input_Agea::CODI_OCCU --> zonal_statistcs::CODI_OCCU
Input_Agea::CODI_DEST_USO --> zonal_statistcs::CODI_DEST_USO
Input_Agea::CODI_USOO -> zonal_statistcs::CODI_USOO 
Input_Agea::CODI_QUAL --> zonal_statistcs::CODI_QUAL 
Input_Agea::CODI_OCCU_VARI --> zonal_statistcs::CODI_OCCU_VARI  
Input_Agea::CODI_CLAS --> zonal_statistcs::CODI_CLAS 
Input_Agea::SIGLA_PROV --> zonal_statistcs::SIGLA_PROV 
Input_Agea::TILES --> zonal_statistcs::TILES 

zonal_statistcs::CODI_CLAS  -> AGEA_Marker_YYYY::CODI_CLAS 
zonal_statistcs::mean   -> AGEA_Marker_YYYY::extra1 
zonal_statistcs::ANNO_CAMP  -> AGEA_Marker_YYYY::ANNO_CAMP 
zonal_statistcs::ID_ORPA   -> AGEA_Marker_YYYY::ID_ORPA 
zonal_statistcs::ID_APPE_DETT --> Output::ID_APPE_DETT #purple

AGEA_Marker_YYYY::extra1  --> Output::esito #green :restituisce \n multipli \n esiti

Python_Statistcs::count -r-> zonal_statistcs::count #red
Python_Statistcs::mean -r-> zonal_statistcs::mean #red
Python_Statistcs::median -r-> zonal_statistcs::median #red
Python_Statistcs::stdev -r-> zonal_statistcs::stdev #red
Python_Statistcs::data -r-> zonal_statistcs::data #red

tiles_bbox::name --> Input_Agea::TILES :restituisce

@enduml