zsNzHZ5T

1CREATE TABLE IF NOT EXISTS instrument (
2    id SERIAL PRIMARY KEY NOT NULL,
3    active BOOLEAN NOT NULL DEFAULT TRUE,
4    name VARCHAR(64) NOT NULL,
5    figi VARCHAR(32) NOT NULL UNIQUE,
6    isin VARCHAR(32) NOT NULL,
7    type VARCHAR(2) NOT NULL,
8    invariant JSONB NOT NULL
9);
10
11CREATE TABLE IF NOT EXISTS instrument_ts (
12    instrument_fk INTEGER REFERENCES instrument (id) NOT NULL,
13    bdate DATE NOT NULL,
14    raw JSONB NOT NULL,
15    mapped JSONB NOT NULL,
16    PRIMARY KEY (instrument_fk, bdate)
17);