Project

General

Profile

« Previous | Next » 

Revision 642

Added by Aaron Marcuse-Kubitza about 13 years ago

vegbien.sql: Added comments to specimen.collectioncode_dwc and collectionnumber to differentiate them

View differences:

vegbien.for_wiki.sql
95 95 
(
96 96 
  specimen_id serial NOT NULL,
97 97 
  reference_id integer NOT NULL,
98 
  collectioncode_dwc character varying(255),
98 
  collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
99 99 
  catalognumber_dwc character varying(255),
100 100 
  collectiondate timestamp with time zone,
101 101 
  museum_id integer,
......
103 103 
  accessioncode character varying(255),
104 104 
  taxonoccurrence_id integer NOT NULL,
105 105 
  verbatimcollectorname character varying(255),
106 
  collectionnumber character varying(255),
106 
  collectionnumber character varying(255), -- The number of the specimen within the collection.
107 107 
);
108 108 

  		




  109
  109
  
    
CREATE TABLE voucher


  		












Also available in:  Unified diff