-- 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: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE project (

    project_id int(11) NOT NULL,

    source_id int(11) NOT NULL,

    sourceaccessioncode varchar(255),

    projectname varchar(255),

    projectdescription varchar(255),

    startdate date,

    stopdate date,

    accessioncode varchar(255)

);

--

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

--

CREATE TABLE sourcename (

    sourcename_id int(11) NOT NULL,

    source_id int(11) NOT NULL,

    system varchar(255),

    name varchar(255) NOT NULL,

    matched_source_id int(11)

);

--

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

--

CREATE TABLE specimenreplicate (

    specimenreplicate_id int(11) NOT NULL,

    source_id int(11) NOT NULL,

    sourceaccessioncode varchar(255),

    plantobservation_id int(11),

    institution_id int(11),

    collectioncode_dwc varchar(255),

    catalognumber_dwc varchar(255),

    description varchar(255),

    specimen_id int(11),

    accessioncode varchar(255)

);

--

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

--

--

-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -

--

--

-- 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`);

--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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