-- Name: view_full_occurrence_individual_view_modify(int(1), anyelement); Type: FUNCTION; Schema: public; Owner: -

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

CREATE TABLE view_full_occurrence_individual (

-- Name: TABLE view_full_occurrence_individual; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.geovalid_bien; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.scrubbed_family; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.scrubbed_author; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.cultivated_bien; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`plantobservation.``_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual.`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: view_full_occurrence_individual_view; Type: VIEW; Schema: public; Owner: -

-- Name: VIEW view_full_occurrence_individual_view; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.geovalid_bien; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_family; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_author; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.cultivated_bien; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN view_full_occurrence_individual_view.`plantobservation.``_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: view_full_occurrence_CVS; Type: VIEW; Schema: public; Owner: -

-- Name: VIEW `view_full_occurrence_CVS`; Type: COMMENT; Schema: public; Owner: -

-- Name: view_full_occurrence_NCU; Type: VIEW; Schema: public; Owner: -

-- Name: VIEW `view_full_occurrence_NCU`; Type: COMMENT; Schema: public; Owner: -

-- Name: view_full_occurrence_VegBank; Type: VIEW; Schema: public; Owner: -

-- Name: VIEW `view_full_occurrence_VegBank`; Type: COMMENT; Schema: public; Owner: -

-- Name: view_full_occurrence_individu_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE; Schema: public; Owner: -

-- Name: view_full_occurrence_individu_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- Name: view_full_occurrence_individu_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE SET; Schema: public; Owner: -

-- Data for Name: view_full_occurrence_individual; Type: TABLE DATA; Schema: public; Owner: -

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

ALTER TABLE view_full_occurrence_individual

    ADD CONSTRAINT view_full_occurrence_individual_pkey PRIMARY KEY (`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`);

-- Name: view_full_occurrence_individu_datasource__@Brad__.identifi_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX `view_full_occurrence_individu_datasource__@Brad__.identifi_idx1` ON view_full_occurrence_individual  (`datasource__@Brad__.identifier_examples@vegpath.org`, `[custodial_]institutionCode[s]__@DwC__@vegpath.org`, `collectionCode__@DwC__@vegpath.org`, `catalogNumber__@DwC__@vegpath.org`);

-- Name: view_full_occurrence_individu_datasource__@Brad__.identifi_idx2; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX `view_full_occurrence_individu_datasource__@Brad__.identifi_idx2` ON view_full_occurrence_individual  (`datasource__@Brad__.identifier_examples@vegpath.org`, `projectID__@VegX__.plotObservation@vegpath.org`, `locationID__@DwC__@vegpath.org`, `eventDate__@DwC__@vegpath.org`);

-- Name: view_full_occurrence_individu_datasource__@Brad__.identifie_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 

CREATE INDEX `view_full_occurrence_individu_datasource__@Brad__.identifie_idx` ON view_full_occurrence_individual  (`datasource__@Brad__.identifier_examples@vegpath.org`, `occurrenceID__@DwC__@vegpath.org`);

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

CREATE INDEX `view_full_occurrence_individu_speciesBinomialWithMorphospec_idx` ON view_full_occurrence_individual  (`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`);

-- Name: view_full_occurrence_individual; Type: ACL; Schema: public; Owner: -

-- Name: view_full_occurrence_individual_view; Type: ACL; Schema: public; Owner: -

-- Name: view_full_occurrence_CVS; Type: ACL; Schema: public; Owner: -

-- Name: view_full_occurrence_NCU; Type: ACL; Schema: public; Owner: -

-- Name: view_full_occurrence_VegBank; Type: ACL; Schema: public; Owner: -

-- Name: view_full_occurrence_individual_view_modify(boolean, anyelement); Type: FUNCTION; Schema: public; Owner: -

CREATE FUNCTION view_full_occurrence_individual_view_modify(repopulate boolean DEFAULT true, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void

	PERFORM util.rematerialize_view('"view_full_occurrence_individual"', '"view_full_occurrence_individual_view"', $$

ALTER TABLE "view_full_occurrence_individual" ADD COLUMN "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" serial PRIMARY KEY;

COMMENT ON COLUMN "view_full_occurrence_individual"."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" IS 'VegBIEN-autogenerated "identifier assigned to each unique observation of a taxon in a plot"';