text: CREATE TABLE observations (
      observation_uuid uuid NOT NULL,
      observer_id integer,
      latitude numeric(15,10),
      longitude numeric(15,10),
      positional_accuracy integer,
      taxon_id integer,
      quality_grade character varying(255),
      observed_on date
  );
  
  CREATE TABLE photos (
      photo_uuid uuid NOT NULL,
      photo_id integer NOT NULL,
      observation_uuid uuid NOT NULL,
      observer_id integer,
      extension character varying(5),
      license character varying(255),
      width smallint,
      height smallint,
      position smallint
  );
  
  CREATE TABLE taxa (
      taxon_id integer NOT NULL,
      ancestry character varying(255),
      rank_level double precision,
      rank character varying(255),
      name character varying(255),
      active boolean
  );
  
  CREATE TABLE observers (
      observer_id integer NOT NULL,
      login character varying(255),
      name character varying(255)
  );
  