Project

General

Profile

« Previous | Next » 

Revision 584

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: Renamed taxonbin to taxonbinmethod to reflect that it does not contain actual organisms (those go in aggregateoccurrence), but rather defined a method of aggregating organisms

View differences:

vegbien.for_wiki.sql
45 45 
(
46 46 
  aggregateoccurrence_id serial NOT NULL,
47 47 
  taxonoccurrence_id integer NOT NULL,
48 
  taxonbin_id integer,
48 
  taxonbinmethod_id integer,
49 49 
  cover double precision,
50 50 
  basalarea double precision,
51 51 
  biomass double precision,
......
156 156 
  accessioncode character varying(255),
157 157 
);
158 158 

  		




  159
  
  
    
CREATE TABLE taxonbin -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.


  		




  
  159
  
    
CREATE TABLE taxonbinmethod -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.


  		




  160
  160
  
    
(


  		




  161
  
  
    
  taxonbin_id integer NOT NULL,


  		




  
  161
  
    
  taxonbinmethod_id integer NOT NULL,


  		




  162
  162
  
    
  label character varying(255) NOT NULL DEFAULT ''::character varying,


  		




  163
  163
  
    
  stratum_id integer,


  		




  164
  164
  
    
  sizeclass_id integer,


  		












Also available in:  Unified diff