Project

General

Profile

« Previous | Next » 

Revision 553

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: Added taxonoccurrence.currentdetermination_id and originaldetermination_id

View differences:

schemas/vegbien.for_ERD.my.sql
168 168 
  emb_taxonoccurrence int(11),
169 169 
  -- ...
170 170 
  accessioncode character varying(255),
171 
  currentdetermination_id int(11),
172 
  originaldetermination_id int(11),
171 173 
  CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id ),
174 
  CONSTRAINT taxonoccurrence_currentdetermination_id FOREIGN KEY (currentdetermination_id)
175 
      REFERENCES taxondetermination (taxondetermination_id) MATCH SIMPLE
176 
      ON UPDATE CASCADE ON DELETE CASCADE,
172 177 
  CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id)
173 178 
      REFERENCES locationevent (locationevent_id) MATCH SIMPLE
174 179 
      ON UPDATE CASCADE ON DELETE CASCADE,
180 
  CONSTRAINT taxonoccurrence_originaldetermination_id FOREIGN KEY (originaldetermination_id)
181 
      REFERENCES taxondetermination (taxondetermination_id) MATCH SIMPLE
182 
      ON UPDATE CASCADE ON DELETE CASCADE,
175 183 
  CONSTRAINT taxonoccurrence_reference_id FOREIGN KEY (reference_id)
176 184 
      REFERENCES reference (reference_id) MATCH SIMPLE
177 185 
      ON UPDATE CASCADE ON DELETE CASCADE
schemas/vegbien.for_wiki.sql
39 39 
  emb_taxonoccurrence integer,
40 40 
  -- ...
41 41 
  accessioncode character varying(255),
42 
  currentdetermination_id integer,
43 
  originaldetermination_id integer,
42 44 
);
43 45 

  		




  44
  46
  
    
CREATE TABLE aggregateoccurrence -- VegBank's taxonimportance table.


  		












  

    
      schemas/vegbien.for_ERD.sql
    
  





  168
  168
  
    
  emb_taxonoccurrence integer,


  		




  169
  169
  
    
  -- ...


  		




  170
  170
  
    
  accessioncode character varying(255),


  		




  
  171
  
    
  currentdetermination_id integer,


  		




  
  172
  
    
  originaldetermination_id integer,


  		




  171
  173
  
    
  CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id ),


  		




  
  174
  
    
  CONSTRAINT taxonoccurrence_currentdetermination_id FOREIGN KEY (currentdetermination_id)


  		




  
  175
  
    
      REFERENCES taxondetermination (taxondetermination_id) MATCH SIMPLE


  		




  
  176
  
    
      ON UPDATE CASCADE ON DELETE CASCADE,


  		




  172
  177
  
    
  CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id)


  		




  173
  178
  
    
      REFERENCES locationevent (locationevent_id) MATCH SIMPLE


  		




  174
  179
  
    
      ON UPDATE CASCADE ON DELETE CASCADE,


  		




  
  180
  
    
  CONSTRAINT taxonoccurrence_originaldetermination_id FOREIGN KEY (originaldetermination_id)


  		




  
  181
  
    
      REFERENCES taxondetermination (taxondetermination_id) MATCH SIMPLE


  		




  
  182
  
    
      ON UPDATE CASCADE ON DELETE CASCADE,


  		




  175
  183
  
    
  CONSTRAINT taxonoccurrence_reference_id FOREIGN KEY (reference_id)


  		




  176
  184
  
    
      REFERENCES reference (reference_id) MATCH SIMPLE


  		




  177
  185
  
    
      ON UPDATE CASCADE ON DELETE CASCADE


  		












  

    
      schemas/vegbien.sql
    
  





  2574
  2574
  
    
    int_currplantscinamenoauth character varying(255),


  		




  2575
  2575
  
    
    int_currplantcommon character varying(255),


  		




  2576
  2576
  
    
    int_currplantcode character varying(255),


  		




  2577
  
  
    
    accessioncode character varying(255)


  		




  
  2577
  
    
    accessioncode character varying(255),


  		




  
  2578
  
    
    currentdetermination_id integer,


  		




  
  2579
  
    
    originaldetermination_id integer


  		




  2578
  2580
  
    
);


  		




  2579
  2581
  
    

  		




  2580
  2582
  
    

  		




  ......




  4976
  4978
  
    

  		




  4977
  4979
  
    

  		




  4978
  4980
  
    
--


  		




  
  4981
  
    
-- Name: fki_taxonoccurrence_currentdetermination_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  
  4982
  
    
--


  		




  
  4983
  
    

  		




  
  4984
  
    
CREATE INDEX fki_taxonoccurrence_currentdetermination_id ON taxonoccurrence USING btree (currentdetermination_id);


  		




  
  4985
  
    

  		




  
  4986
  
    

  		




  
  4987
  
    
--


  		




  4979
  4988
  
    
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4980
  4989
  
    
--


  		




  4981
  4990
  
    

  		




  ......




  6594
  6603
  
    

  		




  6595
  6604
  
    

  		




  6596
  6605
  
    
--


  		




  
  6606
  
    
-- Name: taxonoccurrence_currentdetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  
  6607
  
    
--


  		




  
  6608
  
    

  		




  
  6609
  
    
ALTER TABLE ONLY taxonoccurrence


  		




  
  6610
  
    
    ADD CONSTRAINT taxonoccurrence_currentdetermination_id FOREIGN KEY (currentdetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  6611
  
    

  		




  
  6612
  
    

  		




  
  6613
  
    
--


  		




  6597
  6614
  
    
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  6598
  6615
  
    
--


  		




  6599
  6616
  
    

  		




  ......




  6602
  6619
  
    

  		




  6603
  6620
  
    

  		




  6604
  6621
  
    
--


  		




  
  6622
  
    
-- Name: taxonoccurrence_originaldetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  
  6623
  
    
--


  		




  
  6624
  
    

  		




  
  6625
  
    
ALTER TABLE ONLY taxonoccurrence


  		




  
  6626
  
    
    ADD CONSTRAINT taxonoccurrence_originaldetermination_id FOREIGN KEY (originaldetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  6627
  
    

  		




  
  6628
  
    

  		




  
  6629
  
    
--


  		




  6605
  6630
  
    
-- Name: taxonoccurrence_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  6606
  6631
  
    
--


  		




  6607
  6632
  
    

  		












Also available in:  Unified diff