Revision 553
Added by Aaron Marcuse-Kubitza almost 13 years ago
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
vegbien.sql: Added taxonoccurrence.currentdetermination_id and originaldetermination_id