Revision 4729
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2380 | 2380 |
rank text NOT NULL, |
| 2381 | 2381 |
verbatimrank text, |
| 2382 | 2382 |
taxonname text NOT NULL, |
| 2383 |
authority text,
|
|
| 2383 |
authority_id int(11),
|
|
| 2384 | 2384 |
description text, |
| 2385 | 2385 |
accessioncode text |
| 2386 | 2386 |
); |
| ... | ... | |
| 4920 | 4920 |
|
| 4921 | 4921 |
|
| 4922 | 4922 |
-- |
| 4923 |
-- Name: taxon_authority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4924 |
-- |
|
| 4925 |
|
|
| 4926 |
|
|
| 4927 |
|
|
| 4928 |
|
|
| 4929 |
-- |
|
| 4923 | 4930 |
-- Name: taxon_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4924 | 4931 |
-- |
| 4925 | 4932 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2928 | 2928 |
rank taxonrank NOT NULL, |
| 2929 | 2929 |
verbatimrank text, |
| 2930 | 2930 |
taxonname text NOT NULL, |
| 2931 |
authority text,
|
|
| 2931 |
authority_id integer,
|
|
| 2932 | 2932 |
description text, |
| 2933 | 2933 |
accessioncode text |
| 2934 | 2934 |
); |
| ... | ... | |
| 4611 | 4611 |
-- Name: taxon_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4612 | 4612 |
-- |
| 4613 | 4613 |
|
| 4614 |
CREATE UNIQUE INDEX taxon_unique ON taxon USING btree ((COALESCE(parent_id, 2147483647)), taxonname, rank, (COALESCE(scope_id, 2147483647)), (COALESCE(authority, '\\N'::text)));
|
|
| 4614 |
CREATE UNIQUE INDEX taxon_unique ON taxon USING btree ((COALESCE(parent_id, 2147483647)), taxonname, rank, (COALESCE(scope_id, 2147483647)), (COALESCE(authority_id, 2147483647)));
|
|
| 4615 | 4615 |
|
| 4616 | 4616 |
|
| 4617 | 4617 |
-- |
| ... | ... | |
| 5554 | 5554 |
|
| 5555 | 5555 |
|
| 5556 | 5556 |
-- |
| 5557 |
-- Name: taxon_authority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5558 |
-- |
|
| 5559 |
|
|
| 5560 |
ALTER TABLE ONLY taxon |
|
| 5561 |
ADD CONSTRAINT taxon_authority_id_fkey FOREIGN KEY (authority_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5562 |
|
|
| 5563 |
|
|
| 5564 |
-- |
|
| 5557 | 5565 |
-- Name: taxon_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5558 | 5566 |
-- |
| 5559 | 5567 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxon: Made authority an fkey to reference instead of a text field