Revision 4740
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 2916 | 2916 |
rank taxonrank NOT NULL, |
| 2917 | 2917 |
verbatimrank text, |
| 2918 | 2918 |
taxonname text NOT NULL, |
| 2919 |
author_id integer, |
|
| 2919 | 2920 |
authority_id integer, |
| 2920 | 2921 |
description text, |
| 2921 | 2922 |
accessioncode text |
| ... | ... | |
| 2937 | 2938 |
|
| 2938 | 2939 |
|
| 2939 | 2940 |
-- |
| 2941 |
-- Name: COLUMN taxon.author_id; Type: COMMENT; Schema: public; Owner: - |
|
| 2942 |
-- |
|
| 2943 |
|
|
| 2944 |
COMMENT ON COLUMN taxon.author_id IS 'The author of the taxon name'; |
|
| 2945 |
|
|
| 2946 |
|
|
| 2947 |
-- |
|
| 2940 | 2948 |
-- Name: taxon_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2941 | 2949 |
-- |
| 2942 | 2950 |
|
| ... | ... | |
| 4598 | 4606 |
-- Name: taxon_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4599 | 4607 |
-- |
| 4600 | 4608 |
|
| 4601 |
CREATE UNIQUE INDEX taxon_unique ON taxon USING btree ((COALESCE(parent_id, 2147483647)), taxonname, rank, (COALESCE(scope_id, 2147483647)), (COALESCE(authority_id, 2147483647))); |
|
| 4609 |
CREATE UNIQUE INDEX taxon_unique ON taxon USING btree ((COALESCE(parent_id, 2147483647)), taxonname, rank, (COALESCE(scope_id, 2147483647)), (COALESCE(author_id, 2147483647)), (COALESCE(authority_id, 2147483647)));
|
|
| 4602 | 4610 |
|
| 4603 | 4611 |
|
| 4604 | 4612 |
-- |
| ... | ... | |
| 5549 | 5557 |
|
| 5550 | 5558 |
|
| 5551 | 5559 |
-- |
| 5560 |
-- Name: taxon_author_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5561 |
-- |
|
| 5562 |
|
|
| 5563 |
ALTER TABLE ONLY taxon |
|
| 5564 |
ADD CONSTRAINT taxon_author_id_fkey FOREIGN KEY (author_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5565 |
|
|
| 5566 |
|
|
| 5567 |
-- |
|
| 5552 | 5568 |
-- Name: taxon_authority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5553 | 5569 |
-- |
| 5554 | 5570 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxon: Added author_id for the author of the taxon name. This is distinct from authority_id, which is the authority used to determine which taxon name to apply.