 -- Contains the hostnames that were found in apps via analysis
 create table app_hosts(
   id         int references apps(id) primary key not null,
-  hosts    int[]                     references hosts(id),
+  hosts    int[]                                         ,
   pis   text[][]                                         ,
 );
 

  company_ch          text                         ,
  name                text                 not null,
  company_old         text                         ,
  hosts              int[]     references hosts(id),
  founded             date                         ,
  acquired            date                         ,
  type              text[]                         ,

create table apps(
  id            int primary key not null,
  app_id       text             not null,
  versions    int[]                     ,
);

create table app_versions(
