Revision 1162
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 906 | 906 |
width double precision, |
| 907 | 907 |
radius double precision, |
| 908 | 908 |
area double precision, |
| 909 |
samplearea double precision |
|
| 909 |
samplearea double precision, |
|
| 910 |
subplotspacing double precision, |
|
| 911 |
subplotmethod_id int(11) |
|
| 910 | 912 |
); |
| 911 | 913 |
|
| 912 | 914 |
|
| ... | ... | |
| 1051 | 1053 |
|
| 1052 | 1054 |
|
| 1053 | 1055 |
-- |
| 1056 |
-- Name: COLUMN method.subplotspacing; Type: COMMENT; Schema: public; Owner: - |
|
| 1057 |
-- |
|
| 1058 |
|
|
| 1059 |
|
|
| 1060 |
|
|
| 1061 |
|
|
| 1062 |
-- |
|
| 1063 |
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: - |
|
| 1064 |
-- |
|
| 1065 |
|
|
| 1066 |
|
|
| 1067 |
|
|
| 1068 |
|
|
| 1069 |
-- |
|
| 1054 | 1070 |
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1055 | 1071 |
-- |
| 1056 | 1072 |
|
| ... | ... | |
| 3895 | 3911 |
|
| 3896 | 3912 |
|
| 3897 | 3913 |
-- |
| 3914 |
-- Name: fki_method_subplotmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3915 |
-- |
|
| 3916 |
|
|
| 3917 |
CREATE INDEX fki_method_subplotmethod_id ON method (subplotmethod_id); |
|
| 3918 |
|
|
| 3919 |
|
|
| 3920 |
-- |
|
| 3898 | 3921 |
-- Name: fki_methodtaxonclass_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3899 | 3922 |
-- |
| 3900 | 3923 |
|
| ... | ... | |
| 5092 | 5115 |
|
| 5093 | 5116 |
|
| 5094 | 5117 |
-- |
| 5118 |
-- Name: method_subplotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5119 |
-- |
|
| 5120 |
|
|
| 5121 |
ALTER TABLE method |
|
| 5122 |
ADD CONSTRAINT method_subplotmethod_id FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; |
|
| 5123 |
|
|
| 5124 |
|
|
| 5125 |
-- |
|
| 5095 | 5126 |
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5096 | 5127 |
-- |
| 5097 | 5128 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1065 | 1065 |
width double precision, |
| 1066 | 1066 |
radius double precision, |
| 1067 | 1067 |
area double precision, |
| 1068 |
samplearea double precision |
|
| 1068 |
samplearea double precision, |
|
| 1069 |
subplotspacing double precision, |
|
| 1070 |
subplotmethod_id integer |
|
| 1069 | 1071 |
); |
| 1070 | 1072 |
|
| 1071 | 1073 |
|
| ... | ... | |
| 1235 | 1237 |
|
| 1236 | 1238 |
|
| 1237 | 1239 |
-- |
| 1240 |
-- Name: COLUMN method.subplotspacing; Type: COMMENT; Schema: public; Owner: - |
|
| 1241 |
-- |
|
| 1242 |
|
|
| 1243 |
COMMENT ON COLUMN method.subplotspacing IS 'Spacing in lengthunits between adjacent subplots, lines (line-intercept data), or points (point-intercept data).'; |
|
| 1244 |
|
|
| 1245 |
|
|
| 1246 |
-- |
|
| 1247 |
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: - |
|
| 1248 |
-- |
|
| 1249 |
|
|
| 1250 |
COMMENT ON COLUMN method.subplotmethod_id IS 'Method to use for each subplot/line/point, which will specify subplot size, line length, etc.'; |
|
| 1251 |
|
|
| 1252 |
|
|
| 1253 |
-- |
|
| 1238 | 1254 |
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1239 | 1255 |
-- |
| 1240 | 1256 |
|
| ... | ... | |
| 4280 | 4296 |
|
| 4281 | 4297 |
|
| 4282 | 4298 |
-- |
| 4299 |
-- Name: fki_method_subplotmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4300 |
-- |
|
| 4301 |
|
|
| 4302 |
CREATE INDEX fki_method_subplotmethod_id ON method USING btree (subplotmethod_id); |
|
| 4303 |
|
|
| 4304 |
|
|
| 4305 |
-- |
|
| 4283 | 4306 |
-- Name: fki_methodtaxonclass_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4284 | 4307 |
-- |
| 4285 | 4308 |
|
| ... | ... | |
| 5491 | 5514 |
|
| 5492 | 5515 |
|
| 5493 | 5516 |
-- |
| 5517 |
-- Name: method_subplotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5518 |
-- |
|
| 5519 |
|
|
| 5520 |
ALTER TABLE ONLY method |
|
| 5521 |
ADD CONSTRAINT method_subplotmethod_id FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; |
|
| 5522 |
|
|
| 5523 |
|
|
| 5524 |
-- |
|
| 5494 | 5525 |
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5495 | 5526 |
-- |
| 5496 | 5527 |
|
Also available in: Unified diff
vegbien.sql: method: Added subplotspacing and subplotmethod_id