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

     1  CREATE TABLE transactions (
     2    id          string   NOT NULL,
     3    ttype       string   NOT NULL,
     4    namespace   string   NOT NULL,
     5    ref         string,
     6    signer      string   NOT NULL,
     7    hash        string   NOT NULL,
     8    created     int64    NOT NULL,
     9    protocol_id string,
    10    status      string   NOT NULL,
    11    info        blob
    12  );
    13  
    14  CREATE UNIQUE INDEX transactions_primary ON transactions(id);
    15  CREATE INDEX transactions_created ON transactions(created);
    16  CREATE INDEX transactions_protocol_id ON transactions(protocol_id);
    17  CREATE INDEX transactions_ref ON transactions(ref);
    18