src/main/resources/db/migration/postgresql/V0_1_0__Init.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

CREATE TABLE IF NOT EXISTS request
(
    id                  serial,
    uuid                varchar(255)                           not null unique,
    patient_id          varchar(255)                           not null,
    pid                 varchar(255)                           not null,
    fingerprint         varchar(255)                           not null,
    status              varchar(16)                            not null,
    processed_at        timestamp with time zone default now() not null,
    description         varchar(255)             default '',
    data_quality_report text                     default '',
    PRIMARY KEY (id)
);