Project

General

Profile

« Previous | Next » 

Revision 680

Added by Aaron Marcuse-Kubitza about 13 years ago

vegbien.sql: Made plantobservation.aggregateoccurrence_id optional because link will soon be going in the other direction

View differences:

schemas/vegbien.for_ERD.my.sql
264 264 
CREATE TABLE plantobservation -- VegBank's stemcount table.
265 265 
(
266 266 
  plantobservation_id int(11) NOT NULL AUTO_INCREMENT,
267 
  aggregateoccurrence_id int(11) NOT NULL,
267 
  aggregateoccurrence_id int(11),
268 268 
  overallheight double precision,
269 269 
  overallheightaccuracy double precision,
270 270 
  emb_plantobservation int(11),
schemas/vegbien.for_wiki.sql
78 78 
CREATE TABLE plantobservation -- VegBank's stemcount table.
79 79 
(
80 80 
  plantobservation_id serial NOT NULL,
81 
  aggregateoccurrence_id integer NOT NULL,
81 
  aggregateoccurrence_id integer,
82 82 
  overallheight double precision,
83 83 
  overallheightaccuracy double precision,
84 84 
  emb_plantobservation integer,
schemas/vegbien.for_ERD.sql
264 264 
CREATE TABLE plantobservation -- VegBank's stemcount table.
265 265 
(
266 266 
  plantobservation_id serial NOT NULL,
267 
  aggregateoccurrence_id integer NOT NULL,
267 
  aggregateoccurrence_id integer,
268 268 
  overallheight double precision,
269 269 
  overallheightaccuracy double precision,
270 270 
  emb_plantobservation integer,
schemas/vegbien.sql
1737 1737 

  		




  1738
  1738
  
    
CREATE TABLE plantobservation (


  		




  1739
  1739
  
    
    plantobservation_id integer NOT NULL,


  		




  1740
  
  
    
    aggregateoccurrence_id integer NOT NULL,


  		




  
  1740
  
    
    aggregateoccurrence_id integer,


  		




  1741
  1741
  
    
    overallheight double precision,


  		




  1742
  1742
  
    
    overallheightaccuracy double precision,


  		




  1743
  1743
  
    
    emb_plantobservation integer,


  		












Also available in:  Unified diff