| 916 |
916 |
area double precision,
|
| 917 |
917 |
samplearea double precision,
|
| 918 |
918 |
subplotspacing double precision,
|
| 919 |
|
subplotmethod_id int(11)
|
|
919 |
subplotmethod_id int(11),
|
|
920 |
pointsperline int(11)
|
| 920 |
921 |
);
|
| 921 |
922 |
|
| 922 |
923 |
|
| ... | ... | |
| 1075 |
1076 |
|
| 1076 |
1077 |
|
| 1077 |
1078 |
--
|
|
1079 |
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
|
|
1080 |
--
|
|
1081 |
|
|
1082 |
|
|
1083 |
|
|
1084 |
|
|
1085 |
--
|
| 1078 |
1086 |
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
| 1079 |
1087 |
--
|
| 1080 |
1088 |
|
| ... | ... | |
| 4770 |
4778 |
-- Name: classcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
| 4771 |
4779 |
--
|
| 4772 |
4780 |
|
| 4773 |
|
ALTER TABLE classcontributor
|
| 4774 |
|
ADD CONSTRAINT classcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
| 4775 |
4781 |
|
| 4776 |
4782 |
|
|
4783 |
|
| 4777 |
4784 |
--
|
| 4778 |
4785 |
-- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
| 4779 |
4786 |
--
|
| ... | ... | |
| 5079 |
5086 |
-- Name: locationeventcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
| 5080 |
5087 |
--
|
| 5081 |
5088 |
|
| 5082 |
|
ALTER TABLE locationeventcontributor
|
| 5083 |
|
ADD CONSTRAINT locationeventcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
| 5084 |
5089 |
|
| 5085 |
5090 |
|
|
5091 |
|
| 5086 |
5092 |
--
|
| 5087 |
5093 |
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
| 5088 |
5094 |
--
|
| ... | ... | |
| 5102 |
5108 |
-- Name: locationeventsynonym_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
| 5103 |
5109 |
--
|
| 5104 |
5110 |
|
| 5105 |
|
ALTER TABLE locationeventsynonym
|
| 5106 |
|
ADD CONSTRAINT locationeventsynonym_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
| 5107 |
5111 |
|
| 5108 |
5112 |
|
|
5113 |
|
| 5109 |
5114 |
--
|
| 5110 |
5115 |
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
| 5111 |
5116 |
--
|
| ... | ... | |
| 5420 |
5425 |
-- Name: projectcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
| 5421 |
5426 |
--
|
| 5422 |
5427 |
|
| 5423 |
|
ALTER TABLE projectcontributor
|
| 5424 |
|
ADD CONSTRAINT projectcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
| 5425 |
5428 |
|
| 5426 |
5429 |
|
|
5430 |
|
| 5427 |
5431 |
--
|
| 5428 |
5432 |
-- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
| 5429 |
5433 |
--
|
| ... | ... | |
| 5592 |
5596 |
-- Name: taxondetermination_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
| 5593 |
5597 |
--
|
| 5594 |
5598 |
|
| 5595 |
|
ALTER TABLE taxondetermination
|
| 5596 |
|
ADD CONSTRAINT taxondetermination_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
| 5597 |
5599 |
|
| 5598 |
5600 |
|
|
5601 |
|
| 5599 |
5602 |
--
|
| 5600 |
5603 |
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
| 5601 |
5604 |
--
|
vegbien.sql: Added method.pointsperline. Rearranged ERD after removing role fkeys.