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

-- 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),
  pis   text[][]                                         ,
);


  company_ch          text                         ,
  name                text                 not null,
  company_old         text                         ,
  hosts              int[]                         ,
  founded             date                         ,
  acquired            date                         ,
  type              text[]                         ,
