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

     1  BEGIN;
     2  CREATE TABLE transactions (
     3    seq         SERIAL          PRIMARY KEY,
     4    id          UUID            NOT NULL,
     5    ttype       VARCHAR(64)     NOT NULL,
     6    namespace   VARCHAR(64)     NOT NULL,
     7    ref         UUID,
     8    signer      VARCHAR(1024)   NOT NULL,
     9    hash        CHAR(64)        NOT NULL,
    10    created     BIGINT          NOT NULL,
    11    protocol_id VARCHAR(256),
    12    status      VARCHAR(64)     NOT NULL,
    13    info        JSONB
    14  );
    15  
    16  CREATE UNIQUE INDEX transactions_id ON data(id);
    17  CREATE INDEX transactions_created ON transactions(created);
    18  CREATE INDEX transactions_protocol_id ON transactions(protocol_id);
    19  CREATE INDEX transactions_ref ON transactions(ref);
    20  COMMIT;