· 7 years ago · Feb 04, 2019, 10:16 AM
1create table IF NOT EXISTS vulntable (
2 id serial PRIMARY KEY,
3 cve varchar(16),
4 identifier json,
5 vendor varchar(50),
6 product varchar(50),
7 version varchar(50),
8 release_product varchar(50),
9 update_product varchar(50),
10 description json,
11 discovery_date date,
12 type varchar(100),
13 cwe int,
14 cvssv3 numeric(4,2),
15 cvssvector varchar(50),
16 proof json,
17 exploit json,
18 recomendation varchar(2048),
19 status varchar(10) check (status in ('NEW', 'EMPTY', 'CLOSE', 'OPEN', 'PUBLIC', '0DAY')),
20 ts TIMESTAMP,
21 read_ts TIMESTAMP
22);