SCA3

Tables (13)

Untitled (sca_file_hash)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (file_id) — bigint — Foreign key → files.Key — NOT NULL
  • Field (algorithm) — varchar(10) — NOT NULL
  • Field (value) — varchar(300) — NOT NULL
  • Field (arch) — varchar(20)

Untitled (sca_software_desc)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (software_id) — bigint — Foreign key → oss.Key — NOT NULL
  • Field (lang) — varchar(2) — NOT NULL
  • Field (desc) — text — NOT NULL

Untitled (sca_vuln_desc)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (vuln_id) — bigint — Foreign key → cve.Key — NOT NULL
  • Field (lang) — varchar(2) — NOT NULL
  • Field (desc) — text — NOT NULL

Untitled (sca_software_vendor)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (software_id) — bigint — Foreign key → oss.Key — NOT NULL
  • Field (vendor) — varchar(100) — NOT NULL

Untitled (sca_software_repository)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (software_id) — bigint — Foreign key → oss.Key — NOT NULL
  • Field (repository) — varchar(500) — NOT NULL

cve (sca_vuln)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (type) — varchar(200) — NOT NULL
  • Field (key) — varchar(200) — NOT NULL
  • severity — int
  • publishedDate (published_date) — timestamp — NOT NULL
  • modifiedDate (modified_date) — timestamp
  • cwe (cweid) — varchar(20)
  • cvss3 — int — CVSS Structure Start
  • cvss2 — int
  • attackVector (attack_vector) — varchar(50)
  • attackComplexity (attack_complexity) — varchar(50)
  • privilegesRequired (privileges_required) — varchar(50)
  • userInteraction (user_interaction) — varchar(50)
  • scopes (scope) — varchar(50)
  • confidentialityImpact (confidentiality_impact) — varchar(50)
  • integrityImpact (integrity_impact) — varchar(50)
  • availabilityImpact (availability_impact) — varchar(50) — CVSS Structure End
  • Field (vuln_url) — varchar(300)

cveReferences (sca_vuln_reference)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (vuln_id) — bigint — Foreign key → cve.Key — NOT NULL
  • Field (url) — text — NOT NULL

files (sca_file)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (version_id) — bigint — Foreign key → versions.Key — NOT NULL
  • name — varchar(300) — NOT NULL

license (sca_license)

  • Key (id) — bigint — Primary key — NOT NULL
  • copyright — text
  • Field (name) — varchar(300) — NOT NULL

machedLicense (sca_version_license)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (version_id) — bigint — Foreign key → versions.Key — NOT NULL
  • Key (license_id) — bigint — Foreign key → license.Key — NOT NULL

oss (sca_software)

  • Key (id) — bigint — Primary key — NOT NULL
  • ossName (name) — varchar(300) — NOT NULL
  • Field (group_id) — varchar(300)
  • Field (artifact_id) — varchar(300)
  • Field (classifier_extension) — varchar(10)
  • Field (package) — varchar(20)
  • Field (arch) — varchar(20)
  • Field (lang) — varchar(10)
  • Field (lang_version) — varchar(20)

versions (sca_version)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (software_id) — bigint — Foreign key → oss.Key — NOT NULL
  • date — timestamp
  • Field (version) — varchar(100) — NOT NULL

vulnerabilities (sca_vuln_version)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (version_id) — bigint — Foreign key → versions.Key — NOT NULL
  • Key (vuln_id) — bigint — Foreign key → cve.Key — NOT NULL