SCA4
Tables (12)
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_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)
- Field (vendor) — varchar(100)
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