create table watches (
  guid uuid not null,
  user ,
  organization ,
  application ,
  audit 
);
comment on table watches is '
  Users can watch individual applications which enables features like receiving an email notification when there is a new version of an application.
';

comment on column watches.guid is '
  Internal unique identifier for this watch
';