Revision 1104
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1114 | 1114 |
methodgrowthform_id int(11) NOT NULL, |
| 1115 | 1115 |
method_id int(11) NOT NULL, |
| 1116 | 1116 |
growthform_id int(11) NOT NULL, |
| 1117 |
included int(1) DEFAULT true NOT NULL |
|
| 1117 |
included int(1) DEFAULT true NOT NULL, |
|
| 1118 |
growthformmethod_id int(11) |
|
| 1118 | 1119 |
); |
| 1119 | 1120 |
|
| 1120 | 1121 |
|
| ... | ... | |
| 1126 | 1127 |
|
| 1127 | 1128 |
|
| 1128 | 1129 |
-- |
| 1130 |
-- Name: COLUMN methodgrowthform.growthformmethod_id; Type: COMMENT; Schema: public; Owner: - |
|
| 1131 |
-- |
|
| 1132 |
|
|
| 1133 |
|
|
| 1134 |
|
|
| 1135 |
|
|
| 1136 |
-- |
|
| 1129 | 1137 |
-- Name: methodgrowthform_methodgrowthform_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1130 | 1138 |
-- |
| 1131 | 1139 |
|
| ... | ... | |
| 3957 | 3965 |
|
| 3958 | 3966 |
|
| 3959 | 3967 |
-- |
| 3968 |
-- Name: fki_methodgrowthform_growthformmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3969 |
-- |
|
| 3970 |
|
|
| 3971 |
CREATE INDEX fki_methodgrowthform_growthformmethod_id ON methodgrowthform (growthformmethod_id); |
|
| 3972 |
|
|
| 3973 |
|
|
| 3974 |
-- |
|
| 3960 | 3975 |
-- Name: fki_methodgrowthform_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3961 | 3976 |
-- |
| 3962 | 3977 |
|
| ... | ... | |
| 5168 | 5183 |
|
| 5169 | 5184 |
|
| 5170 | 5185 |
-- |
| 5186 |
-- Name: methodgrowthform_growthformmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5187 |
-- |
|
| 5188 |
|
|
| 5189 |
ALTER TABLE methodgrowthform |
|
| 5190 |
ADD CONSTRAINT methodgrowthform_growthformmethod_id FOREIGN KEY (growthformmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; |
|
| 5191 |
|
|
| 5192 |
|
|
| 5193 |
-- |
|
| 5171 | 5194 |
-- Name: methodgrowthform_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5172 | 5195 |
-- |
| 5173 | 5196 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1283 | 1283 |
methodgrowthform_id integer NOT NULL, |
| 1284 | 1284 |
method_id integer NOT NULL, |
| 1285 | 1285 |
growthform_id integer NOT NULL, |
| 1286 |
included boolean DEFAULT true NOT NULL |
|
| 1286 |
included boolean DEFAULT true NOT NULL, |
|
| 1287 |
growthformmethod_id integer |
|
| 1287 | 1288 |
); |
| 1288 | 1289 |
|
| 1289 | 1290 |
|
| ... | ... | |
| 1295 | 1296 |
|
| 1296 | 1297 |
|
| 1297 | 1298 |
-- |
| 1299 |
-- Name: COLUMN methodgrowthform.growthformmethod_id; Type: COMMENT; Schema: public; Owner: - |
|
| 1300 |
-- |
|
| 1301 |
|
|
| 1302 |
COMMENT ON COLUMN methodgrowthform.growthformmethod_id IS 'The method used to sample just this growthform, distinct from the main method.'; |
|
| 1303 |
|
|
| 1304 |
|
|
| 1305 |
-- |
|
| 1298 | 1306 |
-- Name: methodgrowthform_methodgrowthform_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1299 | 1307 |
-- |
| 1300 | 1308 |
|
| ... | ... | |
| 4326 | 4334 |
|
| 4327 | 4335 |
|
| 4328 | 4336 |
-- |
| 4337 |
-- Name: fki_methodgrowthform_growthformmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4338 |
-- |
|
| 4339 |
|
|
| 4340 |
CREATE INDEX fki_methodgrowthform_growthformmethod_id ON methodgrowthform USING btree (growthformmethod_id); |
|
| 4341 |
|
|
| 4342 |
|
|
| 4343 |
-- |
|
| 4329 | 4344 |
-- Name: fki_methodgrowthform_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4330 | 4345 |
-- |
| 4331 | 4346 |
|
| ... | ... | |
| 5551 | 5566 |
|
| 5552 | 5567 |
|
| 5553 | 5568 |
-- |
| 5569 |
-- Name: methodgrowthform_growthformmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5570 |
-- |
|
| 5571 |
|
|
| 5572 |
ALTER TABLE ONLY methodgrowthform |
|
| 5573 |
ADD CONSTRAINT methodgrowthform_growthformmethod_id FOREIGN KEY (growthformmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; |
|
| 5574 |
|
|
| 5575 |
|
|
| 5576 |
-- |
|
| 5554 | 5577 |
-- Name: methodgrowthform_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5555 | 5578 |
-- |
| 5556 | 5579 |
|
Also available in: Unified diff
vegbien.sql: Added methodgrowthform.growthformmethod_id for specifying a method used by just the growthform