CREATE SCHEMA investigation;

CREATE TYPE investigation.danger_level AS ENUM (
    'low',
    'medium',
    'high',
    'critical',
    'unknown'
);

CREATE TABLE investigation.mirrored_reports
(
    id SERIAL PRIMARY KEY,
    target_id VARCHAR(255) NOT NULL,
    report_content VARCHAR(255) NOT NULL,
    report_date TIMESTAMP NOT NULL,
    on_case TEXT,
    danger_level investigation.danger_level DEFAULT 'unknown' NOT NULL
);