Project

General

Profile

« Previous | Next » 

Revision 592

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: taxonbinmethod points to stratumtype instead of stratum because stratumtype is a method table, but stratum is a measurements table. stratum does not point directly to stratummethod because it points to it via stratumtype.

View differences:

vegbien.for_wiki.sql
161 161 
  accessioncode character varying(255),
162 162 
);
163 163 

  		




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


  		




  
  164
  
    
CREATE TABLE taxonbinmethod


  		




  165
  165
  
    
(


  		




  166
  166
  
    
  taxonbinmethod_id integer NOT NULL,


  		




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


  		




  168
  
  
    
  stratum_id integer,


  		




  
  167
  
    
  label character varying(255),


  		




  
  168
  
    
  stratumtype_id integer,


  		




  169
  169
  
    
  sizeclass_id integer,


  		




  170
  170
  
    
  coverindex_id integer,


  		




  171
  171
  
    
  accessioncode character varying(255),


  		












Also available in:  Unified diff