Revision 1333
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1367 | 1367 |
|
| 1368 | 1368 |
|
| 1369 | 1369 |
|
| 1370 |
|
|
| 1371 |
|
|
| 1372 | 1370 |
-- |
| 1373 |
-- Name: plantconceptscope; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1374 |
-- |
|
| 1375 |
|
|
| 1376 |
CREATE TABLE plantconceptscope ( |
|
| 1377 |
plantconceptscope_id int(11) NOT NULL, |
|
| 1378 |
locationevent_id int(11), |
|
| 1379 |
project_id int(11), |
|
| 1380 |
namedplace_id int(11) |
|
| 1381 |
); |
|
| 1382 |
|
|
| 1383 |
|
|
| 1384 |
-- |
|
| 1385 |
-- Name: plantconceptscope_plantconceptscope_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1386 |
-- |
|
| 1387 |
|
|
| 1388 |
|
|
| 1389 |
|
|
| 1390 |
|
|
| 1391 |
-- |
|
| 1392 |
-- Name: plantconceptscope_plantconceptscope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1393 |
-- |
|
| 1394 |
|
|
| 1395 |
|
|
| 1396 |
|
|
| 1397 |
|
|
| 1398 |
|
|
| 1399 |
|
|
| 1400 |
-- |
|
| 1401 | 1371 |
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1402 | 1372 |
-- |
| 1403 | 1373 |
|
| ... | ... | |
| 1478 | 1448 |
|
| 1479 | 1449 |
|
| 1480 | 1450 |
|
| 1451 |
|
|
| 1452 |
|
|
| 1481 | 1453 |
-- |
| 1454 |
-- Name: plantnamescope; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1455 |
-- |
|
| 1456 |
|
|
| 1457 |
CREATE TABLE plantnamescope ( |
|
| 1458 |
plantnamescope_id int(11) NOT NULL, |
|
| 1459 |
locationevent_id int(11), |
|
| 1460 |
project_id int(11), |
|
| 1461 |
namedplace_id int(11) |
|
| 1462 |
); |
|
| 1463 |
|
|
| 1464 |
|
|
| 1465 |
-- |
|
| 1466 |
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1467 |
-- |
|
| 1468 |
|
|
| 1469 |
|
|
| 1470 |
|
|
| 1471 |
|
|
| 1472 |
-- |
|
| 1473 |
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1474 |
-- |
|
| 1475 |
|
|
| 1476 |
|
|
| 1477 |
|
|
| 1478 |
|
|
| 1479 |
|
|
| 1480 |
|
|
| 1481 |
-- |
|
| 1482 | 1482 |
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1483 | 1483 |
-- |
| 1484 | 1484 |
|
| ... | ... | |
| 2664 | 2664 |
|
| 2665 | 2665 |
|
| 2666 | 2666 |
-- |
| 2667 |
-- Name: plantconceptscope_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2667 |
-- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2668 | 2668 |
-- |
| 2669 | 2669 |
|
| 2670 | 2670 |
|
| 2671 | 2671 |
|
| 2672 | 2672 |
|
| 2673 | 2673 |
-- |
| 2674 |
-- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2674 |
-- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2675 | 2675 |
-- |
| 2676 | 2676 |
|
| 2677 | 2677 |
|
| 2678 | 2678 |
|
| 2679 | 2679 |
|
| 2680 | 2680 |
-- |
| 2681 |
-- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2681 |
-- Name: plantname_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2682 | 2682 |
-- |
| 2683 | 2683 |
|
| 2684 | 2684 |
|
| 2685 | 2685 |
|
| 2686 | 2686 |
|
| 2687 | 2687 |
-- |
| 2688 |
-- Name: plantname_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2688 |
-- Name: plantnamescope_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2689 | 2689 |
-- |
| 2690 | 2690 |
|
| 2691 | 2691 |
|
| ... | ... | |
| 3258 | 3258 |
|
| 3259 | 3259 |
|
| 3260 | 3260 |
-- |
| 3261 |
-- Name: plantconceptscope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3262 |
-- |
|
| 3263 |
|
|
| 3264 |
ALTER TABLE plantconceptscope |
|
| 3265 |
ADD CONSTRAINT plantconceptscope_pkey PRIMARY KEY (plantconceptscope_id); |
|
| 3266 |
|
|
| 3267 |
|
|
| 3268 |
-- |
|
| 3269 | 3261 |
-- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3270 | 3262 |
-- |
| 3271 | 3263 |
|
| ... | ... | |
| 3290 | 3282 |
|
| 3291 | 3283 |
|
| 3292 | 3284 |
-- |
| 3285 |
-- Name: plantnamescope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3286 |
-- |
|
| 3287 |
|
|
| 3288 |
ALTER TABLE plantnamescope |
|
| 3289 |
ADD CONSTRAINT plantnamescope_pkey PRIMARY KEY (plantnamescope_id); |
|
| 3290 |
|
|
| 3291 |
|
|
| 3292 |
-- |
|
| 3293 | 3293 |
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3294 | 3294 |
-- |
| 3295 | 3295 |
|
| ... | ... | |
| 3928 | 3928 |
|
| 3929 | 3929 |
|
| 3930 | 3930 |
-- |
| 3931 |
-- Name: fki_plantconceptscope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3931 |
-- Name: fki_plantname_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3932 | 3932 |
-- |
| 3933 | 3933 |
|
| 3934 |
CREATE INDEX fki_plantconceptscope_locationevent_id ON plantconceptscope (locationevent_id);
|
|
| 3934 |
CREATE INDEX fki_plantname_parent_id ON plantname (parent_id);
|
|
| 3935 | 3935 |
|
| 3936 | 3936 |
|
| 3937 | 3937 |
-- |
| 3938 |
-- Name: fki_plantconceptscope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3938 |
-- Name: fki_plantname_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3939 | 3939 |
-- |
| 3940 | 3940 |
|
| 3941 |
CREATE INDEX fki_plantconceptscope_namedplace_id ON plantconceptscope (namedplace_id);
|
|
| 3941 |
CREATE INDEX fki_plantname_scope_id ON plantname (scope_id);
|
|
| 3942 | 3942 |
|
| 3943 | 3943 |
|
| 3944 | 3944 |
-- |
| 3945 |
-- Name: fki_plantconceptscope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3945 |
-- Name: fki_plantnamescope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3946 | 3946 |
-- |
| 3947 | 3947 |
|
| 3948 |
CREATE INDEX fki_plantconceptscope_project_id ON plantconceptscope (project_id);
|
|
| 3948 |
CREATE INDEX fki_plantnamescope_locationevent_id ON plantnamescope (locationevent_id);
|
|
| 3949 | 3949 |
|
| 3950 | 3950 |
|
| 3951 | 3951 |
-- |
| 3952 |
-- Name: fki_plantname_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3952 |
-- Name: fki_plantnamescope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3953 | 3953 |
-- |
| 3954 | 3954 |
|
| 3955 |
CREATE INDEX fki_plantname_parent_id ON plantname (parent_id);
|
|
| 3955 |
CREATE INDEX fki_plantnamescope_namedplace_id ON plantnamescope (namedplace_id);
|
|
| 3956 | 3956 |
|
| 3957 | 3957 |
|
| 3958 | 3958 |
-- |
| 3959 |
-- Name: fki_plantname_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3959 |
-- Name: fki_plantnamescope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3960 | 3960 |
-- |
| 3961 | 3961 |
|
| 3962 |
CREATE INDEX fki_plantname_scope_id ON plantname (scope_id);
|
|
| 3962 |
CREATE INDEX fki_plantnamescope_project_id ON plantnamescope (project_id);
|
|
| 3963 | 3963 |
|
| 3964 | 3964 |
|
| 3965 | 3965 |
-- |
| ... | ... | |
| 4313 | 4313 |
|
| 4314 | 4314 |
|
| 4315 | 4315 |
-- |
| 4316 |
-- Name: plantconceptscope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4317 |
-- |
|
| 4318 |
|
|
| 4319 |
|
|
| 4320 |
|
|
| 4321 |
|
|
| 4322 |
-- |
|
| 4323 | 4316 |
-- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4324 | 4317 |
-- |
| 4325 | 4318 |
|
| ... | ... | |
| 4369 | 4362 |
|
| 4370 | 4363 |
|
| 4371 | 4364 |
-- |
| 4365 |
-- Name: plantnamescope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4366 |
-- |
|
| 4367 |
|
|
| 4368 |
|
|
| 4369 |
|
|
| 4370 |
|
|
| 4371 |
-- |
|
| 4372 | 4372 |
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4373 | 4373 |
-- |
| 4374 | 4374 |
|
| ... | ... | |
| 5219 | 5219 |
|
| 5220 | 5220 |
|
| 5221 | 5221 |
-- |
| 5222 |
-- Name: plantconceptscope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5223 |
-- |
|
| 5224 |
|
|
| 5225 |
ALTER TABLE plantconceptscope |
|
| 5226 |
ADD CONSTRAINT plantconceptscope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5227 |
|
|
| 5228 |
|
|
| 5229 |
-- |
|
| 5230 |
-- Name: plantconceptscope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5231 |
-- |
|
| 5232 |
|
|
| 5233 |
ALTER TABLE plantconceptscope |
|
| 5234 |
ADD CONSTRAINT plantconceptscope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5235 |
|
|
| 5236 |
|
|
| 5237 |
-- |
|
| 5238 |
-- Name: plantconceptscope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5239 |
-- |
|
| 5240 |
|
|
| 5241 |
ALTER TABLE plantconceptscope |
|
| 5242 |
ADD CONSTRAINT plantconceptscope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5243 |
|
|
| 5244 |
|
|
| 5245 |
-- |
|
| 5246 | 5222 |
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5247 | 5223 |
-- |
| 5248 | 5224 |
|
| ... | ... | |
| 5287 | 5263 |
-- |
| 5288 | 5264 |
|
| 5289 | 5265 |
ALTER TABLE plantname |
| 5290 |
ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantconceptscope(plantconceptscope_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5266 |
ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5291 | 5267 |
|
| 5292 | 5268 |
|
| 5293 | 5269 |
-- |
| 5270 |
-- Name: plantnamescope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5271 |
-- |
|
| 5272 |
|
|
| 5273 |
ALTER TABLE plantnamescope |
|
| 5274 |
ADD CONSTRAINT plantnamescope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5275 |
|
|
| 5276 |
|
|
| 5277 |
-- |
|
| 5278 |
-- Name: plantnamescope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5279 |
-- |
|
| 5280 |
|
|
| 5281 |
ALTER TABLE plantnamescope |
|
| 5282 |
ADD CONSTRAINT plantnamescope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5283 |
|
|
| 5284 |
|
|
| 5285 |
-- |
|
| 5286 |
-- Name: plantnamescope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5287 |
-- |
|
| 5288 |
|
|
| 5289 |
ALTER TABLE plantnamescope |
|
| 5290 |
ADD CONSTRAINT plantnamescope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5291 |
|
|
| 5292 |
|
|
| 5293 |
-- |
|
| 5294 | 5294 |
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5295 | 5295 |
-- |
| 5296 | 5296 |
|
| schemas/vegbien_empty.sql | ||
|---|---|---|
| 29 | 29 |
TRUNCATE partymember CASCADE; |
| 30 | 30 |
TRUNCATE plant CASCADE; |
| 31 | 31 |
TRUNCATE plantconcept CASCADE; |
| 32 |
TRUNCATE plantconceptscope CASCADE; |
|
| 33 | 32 |
TRUNCATE plantcorrelation CASCADE; |
| 34 | 33 |
TRUNCATE plantlineage CASCADE; |
| 35 | 34 |
TRUNCATE plantname CASCADE; |
| 35 |
TRUNCATE plantnamescope CASCADE; |
|
| 36 | 36 |
TRUNCATE plantobservation CASCADE; |
| 37 | 37 |
TRUNCATE plantstatus CASCADE; |
| 38 | 38 |
TRUNCATE plantusage CASCADE; |
| schemas/vegbien.sql | ||
|---|---|---|
| 1629 | 1629 |
ALTER SEQUENCE plantconcept_plantconcept_id_seq OWNED BY plantconcept.plantconcept_id; |
| 1630 | 1630 |
|
| 1631 | 1631 |
|
| 1632 |
SET default_with_oids = false; |
|
| 1633 |
|
|
| 1634 | 1632 |
-- |
| 1635 |
-- Name: plantconceptscope; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1636 |
-- |
|
| 1637 |
|
|
| 1638 |
CREATE TABLE plantconceptscope ( |
|
| 1639 |
plantconceptscope_id integer NOT NULL, |
|
| 1640 |
locationevent_id integer, |
|
| 1641 |
project_id integer, |
|
| 1642 |
namedplace_id integer |
|
| 1643 |
); |
|
| 1644 |
|
|
| 1645 |
|
|
| 1646 |
-- |
|
| 1647 |
-- Name: plantconceptscope_plantconceptscope_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1648 |
-- |
|
| 1649 |
|
|
| 1650 |
CREATE SEQUENCE plantconceptscope_plantconceptscope_id_seq |
|
| 1651 |
START WITH 1 |
|
| 1652 |
INCREMENT BY 1 |
|
| 1653 |
NO MINVALUE |
|
| 1654 |
NO MAXVALUE |
|
| 1655 |
CACHE 1; |
|
| 1656 |
|
|
| 1657 |
|
|
| 1658 |
-- |
|
| 1659 |
-- Name: plantconceptscope_plantconceptscope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1660 |
-- |
|
| 1661 |
|
|
| 1662 |
ALTER SEQUENCE plantconceptscope_plantconceptscope_id_seq OWNED BY plantconceptscope.plantconceptscope_id; |
|
| 1663 |
|
|
| 1664 |
|
|
| 1665 |
SET default_with_oids = true; |
|
| 1666 |
|
|
| 1667 |
-- |
|
| 1668 | 1633 |
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1669 | 1634 |
-- |
| 1670 | 1635 |
|
| ... | ... | |
| 1760 | 1725 |
ALTER SEQUENCE plantname_plantname_id_seq OWNED BY plantname.plantname_id; |
| 1761 | 1726 |
|
| 1762 | 1727 |
|
| 1728 |
SET default_with_oids = false; |
|
| 1729 |
|
|
| 1763 | 1730 |
-- |
| 1731 |
-- Name: plantnamescope; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1732 |
-- |
|
| 1733 |
|
|
| 1734 |
CREATE TABLE plantnamescope ( |
|
| 1735 |
plantnamescope_id integer NOT NULL, |
|
| 1736 |
locationevent_id integer, |
|
| 1737 |
project_id integer, |
|
| 1738 |
namedplace_id integer |
|
| 1739 |
); |
|
| 1740 |
|
|
| 1741 |
|
|
| 1742 |
-- |
|
| 1743 |
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1744 |
-- |
|
| 1745 |
|
|
| 1746 |
CREATE SEQUENCE plantnamescope_plantnamescope_id_seq |
|
| 1747 |
START WITH 1 |
|
| 1748 |
INCREMENT BY 1 |
|
| 1749 |
NO MINVALUE |
|
| 1750 |
NO MAXVALUE |
|
| 1751 |
CACHE 1; |
|
| 1752 |
|
|
| 1753 |
|
|
| 1754 |
-- |
|
| 1755 |
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1756 |
-- |
|
| 1757 |
|
|
| 1758 |
ALTER SEQUENCE plantnamescope_plantnamescope_id_seq OWNED BY plantnamescope.plantnamescope_id; |
|
| 1759 |
|
|
| 1760 |
|
|
| 1761 |
SET default_with_oids = true; |
|
| 1762 |
|
|
| 1763 |
-- |
|
| 1764 | 1764 |
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1765 | 1765 |
-- |
| 1766 | 1766 |
|
| ... | ... | |
| 3076 | 3076 |
|
| 3077 | 3077 |
|
| 3078 | 3078 |
-- |
| 3079 |
-- Name: plantconceptscope_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3080 |
-- |
|
| 3081 |
|
|
| 3082 |
ALTER TABLE plantconceptscope ALTER COLUMN plantconceptscope_id SET DEFAULT nextval('plantconceptscope_plantconceptscope_id_seq'::regclass);
|
|
| 3083 |
|
|
| 3084 |
|
|
| 3085 |
-- |
|
| 3086 | 3079 |
-- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: - |
| 3087 | 3080 |
-- |
| 3088 | 3081 |
|
| ... | ... | |
| 3104 | 3097 |
|
| 3105 | 3098 |
|
| 3106 | 3099 |
-- |
| 3100 |
-- Name: plantnamescope_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3101 |
-- |
|
| 3102 |
|
|
| 3103 |
ALTER TABLE plantnamescope ALTER COLUMN plantnamescope_id SET DEFAULT nextval('plantnamescope_plantnamescope_id_seq'::regclass);
|
|
| 3104 |
|
|
| 3105 |
|
|
| 3106 |
-- |
|
| 3107 | 3107 |
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: - |
| 3108 | 3108 |
-- |
| 3109 | 3109 |
|
| ... | ... | |
| 3670 | 3670 |
|
| 3671 | 3671 |
|
| 3672 | 3672 |
-- |
| 3673 |
-- Name: plantconceptscope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3674 |
-- |
|
| 3675 |
|
|
| 3676 |
ALTER TABLE ONLY plantconceptscope |
|
| 3677 |
ADD CONSTRAINT plantconceptscope_pkey PRIMARY KEY (plantconceptscope_id); |
|
| 3678 |
|
|
| 3679 |
|
|
| 3680 |
-- |
|
| 3681 | 3673 |
-- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3682 | 3674 |
-- |
| 3683 | 3675 |
|
| ... | ... | |
| 3702 | 3694 |
|
| 3703 | 3695 |
|
| 3704 | 3696 |
-- |
| 3697 |
-- Name: plantnamescope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3698 |
-- |
|
| 3699 |
|
|
| 3700 |
ALTER TABLE ONLY plantnamescope |
|
| 3701 |
ADD CONSTRAINT plantnamescope_pkey PRIMARY KEY (plantnamescope_id); |
|
| 3702 |
|
|
| 3703 |
|
|
| 3704 |
-- |
|
| 3705 | 3705 |
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3706 | 3706 |
-- |
| 3707 | 3707 |
|
| ... | ... | |
| 4340 | 4340 |
|
| 4341 | 4341 |
|
| 4342 | 4342 |
-- |
| 4343 |
-- Name: fki_plantconceptscope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4343 |
-- Name: fki_plantname_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4344 | 4344 |
-- |
| 4345 | 4345 |
|
| 4346 |
CREATE INDEX fki_plantconceptscope_locationevent_id ON plantconceptscope USING btree (locationevent_id);
|
|
| 4346 |
CREATE INDEX fki_plantname_parent_id ON plantname USING btree (parent_id);
|
|
| 4347 | 4347 |
|
| 4348 | 4348 |
|
| 4349 | 4349 |
-- |
| 4350 |
-- Name: fki_plantconceptscope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4350 |
-- Name: fki_plantname_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4351 | 4351 |
-- |
| 4352 | 4352 |
|
| 4353 |
CREATE INDEX fki_plantconceptscope_namedplace_id ON plantconceptscope USING btree (namedplace_id);
|
|
| 4353 |
CREATE INDEX fki_plantname_scope_id ON plantname USING btree (scope_id);
|
|
| 4354 | 4354 |
|
| 4355 | 4355 |
|
| 4356 | 4356 |
-- |
| 4357 |
-- Name: fki_plantconceptscope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4357 |
-- Name: fki_plantnamescope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4358 | 4358 |
-- |
| 4359 | 4359 |
|
| 4360 |
CREATE INDEX fki_plantconceptscope_project_id ON plantconceptscope USING btree (project_id);
|
|
| 4360 |
CREATE INDEX fki_plantnamescope_locationevent_id ON plantnamescope USING btree (locationevent_id);
|
|
| 4361 | 4361 |
|
| 4362 | 4362 |
|
| 4363 | 4363 |
-- |
| 4364 |
-- Name: fki_plantname_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4364 |
-- Name: fki_plantnamescope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4365 | 4365 |
-- |
| 4366 | 4366 |
|
| 4367 |
CREATE INDEX fki_plantname_parent_id ON plantname USING btree (parent_id);
|
|
| 4367 |
CREATE INDEX fki_plantnamescope_namedplace_id ON plantnamescope USING btree (namedplace_id);
|
|
| 4368 | 4368 |
|
| 4369 | 4369 |
|
| 4370 | 4370 |
-- |
| 4371 |
-- Name: fki_plantname_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4371 |
-- Name: fki_plantnamescope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4372 | 4372 |
-- |
| 4373 | 4373 |
|
| 4374 |
CREATE INDEX fki_plantname_scope_id ON plantname USING btree (scope_id);
|
|
| 4374 |
CREATE INDEX fki_plantnamescope_project_id ON plantnamescope USING btree (project_id);
|
|
| 4375 | 4375 |
|
| 4376 | 4376 |
|
| 4377 | 4377 |
-- |
| ... | ... | |
| 4725 | 4725 |
|
| 4726 | 4726 |
|
| 4727 | 4727 |
-- |
| 4728 |
-- Name: plantconceptscope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4729 |
-- |
|
| 4730 |
|
|
| 4731 |
CREATE UNIQUE INDEX plantconceptscope_unique ON plantconceptscope USING btree ((COALESCE(locationevent_id, 0)), (COALESCE(project_id, 0)), (COALESCE(namedplace_id, 0))); |
|
| 4732 |
|
|
| 4733 |
|
|
| 4734 |
-- |
|
| 4735 | 4728 |
-- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4736 | 4729 |
-- |
| 4737 | 4730 |
|
| ... | ... | |
| 4781 | 4774 |
|
| 4782 | 4775 |
|
| 4783 | 4776 |
-- |
| 4777 |
-- Name: plantnamescope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4778 |
-- |
|
| 4779 |
|
|
| 4780 |
CREATE UNIQUE INDEX plantnamescope_unique ON plantnamescope USING btree ((COALESCE(locationevent_id, 0)), (COALESCE(project_id, 0)), (COALESCE(namedplace_id, 0))); |
|
| 4781 |
|
|
| 4782 |
|
|
| 4783 |
-- |
|
| 4784 | 4784 |
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4785 | 4785 |
-- |
| 4786 | 4786 |
|
| ... | ... | |
| 5649 | 5649 |
|
| 5650 | 5650 |
|
| 5651 | 5651 |
-- |
| 5652 |
-- Name: plantconceptscope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5653 |
-- |
|
| 5654 |
|
|
| 5655 |
ALTER TABLE ONLY plantconceptscope |
|
| 5656 |
ADD CONSTRAINT plantconceptscope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5657 |
|
|
| 5658 |
|
|
| 5659 |
-- |
|
| 5660 |
-- Name: plantconceptscope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5661 |
-- |
|
| 5662 |
|
|
| 5663 |
ALTER TABLE ONLY plantconceptscope |
|
| 5664 |
ADD CONSTRAINT plantconceptscope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5665 |
|
|
| 5666 |
|
|
| 5667 |
-- |
|
| 5668 |
-- Name: plantconceptscope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5669 |
-- |
|
| 5670 |
|
|
| 5671 |
ALTER TABLE ONLY plantconceptscope |
|
| 5672 |
ADD CONSTRAINT plantconceptscope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5673 |
|
|
| 5674 |
|
|
| 5675 |
-- |
|
| 5676 | 5652 |
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5677 | 5653 |
-- |
| 5678 | 5654 |
|
| ... | ... | |
| 5717 | 5693 |
-- |
| 5718 | 5694 |
|
| 5719 | 5695 |
ALTER TABLE ONLY plantname |
| 5720 |
ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantconceptscope(plantconceptscope_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5696 |
ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5721 | 5697 |
|
| 5722 | 5698 |
|
| 5723 | 5699 |
-- |
| 5700 |
-- Name: plantnamescope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5701 |
-- |
|
| 5702 |
|
|
| 5703 |
ALTER TABLE ONLY plantnamescope |
|
| 5704 |
ADD CONSTRAINT plantnamescope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5705 |
|
|
| 5706 |
|
|
| 5707 |
-- |
|
| 5708 |
-- Name: plantnamescope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5709 |
-- |
|
| 5710 |
|
|
| 5711 |
ALTER TABLE ONLY plantnamescope |
|
| 5712 |
ADD CONSTRAINT plantnamescope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5713 |
|
|
| 5714 |
|
|
| 5715 |
-- |
|
| 5716 |
-- Name: plantnamescope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5717 |
-- |
|
| 5718 |
|
|
| 5719 |
ALTER TABLE ONLY plantnamescope |
|
| 5720 |
ADD CONSTRAINT plantnamescope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5721 |
|
|
| 5722 |
|
|
| 5723 |
-- |
|
| 5724 | 5724 |
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5725 | 5725 |
-- |
| 5726 | 5726 |
|
Also available in: Unified diff
vegbien.sql: Renamed plantconceptscope to plantnamescope because it's now attached to plantname