create table memberships (
  guid uuid not null,
  user ,
  organization ,
  role text not null,
  audit 
);
comment on table memberships is '
  A membership represents a user in a specific role to an organization. Memberships cannot be created directly. Instead you first create a membership request, then that request is either accepted or declined.
';

comment on column memberships.guid is '
  Internal unique identifier for this membership.
';
comment on column memberships.role is '
  The role this user plays for this organization. Typically member or admin.
';