Revision 6179
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 89 | 89 |
|
| 90 | 90 |
|
| 91 | 91 |
-- |
| 92 |
-- Name: referencetype; Type: TYPE; Schema: public; Owner: -
|
|
| 92 |
-- Name: relationship; Type: TYPE; Schema: public; Owner: -
|
|
| 93 | 93 |
-- |
| 94 | 94 |
|
| 95 | 95 |
|
| 96 | 96 |
|
| 97 | 97 |
|
| 98 | 98 |
-- |
| 99 |
-- Name: TYPE referencetype; Type: COMMENT; Schema: public; Owner: -
|
|
| 99 |
-- Name: role; Type: TYPE; Schema: public; Owner: -
|
|
| 100 | 100 |
-- |
| 101 | 101 |
|
| 102 | 102 |
|
| 103 | 103 |
|
| 104 | 104 |
|
| 105 | 105 |
-- |
| 106 |
-- Name: relationship; Type: TYPE; Schema: public; Owner: -
|
|
| 106 |
-- Name: sourcetype; Type: TYPE; Schema: public; Owner: -
|
|
| 107 | 107 |
-- |
| 108 | 108 |
|
| 109 | 109 |
|
| 110 | 110 |
|
| 111 | 111 |
|
| 112 | 112 |
-- |
| 113 |
-- Name: role; Type: TYPE; Schema: public; Owner: -
|
|
| 113 |
-- Name: TYPE sourcetype; Type: COMMENT; Schema: public; Owner: -
|
|
| 114 | 114 |
-- |
| 115 | 115 |
|
| 116 | 116 |
|
| ... | ... | |
| 257 | 257 |
|
| 258 | 258 |
|
| 259 | 259 |
-- |
| 260 |
-- Name: party_reference_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 260 |
-- Name: party_source_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 261 | 261 |
-- |
| 262 | 262 |
|
| 263 | 263 |
|
| ... | ... | |
| 280 | 280 |
|
| 281 | 281 |
CREATE TABLE place ( |
| 282 | 282 |
place_id int(11) NOT NULL, |
| 283 |
reference_id int(11) NOT NULL,
|
|
| 283 |
source_id int(11) NOT NULL,
|
|
| 284 | 284 |
placecode text, |
| 285 | 285 |
canon_place_id int(11), |
| 286 | 286 |
matched_place_id int(11), |
| ... | ... | |
| 291 | 291 |
stateprovince text, |
| 292 | 292 |
county text, |
| 293 | 293 |
description text, |
| 294 |
georeference_valid int(1),
|
|
| 294 |
geosource_valid int(1),
|
|
| 295 | 295 |
distance_to_country_m double precision, |
| 296 | 296 |
distance_to_state_m double precision |
| 297 | 297 |
); |
| ... | ... | |
| 347 | 347 |
|
| 348 | 348 |
|
| 349 | 349 |
-- |
| 350 |
-- Name: reference_by_shortname(text); Type: FUNCTION; Schema: public; Owner: -
|
|
| 350 |
-- Name: source_by_shortname(text); Type: FUNCTION; Schema: public; Owner: -
|
|
| 351 | 351 |
-- |
| 352 | 352 |
|
| 353 | 353 |
|
| ... | ... | |
| 415 | 415 |
|
| 416 | 416 |
CREATE TABLE taxonlabel ( |
| 417 | 417 |
taxonlabel_id int(11) NOT NULL, |
| 418 |
reference_id int(11) NOT NULL,
|
|
| 418 |
source_id int(11) NOT NULL,
|
|
| 419 | 419 |
sourceaccessioncode text, |
| 420 | 420 |
creationdate date, |
| 421 | 421 |
taxonstatus text, |
| ... | ... | |
| 438 | 438 |
|
| 439 | 439 |
|
| 440 | 440 |
-- |
| 441 |
-- Name: COLUMN taxonlabel.reference_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 441 |
-- Name: COLUMN taxonlabel.source_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 442 | 442 |
-- |
| 443 | 443 |
|
| 444 | 444 |
|
| ... | ... | |
| 589 | 589 |
|
| 590 | 590 |
CREATE TABLE aggregateoccurrence ( |
| 591 | 591 |
aggregateoccurrence_id int(11) NOT NULL, |
| 592 |
reference_id int(11) NOT NULL,
|
|
| 592 |
source_id int(11) NOT NULL,
|
|
| 593 | 593 |
sourceaccessioncode text, |
| 594 | 594 |
taxonoccurrence_id int(11), |
| 595 | 595 |
collectiondate date, |
| ... | ... | |
| 660 | 660 |
county text, |
| 661 | 661 |
`decimalLatitude` double precision, |
| 662 | 662 |
`decimalLongitude` double precision, |
| 663 |
`georeferenceValid` int(1),
|
|
| 663 |
`geosourceValid` int(1),
|
|
| 664 | 664 |
`isNewWorld` int(1), |
| 665 | 665 |
`distanceToCountry_km` double precision, |
| 666 | 666 |
`distanceToStateProvince_km` double precision, |
| ... | ... | |
| 699 | 699 |
county text, |
| 700 | 700 |
`decimalLatitude` double precision, |
| 701 | 701 |
`decimalLongitude` double precision, |
| 702 |
`georeferenceValid` int(1),
|
|
| 702 |
`geosourceValid` int(1),
|
|
| 703 | 703 |
`isNewWorld` int(1), |
| 704 | 704 |
`distanceToCountry_km` double precision, |
| 705 | 705 |
`distanceToStateProvince_km` double precision, |
| ... | ... | |
| 744 | 744 |
|
| 745 | 745 |
CREATE TABLE coordinates ( |
| 746 | 746 |
coordinates_id int(11) NOT NULL, |
| 747 |
reference_id int(11) NOT NULL,
|
|
| 747 |
source_id int(11) NOT NULL,
|
|
| 748 | 748 |
latitude_deg double precision NOT NULL, |
| 749 | 749 |
longitude_deg double precision NOT NULL, |
| 750 | 750 |
verbatimlatitude text, |
| ... | ... | |
| 785 | 785 |
|
| 786 | 786 |
CREATE TABLE location ( |
| 787 | 787 |
location_id int(11) NOT NULL, |
| 788 |
reference_id int(11) NOT NULL,
|
|
| 788 |
source_id int(11) NOT NULL,
|
|
| 789 | 789 |
sourceaccessioncode text, |
| 790 | 790 |
parent_id int(11), |
| 791 | 791 |
authorlocationcode text, |
| ... | ... | |
| 843 | 843 |
|
| 844 | 844 |
CREATE TABLE locationevent ( |
| 845 | 845 |
locationevent_id int(11) NOT NULL, |
| 846 |
reference_id int(11) NOT NULL,
|
|
| 846 |
source_id int(11) NOT NULL,
|
|
| 847 | 847 |
sourceaccessioncode text, |
| 848 | 848 |
parent_id int(11), |
| 849 | 849 |
location_id int(11), |
| ... | ... | |
| 953 | 953 |
|
| 954 | 954 |
CREATE TABLE method ( |
| 955 | 955 |
method_id int(11) NOT NULL, |
| 956 |
reference_id int(11) NOT NULL,
|
|
| 956 |
source_id int(11) NOT NULL,
|
|
| 957 | 957 |
name text, |
| 958 | 958 |
description text, |
| 959 | 959 |
diameterheight_m double precision, |
| ... | ... | |
| 988 | 988 |
|
| 989 | 989 |
|
| 990 | 990 |
-- |
| 991 |
-- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 991 |
-- Name: COLUMN method.source_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 992 | 992 |
-- |
| 993 | 993 |
|
| 994 | 994 |
|
| ... | ... | |
| 1119 | 1119 |
|
| 1120 | 1120 |
CREATE TABLE party ( |
| 1121 | 1121 |
party_id int(11) NOT NULL, |
| 1122 |
reference_id int(11) NOT NULL,
|
|
| 1122 |
source_id int(11) NOT NULL,
|
|
| 1123 | 1123 |
fullname text, |
| 1124 | 1124 |
salutation text, |
| 1125 | 1125 |
givenname text, |
| ... | ... | |
| 1143 | 1143 |
|
| 1144 | 1144 |
CREATE TABLE plantobservation ( |
| 1145 | 1145 |
plantobservation_id int(11) NOT NULL, |
| 1146 |
reference_id int(11) NOT NULL,
|
|
| 1146 |
source_id int(11) NOT NULL,
|
|
| 1147 | 1147 |
sourceaccessioncode text, |
| 1148 | 1148 |
aggregateoccurrence_id int(11), |
| 1149 | 1149 |
overallheight_m double precision, |
| ... | ... | |
| 1170 | 1170 |
|
| 1171 | 1171 |
|
| 1172 | 1172 |
-- |
| 1173 |
-- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 1173 |
-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 1174 | 1174 |
-- |
| 1175 | 1175 |
|
| 1176 |
CREATE TABLE reference (
|
|
| 1177 |
reference_id int(11) NOT NULL,
|
|
| 1176 |
CREATE TABLE source (
|
|
| 1177 |
source_id int(11) NOT NULL,
|
|
| 1178 | 1178 |
shortname text, |
| 1179 | 1179 |
`fulltext` text, |
| 1180 |
referencetype text,
|
|
| 1180 |
sourcetype text,
|
|
| 1181 | 1181 |
accesslevel text, |
| 1182 | 1182 |
accessconditions text, |
| 1183 | 1183 |
title text, |
| 1184 | 1184 |
titlesuperior text, |
| 1185 |
referencejournal_id int(11),
|
|
| 1185 |
sourcejournal_id int(11),
|
|
| 1186 | 1186 |
volume text, |
| 1187 | 1187 |
issue text, |
| 1188 | 1188 |
pagerange text, |
| ... | ... | |
| 1212 | 1212 |
|
| 1213 | 1213 |
CREATE TABLE stemobservation ( |
| 1214 | 1214 |
stemobservation_id int(11) NOT NULL, |
| 1215 |
reference_id int(11) NOT NULL,
|
|
| 1215 |
source_id int(11) NOT NULL,
|
|
| 1216 | 1216 |
sourceaccessioncode text, |
| 1217 | 1217 |
plantobservation_id int(11) NOT NULL, |
| 1218 | 1218 |
authorstemcode text, |
| ... | ... | |
| 1257 | 1257 |
party_id int(11), |
| 1258 | 1258 |
role text DEFAULT 'unknown' NOT NULL, |
| 1259 | 1259 |
determinationtype text, |
| 1260 |
reference_id int(11),
|
|
| 1260 |
source_id int(11),
|
|
| 1261 | 1261 |
isoriginal int(1) DEFAULT false NOT NULL, |
| 1262 | 1262 |
iscurrent int(1) DEFAULT false NOT NULL, |
| 1263 | 1263 |
taxonfit text, |
| ... | ... | |
| 1285 | 1285 |
|
| 1286 | 1286 |
CREATE TABLE taxonoccurrence ( |
| 1287 | 1287 |
taxonoccurrence_id int(11) NOT NULL, |
| 1288 |
reference_id int(11) NOT NULL,
|
|
| 1288 |
source_id int(11) NOT NULL,
|
|
| 1289 | 1289 |
sourceaccessioncode text, |
| 1290 | 1290 |
locationevent_id int(11), |
| 1291 | 1291 |
authortaxoncode text, |
| ... | ... | |
| 1507 | 1507 |
CREATE TABLE commconcept ( |
| 1508 | 1508 |
commconcept_id int(11) NOT NULL, |
| 1509 | 1509 |
commname_id int(11) NOT NULL, |
| 1510 |
reference_id int(11),
|
|
| 1510 |
source_id int(11),
|
|
| 1511 | 1511 |
commdescription text, |
| 1512 | 1512 |
commname text, |
| 1513 | 1513 |
accessioncode text |
| ... | ... | |
| 1645 | 1645 |
CREATE TABLE commname ( |
| 1646 | 1646 |
commname_id int(11) NOT NULL, |
| 1647 | 1647 |
commname text NOT NULL, |
| 1648 |
reference_id int(11),
|
|
| 1648 |
source_id int(11),
|
|
| 1649 | 1649 |
dateentered date |
| 1650 | 1650 |
); |
| 1651 | 1651 |
|
| ... | ... | |
| 1677 | 1677 |
CREATE TABLE commstatus ( |
| 1678 | 1678 |
commstatus_id int(11) NOT NULL, |
| 1679 | 1679 |
commconcept_id int(11) NOT NULL, |
| 1680 |
reference_id int(11),
|
|
| 1680 |
source_id int(11),
|
|
| 1681 | 1681 |
commconceptstatus text NOT NULL, |
| 1682 | 1682 |
commparent_id int(11), |
| 1683 | 1683 |
commlevel text, |
| ... | ... | |
| 1808 | 1808 |
|
| 1809 | 1809 |
CREATE TABLE covermethod ( |
| 1810 | 1810 |
covermethod_id int(11) NOT NULL, |
| 1811 |
reference_id int(11),
|
|
| 1811 |
source_id int(11),
|
|
| 1812 | 1812 |
covertype text NOT NULL, |
| 1813 | 1813 |
coverestimationmethod text, |
| 1814 | 1814 |
accessioncode text |
| ... | ... | |
| 2472 | 2472 |
|
| 2473 | 2473 |
CREATE TABLE project ( |
| 2474 | 2474 |
project_id int(11) NOT NULL, |
| 2475 |
reference_id int(11) NOT NULL,
|
|
| 2475 |
source_id int(11) NOT NULL,
|
|
| 2476 | 2476 |
sourceaccessioncode text, |
| 2477 | 2477 |
projectname text, |
| 2478 | 2478 |
projectdescription text, |
| ... | ... | |
| 2537 | 2537 |
|
| 2538 | 2538 |
|
| 2539 | 2539 |
-- |
| 2540 |
-- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2540 |
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2541 | 2541 |
-- |
| 2542 | 2542 |
|
| 2543 |
CREATE TABLE revision ( |
|
| 2544 |
revision_id int(11) NOT NULL, |
|
| 2545 |
tablename text NOT NULL, |
|
| 2546 |
tableattribute text NOT NULL, |
|
| 2547 |
tablerecord int(11) NOT NULL, |
|
| 2548 |
previousvaluetext text NOT NULL, |
|
| 2549 |
previousvaluetype text NOT NULL, |
|
| 2550 |
previousrevision_id int(11), |
|
| 2551 |
revisiondate date NOT NULL |
|
| 2552 |
); |
|
| 2543 | 2553 |
|
| 2544 | 2554 |
|
| 2555 |
-- |
|
| 2556 |
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2557 |
-- |
|
| 2545 | 2558 |
|
| 2559 |
|
|
| 2560 |
|
|
| 2561 |
|
|
| 2546 | 2562 |
-- |
| 2547 |
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2563 |
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2548 | 2564 |
-- |
| 2549 | 2565 |
|
| 2550 | 2566 |
|
| 2551 | 2567 |
|
| 2552 | 2568 |
|
| 2553 | 2569 |
-- |
| 2554 |
-- Name: reference_reference_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2570 |
-- Name: revision_revision_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2555 | 2571 |
-- |
| 2556 | 2572 |
|
| 2557 | 2573 |
|
| 2558 | 2574 |
|
| 2559 | 2575 |
-- |
| 2560 |
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2576 |
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2561 | 2577 |
-- |
| 2562 | 2578 |
|
| 2563 |
CREATE TABLE referencecontributor ( |
|
| 2564 |
referencecontributor_id int(11) NOT NULL, |
|
| 2565 |
reference_id int(11) NOT NULL, |
|
| 2566 |
referenceparty_id int(11) NOT NULL, |
|
| 2567 |
roletype text, |
|
| 2568 |
`position` int(11) |
|
| 2579 |
CREATE TABLE soilobs ( |
|
| 2580 |
soilobs_id int(11) NOT NULL, |
|
| 2581 |
locationevent_id int(11) NOT NULL, |
|
| 2582 |
horizon text DEFAULT 'unknown' NOT NULL, |
|
| 2583 |
description text, |
|
| 2584 |
depthtop_m double precision, |
|
| 2585 |
depthbottom_m double precision, |
|
| 2586 |
color text, |
|
| 2587 |
texture text, |
|
| 2588 |
organic_fraction double precision, |
|
| 2589 |
sand_fraction double precision, |
|
| 2590 |
silt_fraction double precision, |
|
| 2591 |
clay_fraction double precision, |
|
| 2592 |
coarse_fraction double precision, |
|
| 2593 |
ph double precision, |
|
| 2594 |
acidity_fraction double precision, |
|
| 2595 |
basesaturation_fraction double precision, |
|
| 2596 |
cationexchangecapacity_cmol_kg double precision, |
|
| 2597 |
conductivity double precision, |
|
| 2598 |
carbon_fraction double precision, |
|
| 2599 |
phosphorus_fraction double precision, |
|
| 2600 |
potassium_fraction double precision, |
|
| 2601 |
magnesium_fraction double precision, |
|
| 2602 |
nitrogen_fraction double precision, |
|
| 2603 |
calcium_fraction double precision, |
|
| 2604 |
sodium_fraction double precision |
|
| 2569 | 2605 |
); |
| 2570 | 2606 |
|
| 2571 | 2607 |
|
| 2572 | 2608 |
-- |
| 2573 |
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2609 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2574 | 2610 |
-- |
| 2575 | 2611 |
|
| 2576 | 2612 |
|
| 2577 | 2613 |
|
| 2578 | 2614 |
|
| 2579 | 2615 |
-- |
| 2580 |
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2616 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2581 | 2617 |
-- |
| 2582 | 2618 |
|
| 2583 | 2619 |
|
| 2584 | 2620 |
|
| 2585 | 2621 |
|
| 2586 | 2622 |
-- |
| 2587 |
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2623 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2588 | 2624 |
-- |
| 2589 | 2625 |
|
| 2590 | 2626 |
|
| 2591 | 2627 |
|
| 2592 | 2628 |
-- |
| 2593 |
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2629 |
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2594 | 2630 |
-- |
| 2595 | 2631 |
|
| 2596 |
CREATE TABLE referencejournal ( |
|
| 2597 |
referencejournal_id int(11) NOT NULL, |
|
| 2598 |
journal text NOT NULL, |
|
| 2599 |
issn text, |
|
| 2600 |
abbreviation text, |
|
| 2632 |
CREATE TABLE soiltaxon ( |
|
| 2633 |
soiltaxon_id int(11) NOT NULL, |
|
| 2634 |
soilcode text, |
|
| 2635 |
soilname text, |
|
| 2636 |
soillevel int(11), |
|
| 2637 |
soilparent_id int(11), |
|
| 2638 |
soilframework text, |
|
| 2601 | 2639 |
accessioncode text |
| 2602 | 2640 |
); |
| 2603 | 2641 |
|
| 2604 | 2642 |
|
| 2605 | 2643 |
-- |
| 2606 |
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2644 |
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2607 | 2645 |
-- |
| 2608 | 2646 |
|
| 2609 | 2647 |
|
| 2610 | 2648 |
|
| 2611 | 2649 |
|
| 2612 | 2650 |
-- |
| 2613 |
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2651 |
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2614 | 2652 |
-- |
| 2615 | 2653 |
|
| 2616 | 2654 |
|
| 2617 | 2655 |
|
| 2618 | 2656 |
|
| 2619 | 2657 |
-- |
| 2620 |
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2658 |
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2621 | 2659 |
-- |
| 2622 | 2660 |
|
| 2623 | 2661 |
|
| 2624 | 2662 |
|
| 2625 | 2663 |
-- |
| 2626 |
-- Name: referencename; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2664 |
-- Name: source_source_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2627 | 2665 |
-- |
| 2628 | 2666 |
|
| 2629 |
CREATE TABLE referencename ( |
|
| 2630 |
referencename_id int(11) NOT NULL, |
|
| 2631 |
reference_id int(11) NOT NULL, |
|
| 2632 |
system text, |
|
| 2633 |
name text NOT NULL, |
|
| 2634 |
matched_reference_id int(11) |
|
| 2635 |
); |
|
| 2636 | 2667 |
|
| 2637 | 2668 |
|
| 2638 |
-- |
|
| 2639 |
-- Name: referencename_referencename_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2640 |
-- |
|
| 2641 | 2669 |
|
| 2642 |
|
|
| 2643 |
|
|
| 2644 |
|
|
| 2645 | 2670 |
-- |
| 2646 |
-- Name: referencename_referencename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2671 |
-- Name: source_source_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2647 | 2672 |
-- |
| 2648 | 2673 |
|
| 2649 | 2674 |
|
| 2650 | 2675 |
|
| 2651 | 2676 |
|
| 2652 | 2677 |
-- |
| 2653 |
-- Name: referencename_referencename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2678 |
-- Name: source_source_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2654 | 2679 |
-- |
| 2655 | 2680 |
|
| 2656 | 2681 |
|
| 2657 | 2682 |
|
| 2658 | 2683 |
-- |
| 2659 |
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2684 |
-- Name: sourcecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2660 | 2685 |
-- |
| 2661 | 2686 |
|
| 2662 |
CREATE TABLE revision ( |
|
| 2663 |
revision_id int(11) NOT NULL, |
|
| 2664 |
tablename text NOT NULL, |
|
| 2665 |
tableattribute text NOT NULL, |
|
| 2666 |
tablerecord int(11) NOT NULL, |
|
| 2667 |
previousvaluetext text NOT NULL, |
|
| 2668 |
previousvaluetype text NOT NULL, |
|
| 2669 |
previousrevision_id int(11), |
|
| 2670 |
revisiondate date NOT NULL |
|
| 2687 |
CREATE TABLE sourcecontributor ( |
|
| 2688 |
sourcecontributor_id int(11) NOT NULL, |
|
| 2689 |
source_id int(11) NOT NULL, |
|
| 2690 |
sourceparty_id int(11) NOT NULL, |
|
| 2691 |
roletype text, |
|
| 2692 |
`position` int(11) |
|
| 2671 | 2693 |
); |
| 2672 | 2694 |
|
| 2673 | 2695 |
|
| 2674 | 2696 |
-- |
| 2675 |
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2697 |
-- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2676 | 2698 |
-- |
| 2677 | 2699 |
|
| 2678 | 2700 |
|
| 2679 | 2701 |
|
| 2680 | 2702 |
|
| 2681 | 2703 |
-- |
| 2682 |
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2704 |
-- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2683 | 2705 |
-- |
| 2684 | 2706 |
|
| 2685 | 2707 |
|
| 2686 | 2708 |
|
| 2687 | 2709 |
|
| 2688 | 2710 |
-- |
| 2689 |
-- Name: revision_revision_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2711 |
-- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2690 | 2712 |
-- |
| 2691 | 2713 |
|
| 2692 | 2714 |
|
| 2693 | 2715 |
|
| 2694 | 2716 |
-- |
| 2695 |
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2717 |
-- Name: sourcejournal; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2696 | 2718 |
-- |
| 2697 | 2719 |
|
| 2698 |
CREATE TABLE soilobs ( |
|
| 2699 |
soilobs_id int(11) NOT NULL, |
|
| 2700 |
locationevent_id int(11) NOT NULL, |
|
| 2701 |
horizon text DEFAULT 'unknown' NOT NULL, |
|
| 2702 |
description text, |
|
| 2703 |
depthtop_m double precision, |
|
| 2704 |
depthbottom_m double precision, |
|
| 2705 |
color text, |
|
| 2706 |
texture text, |
|
| 2707 |
organic_fraction double precision, |
|
| 2708 |
sand_fraction double precision, |
|
| 2709 |
silt_fraction double precision, |
|
| 2710 |
clay_fraction double precision, |
|
| 2711 |
coarse_fraction double precision, |
|
| 2712 |
ph double precision, |
|
| 2713 |
acidity_fraction double precision, |
|
| 2714 |
basesaturation_fraction double precision, |
|
| 2715 |
cationexchangecapacity_cmol_kg double precision, |
|
| 2716 |
conductivity double precision, |
|
| 2717 |
carbon_fraction double precision, |
|
| 2718 |
phosphorus_fraction double precision, |
|
| 2719 |
potassium_fraction double precision, |
|
| 2720 |
magnesium_fraction double precision, |
|
| 2721 |
nitrogen_fraction double precision, |
|
| 2722 |
calcium_fraction double precision, |
|
| 2723 |
sodium_fraction double precision |
|
| 2720 |
CREATE TABLE sourcejournal ( |
|
| 2721 |
sourcejournal_id int(11) NOT NULL, |
|
| 2722 |
journal text NOT NULL, |
|
| 2723 |
issn text, |
|
| 2724 |
abbreviation text, |
|
| 2725 |
accessioncode text |
|
| 2724 | 2726 |
); |
| 2725 | 2727 |
|
| 2726 | 2728 |
|
| 2727 | 2729 |
-- |
| 2728 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2730 |
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2729 | 2731 |
-- |
| 2730 | 2732 |
|
| 2731 | 2733 |
|
| 2732 | 2734 |
|
| 2733 | 2735 |
|
| 2734 | 2736 |
-- |
| 2735 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2737 |
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2736 | 2738 |
-- |
| 2737 | 2739 |
|
| 2738 | 2740 |
|
| 2739 | 2741 |
|
| 2740 | 2742 |
|
| 2741 | 2743 |
-- |
| 2742 |
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2744 |
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2743 | 2745 |
-- |
| 2744 | 2746 |
|
| 2745 | 2747 |
|
| 2746 | 2748 |
|
| 2747 | 2749 |
-- |
| 2748 |
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2750 |
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 2749 | 2751 |
-- |
| 2750 | 2752 |
|
| 2751 |
CREATE TABLE soiltaxon ( |
|
| 2752 |
soiltaxon_id int(11) NOT NULL, |
|
| 2753 |
soilcode text, |
|
| 2754 |
soilname text, |
|
| 2755 |
soillevel int(11), |
|
| 2756 |
soilparent_id int(11), |
|
| 2757 |
soilframework text, |
|
| 2758 |
accessioncode text |
|
| 2753 |
CREATE TABLE sourcename ( |
|
| 2754 |
sourcename_id int(11) NOT NULL, |
|
| 2755 |
source_id int(11) NOT NULL, |
|
| 2756 |
system text, |
|
| 2757 |
name text NOT NULL, |
|
| 2758 |
matched_source_id int(11) |
|
| 2759 | 2759 |
); |
| 2760 | 2760 |
|
| 2761 | 2761 |
|
| 2762 | 2762 |
-- |
| 2763 |
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2763 |
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2764 | 2764 |
-- |
| 2765 | 2765 |
|
| 2766 | 2766 |
|
| 2767 | 2767 |
|
| 2768 | 2768 |
|
| 2769 | 2769 |
-- |
| 2770 |
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2770 |
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2771 | 2771 |
-- |
| 2772 | 2772 |
|
| 2773 | 2773 |
|
| 2774 | 2774 |
|
| 2775 | 2775 |
|
| 2776 | 2776 |
-- |
| 2777 |
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2777 |
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 2778 | 2778 |
-- |
| 2779 | 2779 |
|
| 2780 | 2780 |
|
| ... | ... | |
| 2821 | 2821 |
|
| 2822 | 2822 |
CREATE TABLE specimenreplicate ( |
| 2823 | 2823 |
specimenreplicate_id int(11) NOT NULL, |
| 2824 |
reference_id int(11) NOT NULL,
|
|
| 2824 |
source_id int(11) NOT NULL,
|
|
| 2825 | 2825 |
sourceaccessioncode text, |
| 2826 | 2826 |
plantobservation_id int(11), |
| 2827 | 2827 |
institution_id int(11), |
| ... | ... | |
| 2969 | 2969 |
|
| 2970 | 2970 |
CREATE TABLE taxonconcept ( |
| 2971 | 2971 |
taxonlabel_id int(11) NOT NULL, |
| 2972 |
concept_reference_id int(11)
|
|
| 2972 |
concept_source_id int(11)
|
|
| 2973 | 2973 |
); |
| 2974 | 2974 |
|
| 2975 | 2975 |
|
| ... | ... | |
| 2981 | 2981 |
|
| 2982 | 2982 |
|
| 2983 | 2983 |
-- |
| 2984 |
-- Name: COLUMN taxonconcept.concept_reference_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 2984 |
-- Name: COLUMN taxonconcept.concept_source_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 2985 | 2985 |
-- |
| 2986 | 2986 |
|
| 2987 | 2987 |
|
| ... | ... | |
| 3166 | 3166 |
taxonlabel_id int(11) NOT NULL, |
| 3167 | 3167 |
party_id int(11), |
| 3168 | 3168 |
taxonlabelstatus text DEFAULT 'undetermined' NOT NULL, |
| 3169 |
reference_id int(11),
|
|
| 3169 |
source_id int(11),
|
|
| 3170 | 3170 |
plantpartycomments text, |
| 3171 | 3171 |
startdate date, |
| 3172 | 3172 |
stopdate date, |
| ... | ... | |
| 3604 | 3604 |
|
| 3605 | 3605 |
|
| 3606 | 3606 |
-- |
| 3607 |
-- Name: reference_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3607 |
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3608 | 3608 |
-- |
| 3609 | 3609 |
|
| 3610 | 3610 |
|
| 3611 | 3611 |
|
| 3612 | 3612 |
|
| 3613 | 3613 |
-- |
| 3614 |
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3614 |
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3615 | 3615 |
-- |
| 3616 | 3616 |
|
| 3617 | 3617 |
|
| 3618 | 3618 |
|
| 3619 | 3619 |
|
| 3620 | 3620 |
-- |
| 3621 |
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3621 |
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3622 | 3622 |
-- |
| 3623 | 3623 |
|
| 3624 | 3624 |
|
| 3625 | 3625 |
|
| 3626 | 3626 |
|
| 3627 | 3627 |
-- |
| 3628 |
-- Name: referencename_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3628 |
-- Name: source_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3629 | 3629 |
-- |
| 3630 | 3630 |
|
| 3631 | 3631 |
|
| 3632 | 3632 |
|
| 3633 | 3633 |
|
| 3634 | 3634 |
-- |
| 3635 |
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3635 |
-- Name: sourcecontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3636 | 3636 |
-- |
| 3637 | 3637 |
|
| 3638 | 3638 |
|
| 3639 | 3639 |
|
| 3640 | 3640 |
|
| 3641 | 3641 |
-- |
| 3642 |
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3642 |
-- Name: sourcejournal_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3643 | 3643 |
-- |
| 3644 | 3644 |
|
| 3645 | 3645 |
|
| 3646 | 3646 |
|
| 3647 | 3647 |
|
| 3648 | 3648 |
-- |
| 3649 |
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3649 |
-- Name: sourcename_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3650 | 3650 |
-- |
| 3651 | 3651 |
|
| 3652 | 3652 |
|
| ... | ... | |
| 4023 | 4023 |
|
| 4024 | 4024 |
|
| 4025 | 4025 |
-- |
| 4026 |
-- Data for Name: reference; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4026 |
-- Data for Name: revision; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4027 | 4027 |
-- |
| 4028 | 4028 |
|
| 4029 | 4029 |
|
| 4030 | 4030 |
|
| 4031 | 4031 |
-- |
| 4032 |
-- Data for Name: referencecontributor; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4032 |
-- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4033 | 4033 |
-- |
| 4034 | 4034 |
|
| 4035 | 4035 |
|
| 4036 | 4036 |
|
| 4037 | 4037 |
-- |
| 4038 |
-- Data for Name: referencejournal; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4038 |
-- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4039 | 4039 |
-- |
| 4040 | 4040 |
|
| 4041 | 4041 |
|
| 4042 | 4042 |
|
| 4043 | 4043 |
-- |
| 4044 |
-- Data for Name: referencename; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4044 |
-- Data for Name: source; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4045 | 4045 |
-- |
| 4046 | 4046 |
|
| 4047 | 4047 |
|
| 4048 | 4048 |
|
| 4049 | 4049 |
-- |
| 4050 |
-- Data for Name: revision; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4050 |
-- Data for Name: sourcecontributor; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4051 | 4051 |
-- |
| 4052 | 4052 |
|
| 4053 | 4053 |
|
| 4054 | 4054 |
|
| 4055 | 4055 |
-- |
| 4056 |
-- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4056 |
-- Data for Name: sourcejournal; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4057 | 4057 |
-- |
| 4058 | 4058 |
|
| 4059 | 4059 |
|
| 4060 | 4060 |
|
| 4061 | 4061 |
-- |
| 4062 |
-- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4062 |
-- Data for Name: sourcename; Type: TABLE DATA; Schema: public; Owner: -
|
|
| 4063 | 4063 |
-- |
| 4064 | 4064 |
|
| 4065 | 4065 |
|
| ... | ... | |
| 4527 | 4527 |
-- |
| 4528 | 4528 |
|
| 4529 | 4529 |
ALTER TABLE project |
| 4530 |
ADD CONSTRAINT project_unique UNIQUE (reference_id, projectname);
|
|
| 4530 |
ADD CONSTRAINT project_unique UNIQUE (source_id, projectname);
|
|
| 4531 | 4531 |
|
| 4532 | 4532 |
|
| 4533 | 4533 |
-- |
| ... | ... | |
| 4539 | 4539 |
|
| 4540 | 4540 |
|
| 4541 | 4541 |
-- |
| 4542 |
-- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4542 |
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4543 | 4543 |
-- |
| 4544 | 4544 |
|
| 4545 |
ALTER TABLE reference
|
|
| 4546 |
ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
|
|
| 4545 |
ALTER TABLE revision
|
|
| 4546 |
ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
|
|
| 4547 | 4547 |
|
| 4548 | 4548 |
|
| 4549 | 4549 |
-- |
| 4550 |
-- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4550 |
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4551 | 4551 |
-- |
| 4552 | 4552 |
|
| 4553 |
ALTER TABLE referencecontributor
|
|
| 4554 |
ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
|
|
| 4553 |
ALTER TABLE soilobs
|
|
| 4554 |
ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
|
|
| 4555 | 4555 |
|
| 4556 | 4556 |
|
| 4557 | 4557 |
-- |
| 4558 |
-- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4558 |
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4559 | 4559 |
-- |
| 4560 | 4560 |
|
| 4561 |
ALTER TABLE referencejournal
|
|
| 4562 |
ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
|
|
| 4561 |
ALTER TABLE soilobs
|
|
| 4562 |
ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
|
|
| 4563 | 4563 |
|
| 4564 | 4564 |
|
| 4565 | 4565 |
-- |
| 4566 |
-- Name: referencename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4566 |
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4567 | 4567 |
-- |
| 4568 | 4568 |
|
| 4569 |
ALTER TABLE referencename
|
|
| 4570 |
ADD CONSTRAINT referencename_pkey PRIMARY KEY (referencename_id);
|
|
| 4569 |
ALTER TABLE soiltaxon
|
|
| 4570 |
ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
|
|
| 4571 | 4571 |
|
| 4572 | 4572 |
|
| 4573 | 4573 |
-- |
| 4574 |
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4574 |
-- Name: source_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4575 | 4575 |
-- |
| 4576 | 4576 |
|
| 4577 |
ALTER TABLE revision
|
|
| 4578 |
ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
|
|
| 4577 |
ALTER TABLE source
|
|
| 4578 |
ADD CONSTRAINT source_pkey PRIMARY KEY (source_id);
|
|
| 4579 | 4579 |
|
| 4580 | 4580 |
|
| 4581 | 4581 |
-- |
| 4582 |
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4582 |
-- Name: sourcecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4583 | 4583 |
-- |
| 4584 | 4584 |
|
| 4585 |
ALTER TABLE soilobs
|
|
| 4586 |
ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
|
|
| 4585 |
ALTER TABLE sourcecontributor
|
|
| 4586 |
ADD CONSTRAINT sourcecontributor_pkey PRIMARY KEY (sourcecontributor_id);
|
|
| 4587 | 4587 |
|
| 4588 | 4588 |
|
| 4589 | 4589 |
-- |
| 4590 |
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4590 |
-- Name: sourcejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4591 | 4591 |
-- |
| 4592 | 4592 |
|
| 4593 |
ALTER TABLE soilobs
|
|
| 4594 |
ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
|
|
| 4593 |
ALTER TABLE sourcejournal
|
|
| 4594 |
ADD CONSTRAINT sourcejournal_pkey PRIMARY KEY (sourcejournal_id);
|
|
| 4595 | 4595 |
|
| 4596 | 4596 |
|
| 4597 | 4597 |
-- |
| 4598 |
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4598 |
-- Name: sourcename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4599 | 4599 |
-- |
| 4600 | 4600 |
|
| 4601 |
ALTER TABLE soiltaxon
|
|
| 4602 |
ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
|
|
| 4601 |
ALTER TABLE sourcename
|
|
| 4602 |
ADD CONSTRAINT sourcename_pkey PRIMARY KEY (sourcename_id);
|
|
| 4603 | 4603 |
|
| 4604 | 4604 |
|
| 4605 | 4605 |
-- |
| ... | ... | |
| 4867 | 4867 |
-- Name: location_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4868 | 4868 |
-- |
| 4869 | 4869 |
|
| 4870 |
CREATE INDEX location_creator ON location (reference_id);
|
|
| 4870 |
CREATE INDEX location_creator ON location (source_id);
|
|
| 4871 | 4871 |
|
| 4872 | 4872 |
|
| 4873 | 4873 |
-- |
| ... | ... | |
| 5060 | 5060 |
|
| 5061 | 5061 |
|
| 5062 | 5062 |
-- |
| 5063 |
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5063 |
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5064 | 5064 |
-- |
| 5065 | 5065 |
|
| 5066 |
CREATE UNIQUE INDEX reference_accessioncode_index ON reference (accessioncode);
|
|
| 5066 |
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon (accessioncode);
|
|
| 5067 | 5067 |
|
| 5068 | 5068 |
|
| 5069 | 5069 |
-- |
| 5070 |
-- Name: reference_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5070 |
-- Name: source_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5071 | 5071 |
-- |
| 5072 | 5072 |
|
| 5073 |
CREATE UNIQUE INDEX source_accessioncode_index ON source (accessioncode); |
|
| 5073 | 5074 |
|
| 5074 | 5075 |
|
| 5075 |
|
|
| 5076 | 5076 |
-- |
| 5077 |
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5077 |
-- Name: source_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5078 | 5078 |
-- |
| 5079 | 5079 |
|
| 5080 |
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal (accessioncode); |
|
| 5081 | 5080 |
|
| 5082 | 5081 |
|
| 5082 |
|
|
| 5083 | 5083 |
-- |
| 5084 |
-- Name: referencename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5084 |
-- Name: sourcejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5085 | 5085 |
-- |
| 5086 | 5086 |
|
| 5087 |
CREATE UNIQUE INDEX sourcejournal_accessioncode_index ON sourcejournal (accessioncode); |
|
| 5087 | 5088 |
|
| 5088 | 5089 |
|
| 5089 |
|
|
| 5090 | 5090 |
-- |
| 5091 |
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5091 |
-- Name: sourcename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5092 | 5092 |
-- |
| 5093 | 5093 |
|
| 5094 |
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon (accessioncode); |
|
| 5095 | 5094 |
|
| 5096 | 5095 |
|
| 5096 |
|
|
| 5097 | 5097 |
-- |
| 5098 | 5098 |
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5099 | 5099 |
-- |
| ... | ... | |
| 5249 | 5249 |
|
| 5250 | 5250 |
|
| 5251 | 5251 |
-- |
| 5252 |
-- Name: party_reference_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
|
|
| 5252 |
-- Name: party_source_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
|
|
| 5253 | 5253 |
-- |
| 5254 | 5254 |
|
| 5255 | 5255 |
|
| ... | ... | |
| 5370 | 5370 |
|
| 5371 | 5371 |
|
| 5372 | 5372 |
-- |
| 5373 |
-- Name: aggregateoccurrence_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5373 |
-- Name: aggregateoccurrence_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5374 | 5374 |
-- |
| 5375 | 5375 |
|
| 5376 | 5376 |
|
| ... | ... | |
| 5430 | 5430 |
|
| 5431 | 5431 |
|
| 5432 | 5432 |
-- |
| 5433 |
-- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5433 |
-- Name: commconcept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5434 | 5434 |
-- |
| 5435 | 5435 |
|
| 5436 | 5436 |
|
| ... | ... | |
| 5492 | 5492 |
|
| 5493 | 5493 |
|
| 5494 | 5494 |
-- |
| 5495 |
-- Name: commname_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5495 |
-- Name: commname_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5496 | 5496 |
-- |
| 5497 | 5497 |
|
| 5498 | 5498 |
|
| ... | ... | |
| 5522 | 5522 |
|
| 5523 | 5523 |
|
| 5524 | 5524 |
-- |
| 5525 |
-- Name: commstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5525 |
-- Name: commstatus_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5526 | 5526 |
-- |
| 5527 | 5527 |
|
| 5528 | 5528 |
|
| ... | ... | |
| 5560 | 5560 |
|
| 5561 | 5561 |
|
| 5562 | 5562 |
-- |
| 5563 |
-- Name: coordinates_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5563 |
-- Name: coordinates_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5564 | 5564 |
-- |
| 5565 | 5565 |
|
| 5566 | 5566 |
|
| ... | ... | |
| 5575 | 5575 |
|
| 5576 | 5576 |
|
| 5577 | 5577 |
-- |
| 5578 |
-- Name: covermethod_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5578 |
-- Name: covermethod_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5579 | 5579 |
-- |
| 5580 | 5580 |
|
| 5581 | 5581 |
|
| ... | ... | |
| 5614 | 5614 |
|
| 5615 | 5615 |
|
| 5616 | 5616 |
-- |
| 5617 |
-- Name: location_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5617 |
-- Name: location_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5618 | 5618 |
-- |
| 5619 | 5619 |
|
| 5620 | 5620 |
|
| ... | ... | |
| 5660 | 5660 |
|
| 5661 | 5661 |
|
| 5662 | 5662 |
-- |
| 5663 |
-- Name: locationevent_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5663 |
-- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5664 | 5664 |
-- |
| 5665 | 5665 |
|
| 5666 |
ALTER TABLE locationevent |
|
| 5667 |
ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5666 | 5668 |
|
| 5667 | 5669 |
|
| 5668 |
|
|
| 5669 | 5670 |
-- |
| 5670 |
-- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5671 |
-- Name: locationevent_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5671 | 5672 |
-- |
| 5672 | 5673 |
|
| 5673 |
ALTER TABLE locationevent |
|
| 5674 |
ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5675 | 5674 |
|
| 5676 | 5675 |
|
| 5676 |
|
|
| 5677 | 5677 |
-- |
| 5678 | 5678 |
-- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5679 | 5679 |
-- |
| ... | ... | |
| 5744 | 5744 |
|
| 5745 | 5745 |
|
| 5746 | 5746 |
-- |
| 5747 |
-- Name: method_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5747 |
-- Name: method_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5748 | 5748 |
-- |
| 5749 | 5749 |
|
| 5750 | 5750 |
|
| ... | ... | |
| 5805 | 5805 |
|
| 5806 | 5806 |
|
| 5807 | 5807 |
-- |
| 5808 |
-- Name: party_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5808 |
-- Name: party_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5809 | 5809 |
-- |
| 5810 | 5810 |
|
| 5811 | 5811 |
|
| ... | ... | |
| 5859 | 5859 |
|
| 5860 | 5860 |
|
| 5861 | 5861 |
-- |
| 5862 |
-- Name: place_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5862 |
-- Name: place_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5863 | 5863 |
-- |
| 5864 | 5864 |
|
| 5865 | 5865 |
|
| ... | ... | |
| 5922 | 5922 |
|
| 5923 | 5923 |
|
| 5924 | 5924 |
-- |
| 5925 |
-- Name: plantobservation_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5925 |
-- Name: plantobservation_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5926 | 5926 |
-- |
| 5927 | 5927 |
|
| 5928 | 5928 |
|
| 5929 | 5929 |
|
| 5930 | 5930 |
|
| 5931 | 5931 |
-- |
| 5932 |
-- Name: project_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5932 |
-- Name: project_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5933 | 5933 |
-- |
| 5934 | 5934 |
|
| 5935 | 5935 |
|
| ... | ... | |
| 5951 | 5951 |
|
| 5952 | 5952 |
|
| 5953 | 5953 |
-- |
| 5954 |
-- Name: reference_referencejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5954 |
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5955 | 5955 |
-- |
| 5956 | 5956 |
|
| 5957 |
ALTER TABLE reference
|
|
| 5958 |
ADD CONSTRAINT reference_referencejournal_id_fkey FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5957 |
ALTER TABLE revision
|
|
| 5958 |
ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5959 | 5959 |
|
| 5960 | 5960 |
|
| 5961 | 5961 |
-- |
| 5962 |
-- Name: referencecontributor_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5962 |
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5963 | 5963 |
-- |
| 5964 | 5964 |
|
| 5965 |
ALTER TABLE referencecontributor
|
|
| 5966 |
ADD CONSTRAINT referencecontributor_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5965 |
ALTER TABLE soilobs
|
|
| 5966 |
ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5967 | 5967 |
|
| 5968 | 5968 |
|
| 5969 | 5969 |
-- |
| 5970 |
-- Name: referencecontributor_referenceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5970 |
-- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5971 | 5971 |
-- |
| 5972 | 5972 |
|
| 5973 |
ALTER TABLE referencecontributor
|
|
| 5974 |
ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5973 |
ALTER TABLE soiltaxon
|
|
| 5974 |
ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5975 | 5975 |
|
| 5976 | 5976 |
|
| 5977 | 5977 |
-- |
| 5978 |
-- Name: referencename_matched_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5978 |
-- Name: source_sourcejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5979 | 5979 |
-- |
| 5980 | 5980 |
|
| 5981 |
ALTER TABLE referencename
|
|
| 5982 |
ADD CONSTRAINT referencename_matched_reference_id_fkey FOREIGN KEY (matched_reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5981 |
ALTER TABLE source
|
|
| 5982 |
ADD CONSTRAINT source_sourcejournal_id_fkey FOREIGN KEY (sourcejournal_id) REFERENCES sourcejournal(sourcejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5983 | 5983 |
|
| 5984 | 5984 |
|
| 5985 | 5985 |
-- |
| 5986 |
-- Name: referencename_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5986 |
-- Name: sourcecontributor_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5987 | 5987 |
-- |
| 5988 | 5988 |
|
| 5989 |
ALTER TABLE sourcecontributor |
|
| 5990 |
ADD CONSTRAINT sourcecontributor_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5989 | 5991 |
|
| 5990 | 5992 |
|
| 5991 |
|
|
| 5992 | 5993 |
-- |
| 5993 |
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5994 |
-- Name: sourcecontributor_sourceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5994 | 5995 |
-- |
| 5995 | 5996 |
|
| 5996 |
ALTER TABLE revision
|
|
| 5997 |
ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5997 |
ALTER TABLE sourcecontributor
|
|
| 5998 |
ADD CONSTRAINT sourcecontributor_sourceparty_id_fkey FOREIGN KEY (sourceparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5998 | 5999 |
|
| 5999 | 6000 |
|
| 6000 | 6001 |
-- |
| 6001 |
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6002 |
-- Name: sourcename_matched_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6002 | 6003 |
-- |
| 6003 | 6004 |
|
| 6004 |
ALTER TABLE soilobs
|
|
| 6005 |
ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6005 |
ALTER TABLE sourcename
|
|
| 6006 |
ADD CONSTRAINT sourcename_matched_source_id_fkey FOREIGN KEY (matched_source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6006 | 6007 |
|
| 6007 | 6008 |
|
| 6008 | 6009 |
-- |
| 6009 |
-- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6010 |
-- Name: sourcename_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6010 | 6011 |
-- |
| 6011 | 6012 |
|
| 6012 |
ALTER TABLE soiltaxon |
|
| 6013 |
ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6014 | 6013 |
|
| 6015 | 6014 |
|
| 6015 |
|
|
| 6016 | 6016 |
-- |
| 6017 | 6017 |
-- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6018 | 6018 |
-- |
| ... | ... | |
| 6029 | 6029 |
|
| 6030 | 6030 |
|
| 6031 | 6031 |
-- |
| 6032 |
-- Name: specimenreplicate_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6032 |
-- Name: specimenreplicate_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6033 | 6033 |
-- |
| 6034 | 6034 |
|
| 6035 | 6035 |
|
| ... | ... | |
| 6052 | 6052 |
|
| 6053 | 6053 |
|
| 6054 | 6054 |
-- |
| 6055 |
-- Name: stemobservation_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6055 |
-- Name: stemobservation_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6056 | 6056 |
-- |
| 6057 | 6057 |
|
| 6058 | 6058 |
|
| ... | ... | |
| 6090 | 6090 |
|
| 6091 | 6091 |
|
| 6092 | 6092 |
-- |
| 6093 |
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6093 |
-- Name: taxonconcept_concept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6094 | 6094 |
-- |
| 6095 | 6095 |
|
| 6096 | 6096 |
|
| ... | ... | |
| 6127 | 6127 |
|
| 6128 | 6128 |
|
| 6129 | 6129 |
-- |
| 6130 |
-- Name: taxondetermination_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6130 |
-- Name: taxondetermination_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6131 | 6131 |
-- |
| 6132 | 6132 |
|
| 6133 | 6133 |
|
| ... | ... | |
| 6173 | 6173 |
|
| 6174 | 6174 |
|
| 6175 | 6175 |
-- |
| 6176 |
-- Name: taxonlabel_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6177 |
-- |
|
| 6178 |
|
|
| 6179 |
|
|
| 6180 |
|
|
| 6181 |
|
|
| 6182 |
-- |
|
| 6183 | 6176 |
-- Name: taxonlabel_relationship_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6184 | 6177 |
-- |
| 6185 | 6178 |
|
| ... | ... | |
| 6196 | 6189 |
|
| 6197 | 6190 |
|
| 6198 | 6191 |
-- |
| 6192 |
-- Name: taxonlabel_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6193 |
-- |
|
| 6194 |
|
|
| 6195 |
|
|
| 6196 |
|
|
| 6197 |
|
|
| 6198 |
-- |
|
| 6199 | 6199 |
-- Name: taxonlineage_childtaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6200 | 6200 |
-- |
| 6201 | 6201 |
|
| ... | ... | |
| 6227 | 6227 |
|
| 6228 | 6228 |
|
| 6229 | 6229 |
-- |
| 6230 |
-- Name: taxonoccurrence_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6230 |
-- Name: taxonoccurrence_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6231 | 6231 |
-- |
| 6232 | 6232 |
|
| 6233 | 6233 |
|
| ... | ... | |
| 6241 | 6241 |
|
| 6242 | 6242 |
|
| 6243 | 6243 |
-- |
| 6244 |
-- Name: taxonstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6244 |
-- Name: taxonstatus_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6245 | 6245 |
-- |
| 6246 | 6246 |
|
| 6247 | 6247 |
|
Also available in: Unified diff
schemas/vegbien.sql: Renamed reference -> source to make this table more broadly applicable, and because this now stores the datasource metadata