create table whitebox_report_findings
(
    id          bigint generated by default as identity primary key,
    task_id     bigint not null references tasks (id) on update cascade on delete cascade,
    asset_id    bigint references hosts (id) on update cascade on delete set null,
    vuln_id     text,
    description text,
    title       text,
    ref     jsonb       not null default '{}'::jsonb,
    add_info jsonb not null default '{}'::jsonb
);

create index whitebox_report_findings_vuln_id_idx
    on whitebox_report_findings (vuln_id);
