rushs/data-clash/step-1/mirroring.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

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
);