hasura_pipeline_demo_db.sql

CREATE USER hasurauser WITH PASSWORD 'hasurapwd';

-- for demo purposes, see below for production:
-- https://hasura.io/docs/latest/graphql/core/deployment/postgres-requirements.html
ALTER USER hasurauser WITH SUPERUSER;

CREATE DATABASE pipelinedemo WITH OWNER hasurauser;

\c pipelinedemo

CREATE TABLE samples (
  id INT PRIMARY KEY,
  name TEXT NOT NULL
);

CREATE TABLE runs (
  id INT PRIMARY KEY,
  started_at TIMESTAMP NOT NULL
);

CREATE TABLE sample_runs (
  sample_id INT REFERENCES samples(id),
  run_id INT REFERENCES runs(id),
  qc_score INT,
  duplication_rate REAL,
  PRIMARY KEY(sample_id,run_id)
);