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

     1  BEGIN;
     2  CREATE TABLE orgs (
     3    seq            SERIAL          PRIMARY KEY,
     4    id             UUID            NOT NULL,
     5    message_id     UUID            NOT NULL,
     6    name           VARCHAR(64)     NOT NULL,
     7    parent         VARCHAR(1024),
     8    identity       VARCHAR(1024)   NOT NULL,
     9    description    VARCHAR(4096)   NOT NULL,
    10    profile        BYTEA,
    11    created        BIGINT          NOT NULL
    12  );
    13  
    14  CREATE UNIQUE INDEX orgs_id ON orgs(id);
    15  CREATE UNIQUE INDEX orgs_identity ON orgs(identity);
    16  CREATE UNIQUE INDEX orgs_name ON orgs(name);
    17  
    18  COMMIT;