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

     1  BEGIN;
     2  CREATE TABLE operations (
     3    seq         SERIAL          PRIMARY KEY,
     4    id          UUID            NOT NULL,
     5    tx_id       UUID            NOT NULL,
     6    optype      VARCHAR(64)     NOT NULL,
     7    opstatus    VARCHAR(64)     NOT NULL,
     8    member   VARCHAR(1024),
     9    plugin      VARCHAR(64)     NOT NULL,
    10    backend_id  VARCHAR(256)    NOT NULL,
    11    created     BIGINT          NOT NULL,
    12    updated     BIGINT,
    13    error       VARCHAR         NOT NULL,
    14    info        BYTEA
    15  );
    16  
    17  CREATE UNIQUE INDEX operations_id ON operations(id);
    18  CREATE INDEX operations_created ON operations(created);
    19  CREATE INDEX operations_backend ON operations(backend_id);
    20  
    21  COMMIT;