Project

General

Profile

« Previous | Next » 

Revision 553

vegbien.sql: Added taxonoccurrence.currentdetermination_id and originaldetermination_id

View differences:

vegbien.for_ERD.sql
168 168
  emb_taxonoccurrence integer,
169 169
  -- ...
170 170
  accessioncode character varying(255),
171
  currentdetermination_id integer,
172
  originaldetermination_id integer,
171 173
  CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id ),
174
  CONSTRAINT taxonoccurrence_currentdetermination_id FOREIGN KEY (currentdetermination_id)
175
      REFERENCES taxondetermination (taxondetermination_id) MATCH SIMPLE
176
      ON UPDATE CASCADE ON DELETE CASCADE,
172 177
  CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id)
173 178
      REFERENCES locationevent (locationevent_id) MATCH SIMPLE
174 179
      ON UPDATE CASCADE ON DELETE CASCADE,
180
  CONSTRAINT taxonoccurrence_originaldetermination_id FOREIGN KEY (originaldetermination_id)
181
      REFERENCES taxondetermination (taxondetermination_id) MATCH SIMPLE
182
      ON UPDATE CASCADE ON DELETE CASCADE,
175 183
  CONSTRAINT taxonoccurrence_reference_id FOREIGN KEY (reference_id)
176 184
      REFERENCES reference (reference_id) MATCH SIMPLE
177 185
      ON UPDATE CASCADE ON DELETE CASCADE

Also available in: Unified diff