Revision 555
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_ERD.my.sql | ||
|---|---|---|
| 168 | 168 |
emb_taxonoccurrence int(11), |
| 169 | 169 |
-- ... |
| 170 | 170 |
accessioncode character varying(255), |
| 171 |
currentdetermination_id int(11), |
|
| 172 |
originaldetermination_id int(11), |
|
| 173 | 171 |
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, |
|
| 177 | 172 |
CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) |
| 178 | 173 |
REFERENCES locationevent (locationevent_id) MATCH SIMPLE |
| 179 | 174 |
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, |
|
| 183 | 175 |
CONSTRAINT taxonoccurrence_reference_id FOREIGN KEY (reference_id) |
| 184 | 176 |
REFERENCES reference (reference_id) MATCH SIMPLE |
| 185 | 177 |
ON UPDATE CASCADE ON DELETE CASCADE |
Also available in: Unified diff
vegbien.sql: Removed taxonoccurrence.currentdetermination_id and originaldetermination_id because it's not possible to create a two-way pointer when the child-to-parent pointer is required (chicken-and-egg problem)