Project

General

Profile

« Previous | Next » 

Revision 673

Added by Aaron Marcuse-Kubitza almost 13 years ago

VegBIEN: Renamed stem to stemobservation

View differences:

vegbien.for_wiki.sql
74 74 
  sourceaccessioncode character varying(100),
75 75 
);
76 76 

  		




  77
  
  
    
CREATE TABLE stem -- VegBank's stemlocation table.


  		




  
  77
  
    
CREATE TABLE stemobservation -- VegBank's stemlocation table.


  		




  78
  78
  
    
(


  		




  79
  
  
    
  stem_id serial NOT NULL,


  		




  
  79
  
    
  stemobservation_id serial NOT NULL,


  		




  80
  80
  
    
  plantobservation_id integer NOT NULL,


  		




  81
  81
  
    
  authorstemcode character varying(20),


  		




  82
  82
  
    
  xposition double precision,


  		




  83
  83
  
    
  yposition double precision,


  		




  84
  84
  
    
  health character varying(50),


  		




  85
  
  
    
  emb_stem integer,


  		




  
  85
  
    
  emb_stemobservation integer,


  		




  86
  86
  
    
  diameter double precision,


  		




  87
  87
  
    
  height double precision,


  		




  88
  88
  
    
  heightaccuracy double precision,


  		












Also available in:  Unified diff