Project

General

Profile

« Previous | Next » 

Revision 581

Added by Aaron Marcuse-Kubitza about 13 years ago

vegbien.sql: Require location to have either an authorlocationcode or a lat/long. Distinguish between regular and subplots in UNIQUE constraint.

View differences:

vegbien.for_ERD.sql
136 136 
  CONSTRAINT location_reference_id FOREIGN KEY (reference_id)
137 137 
      REFERENCES reference (reference_id) MATCH SIMPLE
138 138 
      ON UPDATE CASCADE ON DELETE CASCADE,
139 
  CONSTRAINT location_keys UNIQUE (reference_id , parent_id , authorlocationcode )
139 
  CONSTRAINT location_keys UNIQUE (reference_id , authorlocationcode , reallatitude , reallongitude ),
140 
  CONSTRAINT location_keys_subplot UNIQUE (parent_id , authorlocationcode , reallatitude , reallongitude )
140 141 
);
141 142 

  		




  142
  143
  
    
CREATE TABLE locationevent -- VegBank's observation table.


  		












Also available in:  Unified diff