Revision 1327
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1461 | 1461 |
CREATE TABLE plantname ( |
| 1462 | 1462 |
plantname_id int(11) NOT NULL, |
| 1463 | 1463 |
plantname text NOT NULL, |
| 1464 |
reference_id int(11), |
|
| 1465 |
dateentered timestamp NULL , |
|
| 1466 | 1464 |
rank text NOT NULL |
| 1467 | 1465 |
); |
| 1468 | 1466 |
|
| ... | ... | |
| 4381 | 4379 |
|
| 4382 | 4380 |
|
| 4383 | 4381 |
-- |
| 4384 |
-- Name: plantname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4385 |
-- |
|
| 4386 |
|
|
| 4387 |
CREATE INDEX plantname_reference_id_x ON plantname (reference_id); |
|
| 4388 |
|
|
| 4389 |
|
|
| 4390 |
-- |
|
| 4391 | 4382 |
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4392 | 4383 |
-- |
| 4393 | 4384 |
|
| ... | ... | |
| 5316 | 5307 |
|
| 5317 | 5308 |
|
| 5318 | 5309 |
-- |
| 5319 |
-- Name: plantname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5320 |
-- |
|
| 5321 |
|
|
| 5322 |
|
|
| 5323 |
|
|
| 5324 |
|
|
| 5325 |
-- |
|
| 5326 | 5310 |
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5327 | 5311 |
-- |
| 5328 | 5312 |
|
Also available in: Unified diff
vegbien.sql: plantname: Removed datasource-specific fields to make this a globally-unique table (the datasource-specific fields belong in plantconcept)