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

     1  BEGIN;
     2  CREATE TABLE batches (
     3    seq         SERIAL          PRIMARY KEY,
     4    id          UUID            NOT NULL,
     5    btype       VARCHAR(64)     NOT NULL,
     6    namespace   VARCHAR(64)     NOT NULL,
     7    author      VARCHAR(1024)   NOT NULL,
     8    group_hash  CHAR(64),
     9    hash        CHAR(64),
    10    created     BIGINT          NOT NULL,
    11    payload     BYTEA           NOT NULL,
    12    payload_ref CHAR(64),
    13    confirmed   BIGINT,
    14    tx_type     VARCHAR(64)     NOT NULL,
    15    tx_id       UUID
    16  );
    17  
    18  CREATE UNIQUE INDEX batches_id ON batches(id);
    19  CREATE INDEX batches_created ON batches(namespace,created);
    20  CREATE INDEX batches_fortx ON batches(namespace,tx_id);
    21  COMMIT;