CREATE TABLE aggregateoccurrence (

    aggregateoccurrence_id int(11) NOT NULL,

    sourceaccessioncode text,

    taxonoccurrence_id int(11) NOT NULL,

    cover double precision,

CREATE TABLE locationevent (

    locationevent_id int(11) NOT NULL,

    sourceaccessioncode text,

    parent_id int(11),

    location_id int(11) NOT NULL,

CREATE TABLE plantobservation (

    plantobservation_id int(11) NOT NULL,

    sourceaccessioncode text,

    overallheight double precision,

    overallheightaccuracy double precision,

CREATE TABLE project (

    project_id int(11) NOT NULL,

    sourceaccessioncode text,

    projectname text NOT NULL,

    projectdescription text,

CREATE TABLE taxonoccurrence (

    taxonoccurrence_id int(11) NOT NULL,

    sourceaccessioncode text,

    locationevent_id int(11),

    verbatimcollectorname text,

CREATE TABLE specimenreplicate (

    taxonoccurrence_id int(11) NOT NULL AUTO_INCREMENT,

    plantobservation_id int(11),

    institution_id int(11),

    collectioncode_dwc text,

CREATE TABLE stemobservation (

    stemobservation_id int(11) NOT NULL,

    sourceaccessioncode text,

    plantobservation_id int(11) NOT NULL,

    authorstemcode text,