github.com/kaleido-io/firefly@v0.0.0-20210622132723-8b4b6aacb971/db/migrations/postgres/000014_create_nodes_table.up.sql (about)

     1  BEGIN;
     2  CREATE TABLE nodes (
     3    seq            SERIAL          PRIMARY KEY,
     4    id             UUID            NOT NULL,  
     5    message_id     UUID            NOT NULL,
     6    owner          VARCHAR(1024)   NOT NULL,
     7    name           VARCHAR(64)     NOT NULL,
     8    description    VARCHAR(4096)   NOT NULL,
     9    dx_peer        VARCHAR(256),
    10    dx_endpoint    BYTEA,
    11    created        BIGINT          NOT NULL
    12  );
    13  
    14  CREATE UNIQUE INDEX nodes_id ON nodes(id);
    15  CREATE UNIQUE INDEX nodes_owner ON nodes(owner,name);
    16  CREATE UNIQUE INDEX nodes_peer ON nodes(dx_peer);
    17  
    18  COMMIT;