18 lines
726 B
SQL
18 lines
726 B
SQL
CREATE TABLE findings (
|
|
id TEXT PRIMARY KEY,
|
|
target_kind TEXT NOT NULL CHECK (target_kind IN ('os', 'image')),
|
|
target TEXT NOT NULL,
|
|
cve_id TEXT NOT NULL,
|
|
severity TEXT NOT NULL,
|
|
package TEXT NOT NULL,
|
|
installed_version TEXT NOT NULL,
|
|
fixed_version TEXT,
|
|
title TEXT NOT NULL,
|
|
url TEXT NOT NULL,
|
|
status TEXT NOT NULL CHECK (status IN ('open', 'acknowledged', 'fixed')),
|
|
first_seen TEXT NOT NULL,
|
|
last_seen TEXT NOT NULL
|
|
);
|
|
CREATE INDEX findings_target_status ON findings(target, status);
|
|
CREATE INDEX findings_status_severity ON findings(status, severity);
|