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

--

CREATE TABLE analytical_stem (

    datasource varchar(255) NOT NULL,

    `institutionCode` varchar(255),

    `collectionCode` varchar(255),

    `catalogNumber` varchar(255),

    `occurrenceID` varchar(255),

    country varchar(255),

    `stateProvince` varchar(255),

    county varchar(255),

    locality varchar(255),

    `decimalLatitude` double precision,

    `decimalLongitude` double precision,

    `coordinateUncertaintyInMeters` double precision,

    `coordinateSource_bien` varchar(255),

    `georeferenceProtocol_bien` varchar(255),

    geovalid_bien int(11),

    `isNewWorld_bien` int(11),

    `projectID` varchar(255),

    `locationID` varchar(255) NOT NULL,

    `locationName` varchar(255),

    subplot varchar(255),

    `individualCode` varchar(255),

    `elevationInMeters` double precision,

    `plotArea_ha` double precision,

    `samplingProtocol` varchar(255),

    `temperature_C` double precision,

    precipitation_m double precision,

    `recordedBy` varchar(255),

    `recordNumber` varchar(255),

    `dateCollected` date,

    family_verbatim varchar(255),

    `scientificName_verbatim` varchar(255),

    `identifiedBy` varchar(255),

    `dateIdentified` date,

    `identificationRemarks` varchar(255),

    family_matched varchar(255),

    `taxonName_matched` varchar(255),

    `scientificNameAuthorship_matched` varchar(255),

    `higherPlantGroup_bien` varchar(255),

    family varchar(255),

    genus varchar(255),

    `speciesBinomialWithMorphospecies` varchar(255),

    `taxonName` varchar(255),

    `scientificNameAuthorship` varchar(255),

    `growthForm` varchar(255),

    `reproductiveCondition` varchar(255),

    threatened_bien int(11),

    cultivated_bien int(11),

    `cultivatedBasis_bien` varchar(255),

    `occurrenceRemarks` 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),

    `individualObservationID` varchar(255),

    `authorStemCode` varchar(255)

);

--

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

--

CREATE TABLE provider_count (

    dataprovider varchar(255) NOT NULL,

    dataset varchar(255) NOT NULL,

    records varchar(255),

    sourcetype varchar(255),

    observationtype varchar(255)

);

--

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

--

CREATE TABLE taxon_trait (

    `scientificName` varchar(255) NOT NULL,

    `measurementType` varchar(255) NOT NULL,

    `measurementValue` varchar(255),

    `measurementUnit` varchar(255)

);

--

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

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

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

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

--

--

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

--

--

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

--

CREATE TABLE analytical_stem (

    datasource text NOT NULL,

    "institutionCode" text,

    "collectionCode" text,

    "catalogNumber" text,

    "occurrenceID" text,

    country text,

    "stateProvince" text,

    county text,

    locality text,

    "decimalLatitude" double precision,

    "decimalLongitude" double precision,

    "coordinateUncertaintyInMeters" double precision,

    "coordinateSource_bien" coordinatesource,

    "georeferenceProtocol_bien" text,

    geovalid_bien integer,

    "isNewWorld_bien" integer,

    "projectID" text,

    "locationID" text NOT NULL,

    "locationName" text,

    subplot text,

    "individualCode" text,

    "elevationInMeters" double precision,

    "plotArea_ha" double precision,

    "samplingProtocol" text,

    "temperature_C" double precision,

    precipitation_m double precision,

    "recordedBy" text,

    "recordNumber" text,

    "dateCollected" date,

    family_verbatim text,

    "scientificName_verbatim" text,

    "identifiedBy" text,

    "dateIdentified" date,

    "identificationRemarks" text,

    family_matched text,

    "taxonName_matched" text,

    "scientificNameAuthorship_matched" text,

    "higherPlantGroup_bien" higher_plant_group,

    family text,

    genus text,

    "speciesBinomialWithMorphospecies" text,

    "taxonName" text,

    "scientificNameAuthorship" text,

    "growthForm" growthform,

    "reproductiveCondition" text,

    threatened_bien integer,

    cultivated_bien integer,

    "cultivatedBasis_bien" text,

    "occurrenceRemarks" text,

    "coverPercent" double precision,

    "diameterBreastHeight_cm" double precision,

    height_m double precision,

    tag text,

    "organismX_m" double precision,

    "organismY_m" double precision,

    "taxonOccurrenceID" text,

    "authorTaxonCode" text,

    "individualObservationID" text,

    "authorStemCode" text

);

--

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

--

CREATE TABLE provider_count (

    dataprovider text NOT NULL,

    dataset text NOT NULL,

    records bigint,

    sourcetype sourcetype,

    observationtype observationtype

);

--

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

--

CREATE TABLE taxon_trait (

    "scientificName" text NOT NULL,

    "measurementType" text NOT NULL,

    "measurementValue" text,

    "measurementUnit" text

);

--

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

--

REVOKE ALL ON TABLE analytical_stem FROM PUBLIC;

REVOKE ALL ON TABLE analytical_stem FROM bien;

GRANT ALL ON TABLE analytical_stem TO bien;

GRANT SELECT ON TABLE analytical_stem TO bien_read;

--

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

--

REVOKE ALL ON TABLE provider_count FROM PUBLIC;

REVOKE ALL ON TABLE provider_count FROM bien;

GRANT ALL ON TABLE provider_count TO bien;

GRANT SELECT ON TABLE provider_count TO bien_read;

GRANT SELECT ON TABLE provider_count TO public_;

--

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

--

REVOKE ALL ON TABLE taxon_trait FROM PUBLIC;

REVOKE ALL ON TABLE taxon_trait FROM bien;

GRANT ALL ON TABLE taxon_trait TO bien;

GRANT SELECT ON TABLE taxon_trait TO bien_read;

--