accessioncode character varying(255),

  taxonoccurrence_id integer NOT NULL,

  collectornumber_dwc character varying(255),

  CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),

  CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id)

      REFERENCES party (party_id) MATCH SIMPLE

      REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

  CONSTRAINT specimen_keys_accessioncode UNIQUE (reference_id , collectioncode_dwc , sourceaccessioncode ),

);

CREATE TABLE voucher