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