erDiagram
    InvoiceLineItem {
        int InvoiceLineNumber
        varchar Supplier_root_id
        varchar Part_root_Id
        varchar UNSPSC_root_Id
        decimal POAmount_Amount
        varchar SourceSystem
    }
    
    Part {
        varchar RootId
        int product_id
    }

    Supplier {
        varchar RootId
        int SupplierId
        varchar SupplierName
    }

    UNSPSC {
        varchar RootId
        varchar CategoryL3
    }

    EmissionBySupplier {
        int SFM_ID
        int Product_id
        int Supplier_id
    }

    InvoiceLineItem ||--|| Part: "Part_root_Id = RootId"
    InvoiceLineItem ||--|| Supplier: "Supplier_root_id = RootId"
    InvoiceLineItem ||--|| UNSPSC: "UNSPSC_root_Id = RootId"
    Part ||--|| EmissionBySupplier: "product_id = Product_id"
    Supplier ||--|| EmissionBySupplier: "SupplierId = Supplier_id"