Project

General

Profile

« Previous | Next » 

Revision 674

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: Added plant and planttag tables

View differences:

vegbien.for_wiki.sql
61 61 
  plantobservation_id integer,
62 62 
);
63 63 

  		




  
  64
  
    
CREATE TABLE plant -- A physical, tagged plant.


  		




  
  65
  
    
(


  		




  
  66
  
    
  plant_id serial NOT NULL,


  		




  
  67
  
    
);


  		




  
  68
  
    

  		




  
  69
  
    
CREATE TABLE planttag


  		




  
  70
  
    
(


  		




  
  71
  
    
  planttag_id serial NOT NULL,


  		




  
  72
  
    
  plant_id integer NOT NULL,


  		




  
  73
  
    
  tag character varying(255) NOT NULL,


  		




  
  74
  
    
);


  		




  
  75
  
    

  		




  64
  76
  
    
CREATE TABLE plantobservation -- VegBank's stemcount table.


  		




  65
  77
  
    
(


  		




  66
  78
  
    
  plantobservation_id serial NOT NULL,


  		




  ......




  72
  84
  
    
  accessioncode character varying(255),


  		




  73
  85
  
    
  stemcount integer,


  		




  74
  86
  
    
  sourceaccessioncode character varying(100),


  		




  
  87
  
    
  plant_id integer,


  		




  75
  88
  
    
);


  		




  76
  89
  
    

  		




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


  		












Also available in:  Unified diff