Project

General

Profile

« Previous | Next » 

Revision 552

Added by Aaron Marcuse-Kubitza about 13 years ago

vegbien.ERD.mwb: Added stratum and place tables

View differences:

vegbien.for_wiki.sql
131 131 
  accessioncode character varying(255),
132 132 
);
133 133 

  		




  
  134
  
    
CREATE TABLE stratum


  		




  
  135
  
    
(


  		




  
  136
  
    
  stratum_id serial NOT NULL,


  		




  
  137
  
    
  locationevent_id integer NOT NULL,


  		




  
  138
  
    
  stratumtype_id integer NOT NULL,


  		




  
  139
  
    
  stratummethod_id integer,


  		




  
  140
  
    
  stratumname character varying(30),


  		




  
  141
  
    
  stratumheight double precision,


  		




  
  142
  
    
  stratumbase double precision,


  		




  
  143
  
    
  stratumcover double precision,


  		




  
  144
  
    
  stratumdescription character varying(200),


  		




  
  145
  
    
);


  		




  
  146
  
    

  		




  134
  147
  
    
CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms.


  		




  135
  148
  
    
(


  		




  136
  149
  
    
  sizeclass_id serial NOT NULL,


  		












Also available in:  Unified diff