gistfile1.txt

regions <--- THIS NEEDS POPULATING!
 id
 lat
 lng
 name
 description
 num_samples

countries
 id
 lat
 lng
 name
 num_samples

sites
 id
 lat
 lng
 name
 num_samples

features
 id
 name
 category
 description

samples
  id
  site
  country
  region
  site_lat
  site_lng
  country_lat
  country_lng
  region_lat
  region_lng
  date
  process_type
  run_accessions
  (ART_resistant)
  (CQ_resistant)
  (PYR_resistant)
  (SDX_resistant)
  (MQ_resistant)

studies
 AS EXISITING

study_people
 AS EXISITING

study_publications
 AS EXISITING

variants
 AS EXISTING (but with added allele freqs when we get them)

What do we need for featuretypes? I can set that up on the dev1 system too, if you like.

feature_id	character varying(50)
type_id	character varying(50)
description	text

CREATE VIEW observatory.featuretypes_view AS
SELECT ft.feature_id
 , ft.type_id
 , ft.description
FROM observatory.featuretypes ft
;