Project

General

Profile

« Previous | Next » 

Revision 586

Added by Aaron Marcuse-Kubitza almost 13 years ago

VegBIEN: Renamed sourceaccessionnumber to sourceaccessioncode to show that they are the data source's analog of accessioncode. Added sourceaccessioncode to all applicable tables because this is the database pkey, which is distinct from any author*code applied by the collector.

View differences:

vegbien.for_wiki.sql
27 27 
  authoreventcode character varying(30),
28 28 
  "... (truncated) ..." integer,
29 29 
  accessioncode character varying(255),
30 
  sourceaccessioncode character varying(100),
30 31 
);
31 32 

  		




  32
  33
  
    
CREATE TABLE taxonoccurrence -- VegBank's taxonobservation table.


  		




  ......




  56
  57
  
    
  covercode character varying(10),


  		




  57
  58
  
    
  count integer NOT NULL,


  		




  58
  59
  
    
  accessioncode character varying(255),


  		




  
  60
  
    
  sourceaccessioncode character varying(100),


  		




  59
  61
  
    
);


  		




  60
  62
  
    

  		




  61
  63
  
    
CREATE TABLE individualplant -- VegBank's stemcount table.


  		




  ......




  68
  70
  
    
  authorplantcode character varying(20),


  		




  69
  71
  
    
  accessioncode character varying(255),


  		




  70
  72
  
    
  stemcount integer,


  		




  
  73
  
    
  sourceaccessioncode character varying(100),


  		




  71
  74
  
    
);


  		




  72
  75
  
    

  		




  73
  76
  
    
CREATE TABLE stem -- VegBank's stemlocation table.


  		




  ......




  85
  88
  
    
  age double precision,


  		




  86
  89
  
    
  accessioncode character varying(255),


  		




  87
  90
  
    
  diameteraccuracy double precision,


  		




  
  91
  
    
  sourceaccessioncode character varying(100),


  		




  88
  92
  
    
);


  		




  89
  93
  
    

  		




  90
  94
  
    
CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.


  		




  ......




  96
  100
  
    
  collectiondate timestamp with time zone,


  		




  97
  101
  
    
  collector_id integer,


  		




  98
  102
  
    
  museum_id integer,


  		




  99
  
  
    
  sourceaccessionnumber character varying(100),


  		




  
  103
  
    
  sourceaccessioncode character varying(100),


  		




  100
  104
  
    
  accessioncode character varying(255),


  		




  101
  105
  
    
  taxonoccurrence_id integer NOT NULL,


  		




  102
  106
  
    
  collectornumber_dwc character varying(255),


  		












Also available in:  Unified diff