-- Name: sync_darwin_core_to_view(); Type: FUNCTION; Schema: public; Owner: -

--

--

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

--

CREATE TABLE darwin_core (

    `institutionCode` varchar(255),

    `subInstitutionCode` varchar(255),

    `collectionCode` varchar(255),

    `catalogNumber` varchar(255),

    `occurrenceID` varchar(255),

    country varchar(255),

    `stateProvince` varchar(255),

    county varchar(255),

    `decimalLatitude` double precision,

    `decimalLongitude` double precision,

    `coordinateUncertaintyInMeters` double precision,

    geovalid int(1),

    `isNewWorld` int(1),

    `projectID` int(11),

    `plotName` varchar(255),

    `elevationInMeters` double precision,

    `plotArea_ha` double precision,

    `samplingProtocol` varchar(255),

    `dateCollected` date,

    `higherPlantGroup` varchar(255),

    family varchar(255),

    genus varchar(255),

    `speciesBinomial` varchar(255),

    `scientificName` varchar(255),

    `scientificNameAuthorship` varchar(255),

    `speciesBinomialWithMorphospecies` varchar(255),

    `scientificNameWithMorphospecies` varchar(255),

    threatened int(1),

    `identifiedBy` varchar(255),

    `growthForm` varchar(255),

    cultivated int(1),

    `cultivatedBasis` varchar(255),

    `recordedBy` varchar(255),

    `recordNumber` varchar(255),

    `coverPercent` double precision,

    `diameterBreastHeight_cm` double precision,

    height_m double precision,

    tag varchar(255),

    `organismX_m` double precision,

    `organismY_m` double precision,

    `taxonOccurrenceID` varchar(255),

    `authorTaxonCode` varchar(255),

    `individualID` varchar(255),

    `authorStemCode` varchar(255)

);

--

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

--

--

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

--

--

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

--

CREATE INDEX `darwin_core_institutionCode_catalogNumber_idx` ON darwin_core  (`institutionCode`, `catalogNumber`);

--

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

--

CREATE INDEX `darwin_core_institutionCode_occurrenceID_idx` ON darwin_core  (`institutionCode`, `occurrenceID`);

--

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

--

CREATE INDEX `darwin_core_institutionCode_projectID_plotName_dateCollecte_idx` ON darwin_core  (`institutionCode`, `projectID`, `plotName`, `dateCollected`);

--

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

--

CREATE INDEX `darwin_core_institutionCode_subInstitutionCode_collectionCo_idx` ON darwin_core  (`institutionCode`, `subInstitutionCode`, `collectionCode`, `catalogNumber`);

--