-- Orgs

CREATE TABLE orgs (
  id         BIGSERIAL PRIMARY KEY,
  name       VARCHAR     NOT NULL,
  title      VARCHAR     NOT NULL,
  created_at TIMESTAMPTZ NOT NULL DEFAULT now()
);

CREATE UNIQUE INDEX orgs_name_uniq
  ON orgs (lower(name));
