20210422.node_edges.sql

CREATE SCHEMA IF NOT EXISTS playground;

DROP TABLE IF EXISTS playground.edges;
DROP TABLE IF EXISTS playground.nodes;

CREATE TABLE playground.nodes
(
    id SERIAL PRIMARY KEY,
    node_name VARCHAR(10) NOT NULL
);

CREATE TABLE playground.edges
(
    id SERIAL PRIMARY KEY,
    from_node_id INTEGER NOT NULL REFERENCES playground.nodes(id),
    to_node_id INTEGER NOT NULL REFERENCES playground.nodes(id),
    type VARCHAR(20) NOT NULL
);