CREATE TABLE aggregateoccurrence (

    aggregateoccurrence_id integer NOT NULL,

    sourceaccessioncode text,

    taxonoccurrence_id integer NOT NULL,

    cover double precision,

CREATE TABLE locationevent (

    locationevent_id integer NOT NULL,

    sourceaccessioncode text,

    parent_id integer,

    location_id integer NOT NULL,

CREATE TABLE plantobservation (

    plantobservation_id integer NOT NULL,

    sourceaccessioncode text,

    overallheight double precision,

    overallheightaccuracy double precision,

CREATE TABLE project (

    project_id integer NOT NULL,

    sourceaccessioncode text,

    projectname text NOT NULL,

    projectdescription text,

CREATE TABLE taxonoccurrence (

    taxonoccurrence_id integer NOT NULL,

    sourceaccessioncode text,

    locationevent_id integer,

    verbatimcollectorname text,

CREATE TABLE stemobservation (

    stemobservation_id integer NOT NULL,

    sourceaccessioncode text,

    plantobservation_id integer NOT NULL,

    authorstemcode text,