/ - Diff - BIEN 3 - NCEAS Projects

       CONSTRAINT stem_keys_code UNIQUE (individualplant_id , authorstemcode )
     );
     CREATE TABLE specimen
+    (
       specimen_id int(11) NOT NULL AUTO_INCREMENT,
       CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id )
     );
     CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
+    (
       specimenreplicate_id int(11) NOT NULL AUTO_INCREMENT,
-...
       taxonoccurrence_id int(11) NOT NULL,
       verbatimcollectorname character varying(255),
       collectionnumber character varying(255), -- The number of the specimenreplicate within the collection.
       specimen_id int(11),
       CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id ),
       CONSTRAINT specimenreplicate_museum_id FOREIGN KEY (museum_id)
           REFERENCES party (party_id) MATCH SIMPLE
-...
       CONSTRAINT specimenreplicate_reference_id_fkey FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id)
           REFERENCES specimen (specimen_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,

       sourceaccessioncode character varying(100),
     );
     CREATE TABLE specimen
+    (
       specimen_id serial NOT NULL,
     );
     CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
+    (
       specimenreplicate_id serial NOT NULL,
-...
       taxonoccurrence_id integer NOT NULL,
       verbatimcollectorname character varying(255),
       collectionnumber character varying(255), -- The number of the specimenreplicate within the collection.
       specimen_id integer,
     );
     CREATE TABLE voucher

schemas/vegbien_empty.sql
59	59	TRUNCATE sizeclass CASCADE;
60	60	TRUNCATE soilobs CASCADE;
61	61	TRUNCATE soiltaxon CASCADE;
	62	TRUNCATE specimen CASCADE;
62	63	TRUNCATE specimenreplicate CASCADE;
63	64	TRUNCATE stem CASCADE;
64	65	TRUNCATE stratum CASCADE;

       CONSTRAINT stem_keys_code UNIQUE (individualplant_id , authorstemcode )
     );
     CREATE TABLE specimen
+    (
       specimen_id serial NOT NULL,
       CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id )
     );
     CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
+    (
       specimenreplicate_id serial NOT NULL,
-...
       taxonoccurrence_id integer NOT NULL,
       verbatimcollectorname character varying(255),
       collectionnumber character varying(255), -- The number of the specimenreplicate within the collection.
       specimen_id integer,
       CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id ),
       CONSTRAINT specimenreplicate_museum_id FOREIGN KEY (museum_id)
           REFERENCES party (party_id) MATCH SIMPLE
-...
       CONSTRAINT specimenreplicate_reference_id_fkey FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id)
           REFERENCES specimen (specimen_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,

     SET default_with_oids = false;
     --
     -- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
     CREATE TABLE specimen (
         specimen_id integer NOT NULL
     );
     --
     -- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
     CREATE SEQUENCE specimen_specimen_id_seq
         START WITH 1
         INCREMENT BY 1
         NO MINVALUE
         NO MAXVALUE
         CACHE 1;
     --
     -- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
     --
     ALTER SEQUENCE specimen_specimen_id_seq OWNED BY specimen.specimen_id;
     --
     -- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
         accessioncode character varying(255),
         taxonoccurrence_id integer NOT NULL,
         verbatimcollectorname character varying(255),
         collectionnumber character varying(255)
         collectionnumber character varying(255),
         specimen_id integer
     );
-...
     --
     -- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
     --
     ALTER TABLE specimen ALTER COLUMN specimen_id SET DEFAULT nextval('specimen_specimen_id_seq'::regclass);
     --
     -- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
     --
-...
     --
     -- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY specimen
         ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
     --
     -- Name: specimenreplicate_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: fki_specimenreplicate_specimen_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
     CREATE INDEX fki_specimenreplicate_specimen_id ON specimenreplicate USING btree (specimen_id);
     --
     -- Name: fki_taxonbinmethod_sizeclass_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY specimenreplicate
         ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     --

Project

General

Profile

Revision 669

Added by Aaron Marcuse-Kubitza almost 13 years ago