Component table (component)

Column Type Description
channel_release_external_namespace text The origin namespace for the component.
component_id UUID Component ID.
component_name text Component name.
component_version_id UUID Component version ID.
component_version_name text Component version name.
created_at timestamptz

The created at time for the component, copied from the BOM.

Represents the first time the component was added to the BOM.
id int8 ID.
ignored boolean

Indicates whether the component is ignored:

  • "t" indicates that the component is ignored.

  • "f" indicates that the component is not ignored.
license_high_count numeric Number of high license risk.
license_low_count numeric Number of low license risk.
license_medium_count numeric Number of medium license risk.
license_ok_count numeric Number of no license risk.
operational_high_count numeric Number of high operational risk.
operational_medium_count numeric Number of medium operation risk.
operational_low_count numeric Number of low operational risk.
operational_ok_count numeric Number of no operational risk.
origin_id text

Origin ID.

Note that origin ID is blank if the component does not have a distribution.
origin_name text Name of the distribution (origin).
policy_approval_status text

One of the following values:

  • IN_VIOLATION

  • NOT_IN_VIOLATION

  • IN_VIOLATION_OVERRIDDEN
project_version_id UUID Project version ID.
purl text The package URL.
review_status text Review status of the component. Possible values are:

  • UNREVIEWED

  • IN_REVIEW

  • REVIEWED

  • APPROVED

  • LIMITED_APPROVAL

  • REJECTED

  • DEPRECATED
reviewed_by UUID User who reviewed the component.
reviewed_on timestamp in UTC

When the component was reviewed.
security_critical_count numeric Number of critical security vulnerabilities.
security_high_count numeric Number of high security vulnerabilities.
security_medium_count numeric Number of medium security vulnerabilities.
security_low_count numeric Number of low security vulnerabilities.
security_ok_count numeric Number of no security vulnerabilities.
updated_at timestamptz

The updated at time for the component, copied from the BOM.

Represents the most recent time that component was updated in its BOM.
version_origin_id UUID Version origin ID.