create table applications (
  guid uuid not null,
  organization ,
  name text not null,
  key text not null,
  visibility text references visibilities not null,
  description text,
  audit 
);
comment on table applications is '
  An application has a name and multiple versions of its API.
';

comment on column applications.guid is '
  Internal unique identifier for this application.
';
comment on column applications.name is '
  The unique name for this application.
';
comment on column applications.key is '
  Used as a unique key in the URL path. Key is automatically derived from the application name.
';
comment on column applications.visibility is '
  Controls who is able to view this application
';