CREATE TABLE "aggregate_observation" (

  "id" bytea NOT NULL,

  "taxon_concept" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_aggregate_observation_taxon_name1_idx" ("taxon_concept")*/CHECK (true),

  /*CONSTRAINT "fk_aggregate_observation_taxon_name1" FOREIGN KEY ("taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

CREATE TABLE "community" (

  "id" bytea NOT NULL,

  "name" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_community_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

CREATE TABLE "geological_context" (

  "id" bytea NOT NULL,

  "name" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_geological_context_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

  "id" bytea NOT NULL,

  "geovalid" integer NOT NULL,

  "lat_long_domain_valid" integer NOT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_geovalidation_validatable_place1" FOREIGN KEY ("id") REFERENCES "validatable_place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

  "id" bytea NOT NULL,

  "individual" bytea DEFAULT NULL,

  "code" bytea DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_individual_observation_individual1_idx" ("individual")*/CHECK (true),

  /*CONSTRAINT "fk_individual_observation_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

CREATE TABLE "method" (

  "id" bytea NOT NULL,

  "parent" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_method_method1_idx" ("parent")*/CHECK (true),

  /*CONSTRAINT "fk_method_method1" FOREIGN KEY ("parent") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

DROP TABLE IF EXISTS "organization";

CREATE TABLE "organization" (

  "id" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_organization_party1" FOREIGN KEY ("id") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

  "id" bytea NOT NULL,

  "matched_taxon_concept" bytea DEFAULT NULL,

  "match_score" float DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_parsed_taxon_assertion_taxon_name1_idx" ("matched_taxon_concept")*/CHECK (true),

  /*CONSTRAINT "fk_matched_taxon_qualified_taxon10" FOREIGN KEY ("id") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

DROP TABLE IF EXISTS "party";

CREATE TABLE "party" (

  "id" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

  "slope_direction_deg_N" double precision DEFAULT NULL,

  "geological_context" bytea DEFAULT NULL,

  "community" bytea DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_place_observation_place1_idx" ("place")*/CHECK (true),

  /*KEY "fk_place_observation_geological_context1_idx" ("geological_context")*/CHECK (true),

  "state_province" bytea DEFAULT NULL,

  "county" bytea DEFAULT NULL,

  "municipality" bytea DEFAULT NULL,

  PRIMARY KEY ("id")

);

CREATE TABLE "project" (

  "id" bytea NOT NULL,

  "name" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_project_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

  "source" bytea NOT NULL,

  "source_id_scope" bytea DEFAULT NULL,

  "source_record_id" bytea DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "record_unique" */UNIQUE ("source","source_id_scope","source_record_id"),

  /*KEY "fk_record_source1_idx" ("source")*/CHECK (true),

  "id" bytea NOT NULL,

  "record" bytea NOT NULL,

  "related_record" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_relationship_record1_idx" ("record")*/CHECK (true),

  /*KEY "fk_relationship_related_record_idx" ("related_record")*/CHECK (true),

DROP TABLE IF EXISTS "soil_observation";

CREATE TABLE "soil_observation" (

  "id" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_soil_observation_place_observation1" FOREIGN KEY ("id") REFERENCES "place_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

  "name" bytea NOT NULL,

  "first_publisher" bytea DEFAULT NULL,

  "owner" bytea DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "source_unique" */UNIQUE ("parent","name"),

  /*KEY "fk_source1_idx" ("parent")*/CHECK (true),

CREATE TABLE "specimen_observation" (

  "id" bytea NOT NULL,

  "specimen" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_specimen_observation_specimen1_idx" ("specimen")*/CHECK (true),

  /*CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  "id" bytea NOT NULL,

  "individual_observation" bytea NOT NULL,

  "stem" bytea DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "stem_observation_unique" */UNIQUE ("individual_observation","stem"),

  /*KEY "fk_stem_observation_individual_observation1_idx" ("individual_observation")*/CHECK (true),

CREATE TABLE "stratum" (

  "id" bytea NOT NULL,

  "name" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_place_path_record10" FOREIGN KEY ("id") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

  "string" bytea NOT NULL,

  "taxon" bytea DEFAULT NULL,

  "cf_aff" bytea DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_taxon_assertion_taxon_string1_idx" ("string")*/CHECK (true),

  /*KEY "fk_taxon_assertion_taxon_name1_idx" ("taxon")*/CHECK (true),

  "id" bytea NOT NULL,

  "taxon_assertion" bytea NOT NULL,

  "identified_by" bytea DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "taxon_determination_unique" */UNIQUE ("taxon_assertion","identified_by"),

  /*KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion")*/CHECK (true),

  "voucher" bytea DEFAULT NULL,

  "growth_form" bytea DEFAULT NULL,

  "cultivated" integer DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_taxon_observation_taxon_occurrence2_idx" ("taxon_occurrence")*/CHECK (true),

  /*KEY "fk_taxon_observation_specimen1_idx" ("voucher")*/CHECK (true),

  "family" bytea DEFAULT NULL,

  "genus" bytea DEFAULT NULL,

  "specific_epithet" bytea DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_taxon_path_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

);

CREATE TABLE "taxon_presence" (

  "id" bytea NOT NULL,

  "taxon_concept" bytea NOT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_taxon_presence_taxon_name1_idx" ("taxon_concept")*/CHECK (true),

  /*CONSTRAINT "fk_taxon_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

-e 's/ (char)\(0\)/ \1/g' \

-e 's/ datetime/ timestamp/g' \

-e 's/ ("[^"]*") enum(\([^()]*\))/ \1 text CHECK (\1 in \2)/g' \

"$@"\

|"$selfDir/my2pg.data"