Revision 615
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_ERD.sql | ||
|---|---|---|
| 285 | 285 |
collectioncode_dwc character varying(255), |
| 286 | 286 |
catalognumber_dwc character varying(255), |
| 287 | 287 |
collectiondate timestamp with time zone, |
| 288 |
collector_id integer, |
|
| 289 | 288 |
museum_id integer, |
| 290 | 289 |
sourceaccessioncode character varying(100), |
| 291 | 290 |
accessioncode character varying(255), |
| ... | ... | |
| 293 | 292 |
verbatimcollectorname character varying(255), |
| 294 | 293 |
authorspecimencode character varying(20), |
| 295 | 294 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 296 |
CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id) |
|
| 297 |
REFERENCES party (party_id) MATCH SIMPLE |
|
| 298 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 299 | 295 |
CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id) |
| 300 | 296 |
REFERENCES party (party_id) MATCH SIMPLE |
| 301 | 297 |
ON UPDATE CASCADE ON DELETE CASCADE, |
Also available in: Unified diff
vegbien.sql: Removed no longer needed specimen.collector_id