Project

General

Profile

« Previous | Next » 

Revision 642

Added by Aaron Marcuse-Kubitza almost 13 years ago

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

View differences:

vegbien.for_ERD.my.sql
282 282 
(
283 283 
  specimen_id int(11) NOT NULL AUTO_INCREMENT,
284 284 
  reference_id int(11) NOT NULL,
285 
  collectioncode_dwc character varying(255),
285 
  collectioncode_dwc character varying(255), -- The code for the collection that the specimen is from.
286 286 
  catalognumber_dwc character varying(255),
287 287 
  collectiondate timestamp NULL,
288 288 
  museum_id int(11),
......
290 290 
  accessioncode character varying(255),
291 291 
  taxonoccurrence_id int(11) NOT NULL,
292 292 
  verbatimcollectorname character varying(255),
293 
  collectionnumber character varying(255),
293 
  collectionnumber character varying(255), -- The number of the specimen within the collection.
294 294 
  CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),
295 295 
  CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id)
296 296 
      REFERENCES party (party_id) MATCH SIMPLE

Also available in: Unified diff