Bioresource Information Tool

Waste Collection Module — Model Diagram

Click on any highlighted model to open its list view.

Back to Explorer
Browsable model (click to open) Internal model Foreign key Many-to-many 
%%{init: {'securityLevel': 'loose', 'theme': 'default', 'flowchart': {'curve': 'basis', 'nodeSpacing': 30, 'rankSpacing': 60}}}%%
flowchart TD

    subgraph core["Collections & Geography"]
        Collection["Collection"]
        CollectionCatchment["CollectionCatchment"]
        Collector["Collector"]
    end

    subgraph config["Classification & Configuration"]
        WasteCategory["WasteCategory"]
        CollectionSystem["CollectionSystem"]
        FeeSystem["FeeSystem"]
        CollectionFrequency["CollectionFrequency"]
    end

    subgraph streams["Waste Streams & Components"]
        WasteStream["WasteStream"]
        WasteComponent["WasteComponent"]
    end

    subgraph sources["Sources & Data"]
        WasteFlyer["WasteFlyer"]
        CollectionPropertyValue["CollectionPropertyValue"]
        AggCollPropValue["AggregatedCollection\nPropertyValue"]
    end

    subgraph scheduling["Scheduling"]
        CollectionSeason["CollectionSeason"]
        CollectionCountOptions["CollectionCountOptions"]
    end

    %% ---- FK relationships (solid) ----
    Collection -->|"collector"| Collector
    Collection -->|"catchment"| CollectionCatchment
    Collection -->|"collection_system"| CollectionSystem
    Collection -->|"waste_stream"| WasteStream
    Collection -->|"frequency"| CollectionFrequency
    Collection -->|"fee_system"| FeeSystem
    Collector -->|"catchment"| CollectionCatchment
    WasteStream -->|"category"| WasteCategory
    CollectionPropertyValue -->|"collection"| Collection
    CollectionCountOptions -->|"frequency"| CollectionFrequency
    CollectionCountOptions -->|"season"| CollectionSeason

    %% ---- M2M relationships (dashed) ----
    Collection -.-|"flyers"| WasteFlyer
    Collection -.-|"samples"| Sample_ext["Sample (ext)"]
    Collection -.-|"predecessors"| Collection
    WasteStream -.-|"allowed_materials"| WasteComponent
    WasteStream -.-|"forbidden_materials"| WasteComponent
    WasteStream -.-|"composition"| SampleSeries_ext["SampleSeries (ext)"]
    AggCollPropValue -.-|"collections"| Collection

    %% ---- Styling ----
    classDef clickable fill:#dbeafe,stroke:#1e40af,stroke-width:2px,color:#1e3a5f
    classDef internal fill:#f3f4f6,stroke:#9ca3af,stroke-width:1px,color:#4b5563
    classDef external fill:#fef9c3,stroke:#ca8a04,stroke-width:1px,color:#713f12,font-style:italic

    class Collection,CollectionCatchment,Collector clickable
    class WasteCategory,CollectionSystem,FeeSystem,CollectionFrequency clickable
    class WasteComponent,WasteFlyer clickable
    class WasteStream,CollectionSeason,CollectionCountOptions,CollectionPropertyValue,AggCollPropValue internal
    class Sample_ext,SampleSeries_ext external

    %% ---- Click handlers ----
    click Collection href "/waste_collection/collections/" _self
    click CollectionCatchment href "/waste_collection/catchments/" _self
    click Collector href "/waste_collection/collectors/" _self
    click WasteCategory href "/waste_collection/wastecategories/" _self
    click CollectionSystem href "/waste_collection/collectionsystems/" _self
    click FeeSystem href "/waste_collection/feesystems/" _self
    click CollectionFrequency href "/waste_collection/frequencies/" _self
    click WasteComponent href "/waste_collection/wastecomponents/" _self
    click WasteFlyer href "/waste_collection/flyers/" _self