CREATE TABLE location

(

  location_id serial NOT NULL,

  sourceid character varying(30),

  reference_id integer,

  parent_id integer,

  reallatitude double precision,

  reallongitude double precision,

  locationaccuracy double precision,

  confidentialitystatus integer NOT NULL,

  confidentialityreason character varying(200),

  latitude double precision,

  longitude double precision,

  -- ...

  accessioncode character varying(255),

  sublocationxposition double precision,

  sublocationyposition double precision,

  namedplace_id integer,

);

CREATE TABLE locationevent -- VegBank's observation table.

(

  locationevent_id serial NOT NULL,

  previous_id integer,

  location_id integer NOT NULL,

  project_id integer,

  sourceid character varying(30),

  -- ...

  accessioncode character varying(255),

);

CREATE TABLE taxonoccurrence -- VegBank's taxonobservation table.

(

  taxonoccurrence_id serial NOT NULL,

  locationevent_id integer NOT NULL,

  authorplantname character varying(255),

  reference_id integer,

  taxoninferencearea double precision,

  emb_taxonoccurrence integer,

  -- ...

  accessioncode character varying(255),

);

CREATE TABLE aggregateoccurrence -- VegBank's taxonimportance table.

(

  aggregateoccurrence_id serial NOT NULL,

  taxonoccurrence_id integer NOT NULL,

  taxonbin_id integer,

  cover double precision,

  basalarea double precision,

  biomass double precision,

  inferencearea double precision,

  stratumbase double precision,

  stratumheight double precision,

  emb_aggregateoccurrence integer,

  covercode character varying(10),

  count integer NOT NULL,

  accessioncode character varying(255),

);

CREATE TABLE individualplant -- VegBank's stemcount table.

(

  individualplant_id serial NOT NULL,

  aggregateoccurrence_id integer NOT NULL,

  height double precision,

  heightaccuracy double precision,

  emb_individualplant integer,

  sourceid character varying(20),

  accessioncode character varying(255),

  stemcount integer,

);

CREATE TABLE stem -- VegBank's stemlocation table.

(

  stem_id serial NOT NULL,

  individualplant_id integer NOT NULL,

  sourceid character varying(20),

  xposition double precision,

  yposition double precision,

  health character varying(50),

  emb_stem integer,

  diameter double precision,

  height double precision,

  heightaccuracy double precision,

  age double precision,

  accessioncode character varying(255),

);

CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.

(

  specimen_id serial NOT NULL,

  individualplant_id integer,

  reference_id integer NOT NULL,

  collectioncode_dwc character varying(255),

  catalognumber_dwc character varying(255),

  collectiondate timestamp with time zone,

  collector_id integer,

  museum_id integer,

  sourceaccessionnumber character varying(100),

  accessioncode character varying(255),

  taxonoccurrence_id integer,

);

CREATE TABLE taxondetermination -- VegBank's taxoninterpretation table.

(

  taxondetermination_id serial NOT NULL,

  taxonoccurrence_id integer NOT NULL,

  plantconcept_id integer NOT NULL,

  party_id integer NOT NULL,

  role_id integer NOT NULL,

  determinationtype character varying(30),

  reference_id integer,

  originaldetermination boolean NOT NULL,

  currentdetermination boolean NOT NULL,

  taxonfit character varying(50),

  taxonconfidence character varying(50),

  grouptype character varying(20),

  notes text,

  notespublic boolean,

  notesmgt boolean,

  revisions boolean,

  determinationdate timestamp with time zone NOT NULL,

  emb_taxondetermination integer,

  accessioncode character varying(255),

);

CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms.

(

  sizeclass_id serial NOT NULL,

  mindiameter double precision,

  diameteraccuracy double precision,

  minheight double precision,

  heightaccuracy double precision,

  maxdiameter double precision,

  maxheight double precision,

  accessioncode character varying(255),

);

CREATE TABLE taxonbin -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.

(

  taxonbin_id integer NOT NULL,

  label character varying(255) NOT NULL,

  stratum_id integer,

  sizeclass_id integer,

  coverindex_id integer,

  accessioncode character varying(255),

);

all = vegbien.sql vegbien_empty.sql vegbien.for_ERD.my.sql vegbien.for_wiki.sql

repl = ../bin/repl <$+ >$@

	$(repl)

%.for_wiki.sql: %.for_ERD.sql ../lib/ERD-wiki.csv

	$(repl)