SQL ModelsΒΆ

CveXplore.database_models.models.Info (info)

Information about the time the last update was made to a db table.

Columns:

id*

INTEGER

ID of the record

db

VARCHAR(25)?

Database name

lastModified

DATETIME?

Last modified time

Constraints:

  • PRIMARY KEY (id)

CveXplore.database_models.models.Schema (schema)

Holds information about the current database schema.

Columns:

id*

INTEGER

ID of the record

rebuild_needed

BOOLEAN?

Flag to indicate if a rebuild is needed

version

FLOAT?

Version of the database schema

Constraints:

  • PRIMARY KEY (id)

CveXplore.database_models.models.Capec (capec)

CAPEC database table.

Columns:

id*

INTEGER

ID of the CAPEC

loa

VARCHAR(25)?

Likelihood Of Attack

name

VARCHAR(250)?

Name of the CAPEC

prerequisites

TEXT?

Prerequisites of the CAPEC

solutions

TEXT?

Solutions related to the CAPEC

summary

TEXT?

Summary of the CAPEC

typical_severity

VARCHAR(25)?

Typical severity of the CAPEC

execution_flow

JSON?

Execution flow of the CAPEC

related_capecs

JSON?

Related CAPECs

related_weakness

JSON?

Related weakness of the CAPEC

taxonomy

JSON?

Taxonomy of the CAPEC

Constraints:

  • PRIMARY KEY (id)

Indexes:

  • ix_capec_id (id)

  • ix_capec_loa (loa)

  • ix_capec_name (name)

  • ix_capec_typical_severity (typical_severity)

CveXplore.database_models.models.Cpe (cpe)

CPE database table.

Columns:

_id*

BIGINT

ID of the record

id*

VARCHAR(50)?

ID of the CPE

cpeName

VARCHAR(50)?

Name of the CPE

cpeNameId

VARCHAR(50)?

Unique ID number of the CPE

created

DATETIME?

Creation time of the CPE

deprecated

BOOLEAN?

Flag to indicate if a CPE is deprecated

deprecatedBy

VARCHAR(50)?

Organization that deprecated the CPE

lastModified

DATETIME?

Last modified time of the CPE

padded_version

VARCHAR(50)?

Left zero padded version of the CPE

product

VARCHAR(50)?

Product of the CPE

stem

VARCHAR(50)?

Stem of the CPE

title

VARCHAR(150)?

Title of the CPE

vendor

VARCHAR(50)?

Vendor of the CPE

version

VARCHAR(50)?

Version of the CPE

Constraints:

  • PRIMARY KEY (_id)

Indexes:

  • ix_cpe__id (_id)

  • ix_cpe_cpeName (cpeName)

  • ix_cpe_deprecated (deprecated)

  • ix_cpe_id (id)

  • ix_cpe_lastModified (lastModified)

  • ix_cpe_padded_version (padded_version)

  • ix_cpe_product (product)

  • ix_cpe_stem (stem)

  • ix_cpe_title (title)

  • ix_cpe_vendor (vendor)

CveXplore.database_models.models.Cves (cves)

CVE database table.

Columns:

_id*

BIGINT

ID of the record

id*

VARCHAR(50)?

ID of the CVE

access

JSON?

Access information of the CVE

assigner

VARCHAR(50)?

Organization name that assigned the CVE

cvss

FLOAT?

CVSS of the CVE

cvss3

FLOAT?

CVSS3 of the CVE

cvssSource

VARCHAR(50)?

Source of the CVSS of the CVE

cvssTime

DATETIME?

Time of the CVSS of the CVE

cvssVector

VARCHAR(100)?

Vector of the CVSS of the CVE

configurations

JSON?

Vulnerable configurations of the CVE

cwe

VARCHAR(50)?

Related CWEs to the CVE

epss

FLOAT?

Epss of the CVE

epssMetric

JSON?

Epss metric of the CVE

exploitabilityScore

FLOAT?

Exploitability Score of the CVE

impact

JSON?

Impact of the CVE

impactScore

FLOAT?

Impact score of the CVE

lastModified

DATETIME?

Last modified time of the CVE

modified

DATETIME?

Modified time of the CVE

products

JSON?

Related products to the CVE

published

DATETIME?

Published time of the CVE

references

JSON?

References associated to the CVE

status

VARCHAR(25)?

Status of the CVE

summary

TEXT?

Summary of the CVE

vendors

JSON?

Related vendors of the CVE

vulnerable_configuration

JSON?

Vulnerable configurations to the CVE

vulnerable_configuration_cpe_2_2

JSON?

Vulnerable configurations to the CVE

vulnerable_configuration_stems

JSON?

Vulnerable configuration stems to the CVE

vulnerable_product

JSON?

Vulnerable products to the CVE

vulnerable_product_stems

JSON?

Vulnerable product stems to the CVE

Constraints:

  • PRIMARY KEY (_id)

Indexes:

  • ix_cves__id (_id)

  • ix_cves_assigner (assigner)

  • ix_cves_cvss (cvss)

  • ix_cves_cvss3 (cvss3)

  • ix_cves_cwe (cwe)

  • ix_cves_epss (epss)

  • ix_cves_id (id)

  • ix_cves_lastModified (lastModified)

  • ix_cves_modified (modified)

  • ix_cves_published (published)

  • ix_cves_status (status)

CveXplore.database_models.models.Cwe (cwe)

CWE database table.

Columns:

id*

INTEGER

ID of the record

description

TEXT?

Description of the CWE

name

VARCHAR(250)?

Name of the CWE

status

VARCHAR(25)?

Status of the CWE

weaknessabs

VARCHAR(25)?

Weaknessabs of the CWE

related_weaknesses

JSON?

Related weaknesses to the CWE

Constraints:

  • PRIMARY KEY (id)

Indexes:

  • ix_cwe_id (id)

  • ix_cwe_name (name)

  • ix_cwe_status (status)

CveXplore.database_models.models.Via4 (via4)

VIA4 database table.

Columns:

_id*

INTEGER

ID of the record

id

VARCHAR(50)?

ID of the Via4

db

VARCHAR(25)?

Database name

searchables

JSON?

VIA4 searchables

sources

JSON?

VIA4 sources

msbulletin

JSON?

VIA4 msbulletin

redhat

JSON?

VIA4 redhat

refmap

JSON?

VIA4 refmap

Constraints:

  • PRIMARY KEY (_id)

Indexes:

  • ix_via4__id (_id)

  • ix_via4_id (id)

Last update: Aug 11, 2024