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

--

CREATE TABLE analytical_aggregate (

    "institutionCode" text NOT NULL,

    country text,

    "stateProvince" text,

    county text,

    "decimalLatitude" double precision,

    "decimalLongitude" double precision,

    "coordinateUncertaintyInMeters" double precision,

    geovalid boolean,

    "isNewWorld" boolean,

    "distanceToCountry_km" double precision,

    "distanceToStateProvince_km" double precision,

    "plotName" text NOT NULL,

    "elevationInMeters" double precision,

    "plotArea_ha" double precision,

    "samplingProtocol" text,

    "dateCollected" date NOT NULL,

    "higherPlantGroup" higher_plant_group,

    family text,

    genus text,

    "speciesBinomial" text,

    "scientificName" text,

    "scientificNameAuthorship" text,

    "scientificNameWithMorphospecies" text,

    threatened boolean,

    "identifiedBy" text,

    "growthForm" growthform,

    cultivated boolean,

    "cultivatedBasis" text,

    "coverPercent" double precision,

    "individualCount" bigint,

    "individualCount_1cm_or_more" bigint,

    "individualCount_2_5cm_or_more" bigint,

    "individualCount_10cm_or_more" bigint

);

--

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

--

CREATE TABLE analytical_stem (

    "institutionCode" text NOT NULL,

    country text,

    "stateProvince" text,

    county text,

    "decimalLatitude" double precision,

    "decimalLongitude" double precision,

    "coordinateUncertaintyInMeters" double precision,

    geovalid boolean,

    "isNewWorld" boolean,

    "distanceToCountry_km" double precision,

    "distanceToStateProvince_km" double precision,

    "plotName" text NOT NULL,

    "elevationInMeters" double precision,

    "plotArea_ha" double precision,

    "samplingProtocol" text,

    "dateCollected" date NOT NULL,

    "higherPlantGroup" higher_plant_group,

    family text,

    genus text,

    "speciesBinomial" text,

    "scientificName" text,

    "scientificNameAuthorship" text,

    "scientificNameWithMorphospecies" text,

    threatened boolean,

    "identifiedBy" text,

    "growthForm" growthform,

    cultivated boolean,

    "cultivatedBasis" text,

    "coverPercent" double precision,

    "diameterBreastHeight_cm" double precision,

    height_m double precision,

    tag text,

    "organismX_m" double precision,

    "organismY_m" double precision,

    "recordedBy" text,

    "recordNumber" text

);

--

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

CREATE TABLE soilsample (

    soilsample_id integer NOT NULL,

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

CREATE SEQUENCE soilsample_soilsample_id_seq

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

ALTER SEQUENCE soilsample_soilsample_id_seq OWNED BY soilsample.soilsample_id;

-- Name: soilsample_soilsample_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -

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

ALTER TABLE ONLY soilsample ALTER COLUMN soilsample_id SET DEFAULT nextval('soilsample_soilsample_id_seq'::regclass);

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

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

ALTER TABLE ONLY soilsample

    ADD CONSTRAINT soilsample_pkey PRIMARY KEY (soilsample_id);

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

ALTER TABLE ONLY soilsample

    ADD CONSTRAINT soilsample_unique UNIQUE (locationevent_id);

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

ALTER TABLE ONLY soilsample

    ADD CONSTRAINT soilsample_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;

-- 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: soilsample; Type: ACL; Schema: public; Owner: -

REVOKE ALL ON TABLE soilsample FROM PUBLIC;

REVOKE ALL ON TABLE soilsample FROM bien;

GRANT ALL ON TABLE soilsample TO bien;

GRANT SELECT ON TABLE soilsample TO bien_read;