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

     1  BEGIN;
     2  CREATE TABLE messages_data (
     3    seq        SERIAL   PRIMARY KEY,
     4    message_id UUID     NOT NULL REFERENCES messages(id),
     5    data_id    UUID     NOT NULL REFERENCES data(id),
     6    data_hash  CHAR(64) NOT NULL,
     7    data_idx   INT      NOT NULL
     8  );
     9  CREATE UNIQUE INDEX messages_data_idx ON messages_data(message_id, data_id);
    10  COMMIT;