create table memberships (
  id text not null,
  user ,
  organization ,
  role text references roles not null
);
comment on table memberships is '
  A user can belong to one or more organizations via memberships.
';

comment on column memberships.id is '
  Unique identifier for this membership
';