package_metadata

✎ View and edit SQL

This data as json

0 records

CREATE TABLE package_metadata (
  -- what package is this metadata for?
  --
  -- Foreign keys:
  -- - `renovate.package_name`
  -- - `sboms.package_name`
  package_name 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
  --
  -- This must be an exact match for the `package_type` in the given
  -- Datasource.
  --
  -- Foreign keys:
  -- - `renovate.package_type`
  -- - `sboms.package_type`
  package_type TEXT NOT NULL,

  -- repository_url indicates the discovered URL for the source repository this
  -- dependency lives at.
  --
  -- Sourced via Ecosystems (https://ecosyste.ms) and corresponds with the
  -- following fields from the Packages API:
  --
  -- - the string `$.repository_url`
  repository_url TEXT NOT NULL,

  UNIQUE (package_name, package_type) ON CONFLICT REPLACE
);