create table subscriptions (
  guid uuid not null,
  organization ,
  user ,
  publication text references publications not null,
  audit 
);
comment on table subscriptions is '
  Represents a user that is currently subscribed to a publication
';

comment on column subscriptions.guid is '
  Internal unique identifier for this subscription record
';