Store derived `package_type` for Renovate packages
diff --git internal/datasources/renovate/db/schema.sql internal/datasources/renovate/db/schema.sql
index ad7b84c..49443c2 100644
--- internal/datasources/renovate/db/schema.sql
+++ internal/datasources/renovate/db/schema.sql
@@ -76,6 +76,15 @@ CREATE TABLE IF NOT EXISTS renovate (
-- build/Dockerfile
package_file_path TEXT NOT NULL,
+ -- package_type most commonly relates to the "Type" field of a Package URL
+ -- (as defined by https://github.com/package-url/purl-spec), which may be a
+ -- package ecosystem or package manager type
+ --
+ -- NOTE this is derived by dependency-management-data, and will not always be
+ -- correct. Please raise an issue if you encounter any `package_type`s that
+ -- do not seem correct.
+ package_type TEXT NOT NULL,
+
-- datasource indicates the datasource that the dependency has been sourced
-- from, which corresponds to Renovate's datasources
-- (https://docs.renovatebot.com/modules/datasource/).
As a step towards consistency, and interplay across different ecosystems, as well as (..... TODO ....)
Edited by Jamie Tanna