Project

General

Profile

« Previous | Next » 

Revision 605

Added by Aaron Marcuse-Kubitza about 13 years ago

vegbien.sql: Made several pointers to parent elements optional to deal with specimens data that might not have a location, etc.

View differences:

schemas/vegbien.for_ERD.my.sql
172 172 
(
173 173 
  locationevent_id int(11) NOT NULL AUTO_INCREMENT,
174 174 
  previous_id int(11),
175 
  location_id int(11) NOT NULL,
175 
  location_id int(11),
176 176 
  project_id int(11),
177 177 
  authoreventcode character varying(30),
178 178 
  `... (truncated) ...` int(11),
......
192 192 
CREATE TABLE taxonoccurrence -- VegBank's taxonobservation table.
193 193 
(
194 194 
  taxonoccurrence_id int(11) NOT NULL AUTO_INCREMENT,
195 
  locationevent_id int(11) NOT NULL,
195 
  locationevent_id int(11),
196 196 
  authorplantname character varying(255),
197 197 
  reference_id int(11),
198 198 
  taxoninferencearea double precision,
schemas/vegbien.for_wiki.sql
22 22 
(
23 23 
  locationevent_id serial NOT NULL,
24 24 
  previous_id integer,
25 
  location_id integer NOT NULL,
25 
  location_id integer,
26 26 
  project_id integer,
27 27 
  authoreventcode character varying(30),
28 28 
  "... (truncated) ..." integer,
......
33 33 
CREATE TABLE taxonoccurrence -- VegBank's taxonobservation table.
34 34 
(
35 35 
  taxonoccurrence_id serial NOT NULL,
36 
  locationevent_id integer NOT NULL,
36 
  locationevent_id integer,
37 37 
  authorplantname character varying(255),
38 38 
  reference_id integer,
39 39 
  taxoninferencearea double precision,
schemas/vegbien.for_ERD.sql
172 172 
(
173 173 
  locationevent_id serial NOT NULL,
174 174 
  previous_id integer,
175 
  location_id integer NOT NULL,
175 
  location_id integer,
176 176 
  project_id integer,
177 177 
  authoreventcode character varying(30),
178 178 
  "... (truncated) ..." integer,
......
192 192 
CREATE TABLE taxonoccurrence -- VegBank's taxonobservation table.
193 193 
(
194 194 
  taxonoccurrence_id serial NOT NULL,
195 
  locationevent_id integer NOT NULL,
195 
  locationevent_id integer,
196 196 
  authorplantname character varying(255),
197 197 
  reference_id integer,
198 198 
  taxoninferencearea double precision,
schemas/vegbien.sql
1172 1172 
CREATE TABLE locationevent (
1173 1173 
    locationevent_id integer NOT NULL,
1174 1174 
    previous_id integer,
1175 
    location_id integer NOT NULL,
1175 
    location_id integer,
1176 1176 
    project_id integer,
1177 1177 
    authoreventcode character varying(30),
1178 1178 
    dateaccuracy character varying(30),
......
2568 2568 

  		




  2569
  2569
  
    
CREATE TABLE taxonoccurrence (


  		




  2570
  2570
  
    
    taxonoccurrence_id integer NOT NULL,


  		




  2571
  
  
    
    locationevent_id integer NOT NULL,


  		




  
  2571
  
    
    locationevent_id integer,


  		




  2572
  2572
  
    
    authorplantname character varying(255),


  		




  2573
  2573
  
    
    reference_id integer,


  		




  2574
  2574
  
    
    taxoninferencearea double precision,


  		












Also available in:  Unified diff