create table membership_requests (
  guid uuid not null,
  user ,
  organization ,
  role text not null,
  audit 
);
comment on table membership_requests is '
  A membership request represents a user requesting to join an organization with a specific role (e.g. as a member or an admin). Membership requests can be reviewed by any current admin of the organization who can either accept or decline the request.
';

comment on column membership_requests.guid is '
  Internal unique identifier for this membership request.
';
comment on column membership_requests.role is '
  The requested role for membership to this organization. Typically member or admin.
';