Revision 907
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1040 | 1040 |
covermethod_id int(11), |
| 1041 | 1041 |
coverdispersion text, |
| 1042 | 1042 |
autotaxoncover int(1), |
| 1043 |
plotmethod_id int(11),
|
|
| 1043 |
method_id int(11), |
|
| 1044 | 1044 |
methodnarrative text, |
| 1045 | 1045 |
taxonoccurrencearea double precision, |
| 1046 | 1046 |
stemsizelimit double precision, |
| ... | ... | |
| 1211 | 1211 |
|
| 1212 | 1212 |
|
| 1213 | 1213 |
-- |
| 1214 |
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1215 |
-- |
|
| 1216 |
|
|
| 1217 |
CREATE TABLE method ( |
|
| 1218 |
method_id int(11) NOT NULL, |
|
| 1219 |
reference_id int(11), |
|
| 1220 |
name text NOT NULL, |
|
| 1221 |
description text, |
|
| 1222 |
accessioncode text |
|
| 1223 |
); |
|
| 1224 |
|
|
| 1225 |
|
|
| 1226 |
-- |
|
| 1227 |
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1228 |
-- |
|
| 1229 |
|
|
| 1230 |
|
|
| 1231 |
|
|
| 1232 |
|
|
| 1233 |
-- |
|
| 1234 |
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1235 |
-- |
|
| 1236 |
|
|
| 1237 |
|
|
| 1238 |
|
|
| 1239 |
|
|
| 1240 |
-- |
|
| 1214 | 1241 |
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1215 | 1242 |
-- |
| 1216 | 1243 |
|
| ... | ... | |
| 1695 | 1722 |
|
| 1696 | 1723 |
|
| 1697 | 1724 |
-- |
| 1698 |
-- Name: plotmethod; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1699 |
-- |
|
| 1700 |
|
|
| 1701 |
CREATE TABLE plotmethod ( |
|
| 1702 |
plotmethod_id int(11) NOT NULL, |
|
| 1703 |
reference_id int(11), |
|
| 1704 |
name text NOT NULL, |
|
| 1705 |
description text, |
|
| 1706 |
accessioncode text |
|
| 1707 |
); |
|
| 1708 |
|
|
| 1709 |
|
|
| 1710 |
-- |
|
| 1711 |
-- Name: plotmethod_plotmethod_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1712 |
-- |
|
| 1713 |
|
|
| 1714 |
|
|
| 1715 |
|
|
| 1716 |
|
|
| 1717 |
-- |
|
| 1718 |
-- Name: plotmethod_plotmethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1719 |
-- |
|
| 1720 |
|
|
| 1721 |
|
|
| 1722 |
|
|
| 1723 |
|
|
| 1724 |
-- |
|
| 1725 | 1725 |
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1726 | 1726 |
-- |
| 1727 | 1727 |
|
| ... | ... | |
| 3165 | 3165 |
|
| 3166 | 3166 |
|
| 3167 | 3167 |
-- |
| 3168 |
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3169 |
-- |
|
| 3170 |
|
|
| 3171 |
|
|
| 3172 |
|
|
| 3173 |
|
|
| 3174 |
-- |
|
| 3168 | 3175 |
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: - |
| 3169 | 3176 |
-- |
| 3170 | 3177 |
|
| ... | ... | |
| 3277 | 3284 |
|
| 3278 | 3285 |
|
| 3279 | 3286 |
-- |
| 3280 |
-- Name: plotmethod_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3281 |
-- |
|
| 3282 |
|
|
| 3283 |
|
|
| 3284 |
|
|
| 3285 |
|
|
| 3286 |
-- |
|
| 3287 | 3287 |
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: - |
| 3288 | 3288 |
-- |
| 3289 | 3289 |
|
| ... | ... | |
| 3903 | 3903 |
|
| 3904 | 3904 |
|
| 3905 | 3905 |
-- |
| 3906 |
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3907 |
-- |
|
| 3908 |
|
|
| 3909 |
ALTER TABLE method |
|
| 3910 |
ADD CONSTRAINT method_pkey PRIMARY KEY (method_id); |
|
| 3911 |
|
|
| 3912 |
|
|
| 3913 |
-- |
|
| 3906 | 3914 |
-- Name: namedplace_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3907 | 3915 |
-- |
| 3908 | 3916 |
|
| ... | ... | |
| 4055 | 4063 |
|
| 4056 | 4064 |
|
| 4057 | 4065 |
-- |
| 4058 |
-- Name: plotmethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4059 |
-- |
|
| 4060 |
|
|
| 4061 |
ALTER TABLE plotmethod |
|
| 4062 |
ADD CONSTRAINT plotmethod_pkey PRIMARY KEY (plotmethod_id); |
|
| 4063 |
|
|
| 4064 |
|
|
| 4065 |
-- |
|
| 4066 | 4066 |
-- Name: project_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4067 | 4067 |
-- |
| 4068 | 4068 |
|
| ... | ... | |
| 4823 | 4823 |
|
| 4824 | 4824 |
|
| 4825 | 4825 |
-- |
| 4826 |
-- Name: fki_locationevent_plotmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4826 |
-- Name: fki_locationevent_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4827 | 4827 |
-- |
| 4828 | 4828 |
|
| 4829 |
CREATE INDEX fki_locationevent_plotmethod_id ON locationevent (plotmethod_id);
|
|
| 4829 |
CREATE INDEX fki_locationevent_method_id ON locationevent (method_id);
|
|
| 4830 | 4830 |
|
| 4831 | 4831 |
|
| 4832 | 4832 |
-- |
| 4833 |
-- Name: fki_method_reference_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4834 |
-- |
|
| 4835 |
|
|
| 4836 |
CREATE INDEX fki_method_reference_id ON method (reference_id); |
|
| 4837 |
|
|
| 4838 |
|
|
| 4839 |
-- |
|
| 4833 | 4840 |
-- Name: fki_plantconcept_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4834 | 4841 |
-- |
| 4835 | 4842 |
|
| ... | ... | |
| 4872 | 4879 |
|
| 4873 | 4880 |
|
| 4874 | 4881 |
-- |
| 4875 |
-- Name: fki_plotmethod_reference_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4876 |
-- |
|
| 4877 |
|
|
| 4878 |
CREATE INDEX fki_plotmethod_reference_id ON plotmethod (reference_id); |
|
| 4879 |
|
|
| 4880 |
|
|
| 4881 |
-- |
|
| 4882 | 4882 |
-- Name: fki_specimenreplicate_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4883 | 4883 |
-- |
| 4884 | 4884 |
|
| ... | ... | |
| 5054 | 5054 |
|
| 5055 | 5055 |
|
| 5056 | 5056 |
-- |
| 5057 |
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5058 |
-- |
|
| 5059 |
|
|
| 5060 |
CREATE UNIQUE INDEX method_accessioncode ON method (accessioncode); |
|
| 5061 |
|
|
| 5062 |
|
|
| 5063 |
-- |
|
| 5057 | 5064 |
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5058 | 5065 |
-- |
| 5059 | 5066 |
|
| ... | ... | |
| 5334 | 5341 |
|
| 5335 | 5342 |
|
| 5336 | 5343 |
-- |
| 5337 |
-- Name: plotmethod_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5338 |
-- |
|
| 5339 |
|
|
| 5340 |
CREATE UNIQUE INDEX plotmethod_accessioncode ON plotmethod (accessioncode); |
|
| 5341 |
|
|
| 5342 |
|
|
| 5343 |
-- |
|
| 5344 | 5344 |
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5345 | 5345 |
-- |
| 5346 | 5346 |
|
| ... | ... | |
| 6037 | 6037 |
|
| 6038 | 6038 |
|
| 6039 | 6039 |
-- |
| 6040 |
-- Name: locationevent_plotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6040 |
-- Name: locationevent_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6041 | 6041 |
-- |
| 6042 | 6042 |
|
| 6043 | 6043 |
ALTER TABLE locationevent |
| 6044 |
ADD CONSTRAINT locationevent_plotmethod_id FOREIGN KEY (plotmethod_id) REFERENCES plotmethod(plotmethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6044 |
ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6045 | 6045 |
|
| 6046 | 6046 |
|
| 6047 | 6047 |
-- |
| ... | ... | |
| 6123 | 6123 |
|
| 6124 | 6124 |
|
| 6125 | 6125 |
-- |
| 6126 |
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6127 |
-- |
|
| 6128 |
|
|
| 6129 |
|
|
| 6130 |
|
|
| 6131 |
|
|
| 6132 |
-- |
|
| 6126 | 6133 |
-- Name: namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6127 | 6134 |
-- |
| 6128 | 6135 |
|
| ... | ... | |
| 6356 | 6363 |
|
| 6357 | 6364 |
|
| 6358 | 6365 |
-- |
| 6359 |
-- Name: plotmethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6360 |
-- |
|
| 6361 |
|
|
| 6362 |
|
|
| 6363 |
|
|
| 6364 |
|
|
| 6365 |
-- |
|
| 6366 | 6366 |
-- Name: project_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6367 | 6367 |
-- |
| 6368 | 6368 |
|
Also available in: Unified diff
vegbien.sql: Renamed plotmethod to method