Revision 5231
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2589 | 2589 |
|
| 2590 | 2590 |
|
| 2591 | 2591 |
-- |
| 2592 |
-- Name: taxonscope; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2593 |
-- |
|
| 2594 |
|
|
| 2595 |
CREATE TABLE taxonscope ( |
|
| 2596 |
taxonscope_id int(11) NOT NULL, |
|
| 2597 |
locationevent_id int(11), |
|
| 2598 |
project_id int(11), |
|
| 2599 |
place_id int(11) |
|
| 2600 |
); |
|
| 2601 |
|
|
| 2602 |
|
|
| 2603 |
-- |
|
| 2604 |
-- Name: TABLE taxonscope; Type: COMMENT; Schema: public; Owner: - |
|
| 2605 |
-- |
|
| 2606 |
|
|
| 2607 |
|
|
| 2608 |
|
|
| 2609 |
|
|
| 2610 |
-- |
|
| 2611 |
-- Name: taxonscope_taxonscope_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2612 |
-- |
|
| 2613 |
|
|
| 2614 |
|
|
| 2615 |
|
|
| 2616 |
|
|
| 2617 |
-- |
|
| 2618 |
-- Name: taxonscope_taxonscope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2619 |
-- |
|
| 2620 |
|
|
| 2621 |
|
|
| 2622 |
|
|
| 2623 |
|
|
| 2624 |
-- |
|
| 2625 | 2592 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2626 | 2593 |
-- |
| 2627 | 2594 |
|
| ... | ... | |
| 3121 | 3088 |
|
| 3122 | 3089 |
|
| 3123 | 3090 |
-- |
| 3124 |
-- Name: taxonscope_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3125 |
-- |
|
| 3126 |
|
|
| 3127 |
|
|
| 3128 |
|
|
| 3129 |
|
|
| 3130 |
-- |
|
| 3131 | 3091 |
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: - |
| 3132 | 3092 |
-- |
| 3133 | 3093 |
|
| ... | ... | |
| 3692 | 3652 |
|
| 3693 | 3653 |
|
| 3694 | 3654 |
-- |
| 3695 |
-- Name: taxonscope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3696 |
-- |
|
| 3697 |
|
|
| 3698 |
ALTER TABLE taxonscope |
|
| 3699 |
ADD CONSTRAINT taxonscope_pkey PRIMARY KEY (taxonscope_id); |
|
| 3700 |
|
|
| 3701 |
|
|
| 3702 |
-- |
|
| 3703 | 3655 |
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3704 | 3656 |
-- |
| 3705 | 3657 |
|
| ... | ... | |
| 4161 | 4113 |
|
| 4162 | 4114 |
|
| 4163 | 4115 |
-- |
| 4164 |
-- Name: taxonscope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4165 |
-- |
|
| 4166 |
|
|
| 4167 |
|
|
| 4168 |
|
|
| 4169 |
|
|
| 4170 |
-- |
|
| 4171 | 4116 |
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4172 | 4117 |
-- |
| 4173 | 4118 |
|
| ... | ... | |
| 5079 | 5024 |
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5080 | 5025 |
-- |
| 5081 | 5026 |
|
| 5082 |
ALTER TABLE taxonconcept |
|
| 5083 |
ADD CONSTRAINT taxonconcept_concept_reference_id_fkey FOREIGN KEY (concept_reference_id) REFERENCES taxonscope(taxonscope_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5084 | 5027 |
|
| 5085 | 5028 |
|
| 5029 |
|
|
| 5086 | 5030 |
-- |
| 5087 | 5031 |
-- Name: taxonconcept_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5088 | 5032 |
-- |
| ... | ... | |
| 5144 | 5088 |
|
| 5145 | 5089 |
|
| 5146 | 5090 |
-- |
| 5147 |
-- Name: taxonscope_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5148 |
-- |
|
| 5149 |
|
|
| 5150 |
|
|
| 5151 |
|
|
| 5152 |
|
|
| 5153 |
-- |
|
| 5154 |
-- Name: taxonscope_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5155 |
-- |
|
| 5156 |
|
|
| 5157 |
|
|
| 5158 |
|
|
| 5159 |
|
|
| 5160 |
-- |
|
| 5161 |
-- Name: taxonscope_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5162 |
-- |
|
| 5163 |
|
|
| 5164 |
|
|
| 5165 |
|
|
| 5166 |
|
|
| 5167 |
-- |
|
| 5168 | 5091 |
-- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5169 | 5092 |
-- |
| 5170 | 5093 |
|
Also available in: Unified diff
schemas/vegbien.sql: concept_reference_id: Made it an fkey to party instead of taxonscope, because this is now the entity that defined the taxon concept, and is no longer specific to morphospecies. Removed no longer used table taxonscope.