TRUNCATE plotevent CASCADE;

TRUNCATE ploteventcontributor CASCADE;

TRUNCATE ploteventsynonym CASCADE;

    emb_collectiveobservation integer,

-- Name: collectiveobservation_collectiveobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE collectiveobservation_collectiveobservation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

-- Name: collectiveobservation_collectiveobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

ALTER SEQUENCE collectiveobservation_collectiveobservation_id_seq OWNED BY collectiveobservation.collectiveobservation_id;

--

-- Name: plotevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE plotevent (

    plotevent_id integer NOT NULL,

    previous_id integer,

    plot_id integer NOT NULL,

    project_id integer,

    authorcode character varying(30),

    dateaccuracy character varying(30),

    covermethod_id integer,

    coverdispersion character varying(30),

    autotaxoncover boolean,

    stratummethod_id integer,

    methodnarrative text,

    taxonoccurrencearea double precision,

    stemsizelimit double precision,

    stemobservationarea double precision,

    stemsamplemethod character varying(30),

    originaldata text,

    effortlevel character varying(30),

    plotvalidationlevel integer,

    floristicquality character varying(30),

    bryophytequality character varying(30),

    lichenquality character varying(30),

    ploteventnarrative text,

    landscapenarrative text,

    homogeneity character varying(50),

    phenologicaspect character varying(30),

    representativeness character varying(255),

    standmaturity character varying(50),

    successionalstatus text,

    basalarea double precision,

    hydrologicregime character varying(30),

    soilmoistureregime character varying(30),

    soildrainage character varying(30),

    watersalinity character varying(30),

    waterdepth double precision,

    shoredistance double precision,

    soildepth double precision,

    organicdepth double precision,

    soiltaxon_id integer,

    soiltaxonsrc character varying(200),

    percentbedrock double precision,

    percentrockgravel double precision,

    percentwood double precision,

    percentlitter double precision,

    percentbaresoil double precision,

    percentwater double precision,

    percentother double precision,

    nameother character varying(30),

    treeht double precision,

    shrubht double precision,

    fieldht double precision,

    nonvascularht double precision,

    submergedht double precision,

    treecover double precision,

    shrubcover double precision,

    fieldcover double precision,

    nonvascularcover double precision,

    floatingcover double precision,

    submergedcover double precision,

    dominantstratum character varying(40),

    growthform1type character varying(40),

    growthform2type character varying(40),

    growthform3type character varying(40),

    growthform1cover double precision,

    growthform2cover double precision,

    growthform3cover double precision,

    totalcover double precision,

    notespublic boolean,

    notesmgt boolean,

    revisions boolean,

    obsstartdate timestamp with time zone,

    obsenddate timestamp with time zone,

    dateentered timestamp with time zone DEFAULT now(),

    emb_plotevent integer,

    interp_orig_ci_id integer,

    interp_orig_cc_id integer,

    interp_orig_sciname text,

    interp_orig_code text,

    interp_orig_party_id integer,

    interp_orig_partyname text,

    interp_current_ci_id integer,

    interp_current_cc_id integer,

    interp_current_sciname text,

    interp_current_code text,

    interp_current_party_id integer,

    interp_current_partyname text,

    interp_bestfit_ci_id integer,

    interp_bestfit_cc_id integer,

    interp_bestfit_sciname text,

    interp_bestfit_code text,

    interp_bestfit_party_id integer,

    interp_bestfit_partyname text,

    toptaxon1name character varying(255),

    toptaxon2name character varying(255),

    toptaxon3name character varying(255),

    toptaxon4name character varying(255),

    toptaxon5name character varying(255),

    numberoftaxa integer,

    accessioncode character varying(255)

);

--

-- Name: plotevent_plotevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE plotevent_plotevent_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

-- Name: plotevent_plotevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

ALTER SEQUENCE plotevent_plotevent_id_seq OWNED BY plotevent.plotevent_id;

--

-- Name: ploteventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE ploteventcontributor (

    ploteventcontributor_id integer NOT NULL,

    plotevent_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer NOT NULL,

    contributiondate timestamp with time zone

);

--

-- Name: ploteventcontributor_ploteventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE ploteventcontributor_ploteventcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

-- Name: ploteventcontributor_ploteventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

ALTER SEQUENCE ploteventcontributor_ploteventcontributor_id_seq OWNED BY ploteventcontributor.ploteventcontributor_id;

--

-- Name: ploteventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE ploteventsynonym (

    ploteventsynonym_id integer NOT NULL,

    synonymplotevent_id integer NOT NULL,

    primaryplotevent_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer NOT NULL,

    synonymcomment text,

    classstartdate timestamp with time zone DEFAULT now() NOT NULL,

    classstopdate timestamp with time zone,

    accessioncode character varying(255)

);

--

-- Name: ploteventsynonym_ploteventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE ploteventsynonym_ploteventsynonym_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

-- Name: ploteventsynonym_ploteventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

ALTER SEQUENCE ploteventsynonym_ploteventsynonym_id_seq OWNED BY ploteventsynonym.ploteventsynonym_id;

--

    emb_stemobservation integer,

-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -

CREATE SEQUENCE stemobservation_stemobservation_id_seq

-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

ALTER SEQUENCE stemobservation_stemobservation_id_seq OWNED BY stemobservation.stemobservation_id;

    emb_taxonoccurrence integer,

-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -

CREATE SEQUENCE taxonoccurrence_taxonoccurrence_id_seq

-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

ALTER SEQUENCE taxonoccurrence_taxonoccurrence_id_seq OWNED BY taxonoccurrence.taxonoccurrence_id;

ALTER TABLE collectiveobservation ALTER COLUMN collectiveobservation_id SET DEFAULT nextval('collectiveobservation_collectiveobservation_id_seq'::regclass);

ALTER TABLE plotevent ALTER COLUMN plotevent_id SET DEFAULT nextval('plotevent_plotevent_id_seq'::regclass);

-- Name: ploteventcontributor_id; Type: DEFAULT; Schema: public; Owner: -

--

ALTER TABLE ploteventcontributor ALTER COLUMN ploteventcontributor_id SET DEFAULT nextval('ploteventcontributor_ploteventcontributor_id_seq'::regclass);

--

-- Name: ploteventsynonym_id; Type: DEFAULT; Schema: public; Owner: -

--

ALTER TABLE ploteventsynonym ALTER COLUMN ploteventsynonym_id SET DEFAULT nextval('ploteventsynonym_ploteventsynonym_id_seq'::regclass);

--

ALTER TABLE stemobservation ALTER COLUMN stemobservation_id SET DEFAULT nextval('stemobservation_stemobservation_id_seq'::regclass);

ALTER TABLE taxonoccurrence ALTER COLUMN taxonoccurrence_id SET DEFAULT nextval('taxonoccurrence_taxonoccurrence_id_seq'::regclass);

-- Name: collectiveobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY collectiveobservation

    ADD CONSTRAINT collectiveobservation_pkey PRIMARY KEY (collectiveobservation_id);

--

-- Name: plotevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY plotevent

    ADD CONSTRAINT plotevent_pkey PRIMARY KEY (plotevent_id);

--

-- Name: ploteventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY ploteventcontributor

    ADD CONSTRAINT ploteventcontributor_pkey PRIMARY KEY (ploteventcontributor_id);

--

-- Name: ploteventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY ploteventsynonym

    ADD CONSTRAINT ploteventsynonym_pkey PRIMARY KEY (ploteventsynonym_id);

--

-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);

-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);

-- Name: collectiveobservation_taxonbin_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX collectiveobservation_taxonbin_id_x ON collectiveobservation USING btree (taxonbin_id);

--

-- Name: collectiveobservation_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX collectiveobservation_taxonoccurrence_id_x ON collectiveobservation USING btree (taxonoccurrence_id);

--

-- Name: commclass_plotevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX commclass_plotevent_id_x ON commclass USING btree (plotevent_id);

-- Name: disturbanceobs_plotevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX disturbanceobs_plotevent_id_x ON disturbanceobs USING btree (plotevent_id);

-- Name: emb_collectiveobservation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX emb_collectiveobservation_idx ON collectiveobservation USING btree (emb_collectiveobservation);

--

-- Name: emb_plot_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX emb_plot_idx ON plot USING btree (emb_plot);

-- Name: emb_plotevent_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX emb_plotevent_idx ON plotevent USING btree (emb_plotevent);

-- Name: emb_stemobservation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX emb_stemobservation_idx ON stemobservation USING btree (emb_stemobservation);

-- Name: emb_taxonoccurrence_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX emb_taxonoccurrence_idx ON taxonoccurrence USING btree (emb_taxonoccurrence);

-- Name: graphic_plotevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX graphic_plotevent_id_x ON graphic USING btree (plotevent_id);

-- Name: individualplant_collectiveobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX individualplant_collectiveobservation_id_x ON individualplant USING btree (collectiveobservation_id);

-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE UNIQUE INDEX party_accessioncode_index ON party USING btree (accessioncode);

-- Name: party_currentname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX party_currentname_id_x ON party USING btree (currentname_id);

-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX partymember_childparty_id_x ON partymember USING btree (childparty_id);

-- Name: partymember_parentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX partymember_parentparty_id_x ON partymember USING btree (parentparty_id);

-- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX partymember_role_id_x ON partymember USING btree (role_id);

-- Name: place_namedplace_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX place_namedplace_id_x ON place USING btree (namedplace_id);

-- Name: place_plot_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX place_plot_id_x ON place USING btree (plot_id);

-- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept USING btree (accessioncode);

-- Name: plantconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantconcept_dobscount_x ON plantconcept USING btree (d_obscount);

-- Name: plantconcept_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantconcept_plantname_id_x ON plantconcept USING btree (plantname_id);

-- Name: plantconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantconcept_reference_id_x ON plantconcept USING btree (reference_id);

-- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation USING btree (plantconcept_id);

-- Name: plantcorrelation_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation USING btree (plantstatus_id);

-- Name: plantlineage_childplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage USING btree (childplantstatus_id);

-- Name: plantlineage_parentplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage USING btree (parentplantstatus_id);

-- Name: plantname_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantname_plantname_x ON plantname USING btree (plantname);

-- Name: plantname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantname_reference_id_x ON plantname USING btree (reference_id);

-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus USING btree (accessioncode);

-- Name: plantstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantstatus_party_id_x ON plantstatus USING btree (party_id);

-- Name: plantstatus_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus USING btree (plantconcept_id);

-- Name: plantstatus_plantlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantstatus_plantlevel_x ON plantstatus USING btree (plantlevel);

-- Name: plantstatus_plantparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantstatus_plantparent_id_x ON plantstatus USING btree (plantparent_id);

-- Name: plantstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantstatus_reference_id_x ON plantstatus USING btree (reference_id);

-- Name: plantusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantusage_classsystem_x ON plantusage USING btree (classsystem);

-- Name: plantusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantusage_party_id_x ON plantusage USING btree (party_id);

-- Name: plantusage_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantusage_plantconcept_id_x ON plantusage USING btree (plantconcept_id);

-- Name: plantusage_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantusage_plantname_id_x ON plantusage USING btree (plantname_id);

-- Name: plantusage_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantusage_plantname_x ON plantusage USING btree (plantname);

-- Name: plantusage_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plantusage_plantstatus_id_x ON plantusage USING btree (plantstatus_id);

-- Name: plot_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE UNIQUE INDEX plot_accessioncode_index ON plot USING btree (accessioncode);

-- Name: plot_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plot_parent_id_x ON plot USING btree (parent_id);

-- Name: plot_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plot_reference_id_x ON plot USING btree (reference_id);

-- Name: plotevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE UNIQUE INDEX plotevent_accessioncode_index ON plotevent USING btree (accessioncode);

-- Name: plotevent_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plotevent_covermethod_id_x ON plotevent USING btree (covermethod_id);

-- Name: plotevent_plot_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plotevent_plot_id_x ON plotevent USING btree (plot_id);

-- Name: plotevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plotevent_previousobs_id_x ON plotevent USING btree (previous_id);

-- Name: plotevent_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plotevent_project_id_x ON plotevent USING btree (project_id);

-- Name: plotevent_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plotevent_soiltaxon_id_x ON plotevent USING btree (soiltaxon_id);

-- Name: plotevent_stratummethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX plotevent_stratummethod_id_x ON plotevent USING btree (stratummethod_id);

-- Name: ploteventcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX ploteventcontributor_party_id_x ON ploteventcontributor USING btree (party_id);

-- Name: ploteventcontributor_plotevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX ploteventcontributor_plotevent_id_x ON ploteventcontributor USING btree (plotevent_id);

-- Name: ploteventcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX ploteventcontributor_role_id_x ON ploteventcontributor USING btree (role_id);

-- Name: ploteventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE UNIQUE INDEX ploteventsynonym_accessioncode_index ON ploteventsynonym USING btree (accessioncode);

-- Name: ploteventsynonym_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX ploteventsynonym_party_id_x ON ploteventsynonym USING btree (party_id);

-- Name: ploteventsynonym_primaryplotevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX ploteventsynonym_primaryplotevent_id_x ON ploteventsynonym USING btree (primaryplotevent_id);

-- Name: ploteventsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX ploteventsynonym_role_id_x ON ploteventsynonym USING btree (role_id);

-- Name: ploteventsynonym_synonymplotevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX ploteventsynonym_synonymplotevent_id_x ON ploteventsynonym USING btree (synonymplotevent_id);

-- Name: soilobs_plotevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX soilobs_plotevent_id_x ON soilobs USING btree (plotevent_id);

-- Name: stemobservation_individualplant_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX stemobservation_individualplant_id_x ON stemobservation USING btree (individualplant_id);

-- Name: stratum_plotevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX stratum_plotevent_id_x ON stratum USING btree (plotevent_id);

-- Name: taxondetermination_stemobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX taxondetermination_stemobservation_id_x ON taxondetermination USING btree (stemobservation_id);

-- Name: taxondetermination_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination USING btree (taxonoccurrence_id);

-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence USING btree (accessioncode);

-- Name: taxonoccurrence_int_currplantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX taxonoccurrence_int_currplantconcept_id_x ON taxonoccurrence USING btree (int_currplantconcept_id);

-- Name: taxonoccurrence_int_origplantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX taxonoccurrence_int_origplantconcept_id_x ON taxonoccurrence USING btree (int_origplantconcept_id);

-- Name: taxonoccurrence_plotevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX taxonoccurrence_plotevent_id_x ON taxonoccurrence USING btree (plotevent_id);

-- Name: taxonoccurrence_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX taxonoccurrence_reference_id_x ON taxonoccurrence USING btree (reference_id);

-- Name: r1collectiveobservation_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -

ALTER TABLE ONLY collectiveobservation

    ADD CONSTRAINT r1collectiveobservation_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: r1commclass_plotevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

    ADD CONSTRAINT r1commclass_plotevent_id FOREIGN KEY (plotevent_id) REFERENCES plotevent(plotevent_id) ON UPDATE CASCADE ON DELETE CASCADE;

-- Name: r1disturbanceobs_plotevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -

    ADD CONSTRAINT r1disturbanceobs_plotevent_id FOREIGN KEY (plotevent_id) REFERENCES plotevent(plotevent_id) ON UPDATE CASCADE ON DELETE CASCADE;

-- Name: r1graphic_plotevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -

    ADD CONSTRAINT r1graphic_plotevent_id FOREIGN KEY (plotevent_id) REFERENCES plotevent(plotevent_id) ON UPDATE CASCADE ON DELETE CASCADE;

-- Name: r1individualplant_collectiveobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -

    ADD CONSTRAINT r1individualplant_collectiveobservation_id FOREIGN KEY (collectiveobservation_id) REFERENCES collectiveobservation(collectiveobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;