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 Components"]
        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_category"| WasteCategory
        Collection -->|"frequency"| CollectionFrequency
        Collection -->|"fee_system"| FeeSystem
        Collector -->|"catchment"| CollectionCatchment
        CollectionPropertyValue -->|"collection"| Collection
        CollectionCountOptions -->|"frequency"| CollectionFrequency
        CollectionCountOptions -->|"season"| CollectionSeason

        %% ---- M2M relationships (dashed) ----
        Collection -.-|"flyers"| WasteFlyer
        Collection -.-|"samples"| Sample_ext["Sample (ext)"]
        Collection -.-|"predecessors"| Collection
        Collection -.-|"allowed_materials"| WasteComponent
        Collection -.-|"forbidden_materials"| WasteComponent
        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 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