depsdev_deprecated

140 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: package_type, updated_at, updated_at (date)

Next page

CREATE TABLE depsdev_deprecated (
  -- the package that this deprecation covers
  --
  -- Foreign keys:
  -- - `renovate.package_name`
  -- - `sboms.package_name`
  package_name TEXT NOT NULL,
  -- version is the exact version of this package that this deprecation applies
  -- to.
  --
  -- For example:
  --   1.2.3
  --   v5.6.7-somelonghash
  --
  -- Foreign keys:
  -- - `renovate.current_version`
  -- - `sboms.current_version`
  version 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
  --
  -- Foreign keys:
  -- - `renovate.package_type`
  -- - `sboms.package_type`
  package_type TEXT NOT NULL,

  -- is_deprecated is whether the package is marked as deprecated
  is_deprecated BOOLEAN NOT NULL,

  -- updated_at indicates when this deprecation was last updated in
  -- dependency-management-data, not when the deprecation was last updated
  updated_at TEXT NOT NULL,

  UNIQUE (package_name, package_type, version) ON CONFLICT REPLACE
);