Revision 1101
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 582 | 582 |
|
| 583 | 583 |
|
| 584 | 584 |
|
| 585 |
|
|
| 586 |
|
|
| 585 | 587 |
-- |
| 588 |
-- Name: growthform; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 589 |
-- |
|
| 590 |
|
|
| 591 |
CREATE TABLE growthform ( |
|
| 592 |
growthform_id int(11) NOT NULL, |
|
| 593 |
name text NOT NULL |
|
| 594 |
); |
|
| 595 |
|
|
| 596 |
|
|
| 597 |
-- |
|
| 598 |
-- Name: COLUMN growthform.name; Type: COMMENT; Schema: public; Owner: - |
|
| 599 |
-- |
|
| 600 |
|
|
| 601 |
|
|
| 602 |
|
|
| 603 |
|
|
| 604 |
-- |
|
| 605 |
-- Name: growthform_growthform_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 606 |
-- |
|
| 607 |
|
|
| 608 |
|
|
| 609 |
|
|
| 610 |
|
|
| 611 |
-- |
|
| 612 |
-- Name: growthform_growthform_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 613 |
-- |
|
| 614 |
|
|
| 615 |
|
|
| 616 |
|
|
| 617 |
|
|
| 618 |
|
|
| 619 |
|
|
| 620 |
-- |
|
| 586 | 621 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 587 | 622 |
-- |
| 588 | 623 |
|
| ... | ... | |
| 895 | 930 |
observationtype text, |
| 896 | 931 |
observationmeasure text, |
| 897 | 932 |
observationmeasureunits text, |
| 898 |
taxonclassincluded text, |
|
| 899 |
taxonclassexcluded text, |
|
| 900 | 933 |
covermethod_id int(11), |
| 901 | 934 |
samplingfactor double precision DEFAULT 1 NOT NULL, |
| 902 | 935 |
coverbasis text, |
| ... | ... | |
| 995 | 1028 |
|
| 996 | 1029 |
|
| 997 | 1030 |
-- |
| 998 |
-- Name: COLUMN method.taxonclassincluded; Type: COMMENT; Schema: public; Owner: -
|
|
| 1031 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
|
|
| 999 | 1032 |
-- |
| 1000 | 1033 |
|
| 1001 | 1034 |
|
| 1002 | 1035 |
|
| 1003 | 1036 |
|
| 1004 | 1037 |
-- |
| 1005 |
-- Name: COLUMN method.taxonclassexcluded; Type: COMMENT; Schema: public; Owner: -
|
|
| 1038 |
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 1006 | 1039 |
-- |
| 1007 | 1040 |
|
| 1008 | 1041 |
|
| 1009 | 1042 |
|
| 1010 | 1043 |
|
| 1011 | 1044 |
-- |
| 1012 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
|
|
| 1045 |
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
|
|
| 1013 | 1046 |
-- |
| 1014 | 1047 |
|
| 1015 | 1048 |
|
| 1016 | 1049 |
|
| 1017 | 1050 |
|
| 1018 | 1051 |
-- |
| 1019 |
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 1052 |
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
|
|
| 1020 | 1053 |
-- |
| 1021 | 1054 |
|
| 1022 | 1055 |
|
| 1023 | 1056 |
|
| 1024 | 1057 |
|
| 1025 | 1058 |
-- |
| 1026 |
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
|
|
| 1059 |
-- Name: COLUMN method.length; Type: COMMENT; Schema: public; Owner: -
|
|
| 1027 | 1060 |
-- |
| 1028 | 1061 |
|
| 1029 | 1062 |
|
| 1030 | 1063 |
|
| 1031 | 1064 |
|
| 1032 | 1065 |
-- |
| 1033 |
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
|
|
| 1066 |
-- Name: COLUMN method.width; Type: COMMENT; Schema: public; Owner: -
|
|
| 1034 | 1067 |
-- |
| 1035 | 1068 |
|
| 1036 | 1069 |
|
| 1037 | 1070 |
|
| 1038 | 1071 |
|
| 1039 | 1072 |
-- |
| 1040 |
-- Name: COLUMN method.length; Type: COMMENT; Schema: public; Owner: -
|
|
| 1073 |
-- Name: COLUMN method.radius; Type: COMMENT; Schema: public; Owner: -
|
|
| 1041 | 1074 |
-- |
| 1042 | 1075 |
|
| 1043 | 1076 |
|
| 1044 | 1077 |
|
| 1045 | 1078 |
|
| 1046 | 1079 |
-- |
| 1047 |
-- Name: COLUMN method.width; Type: COMMENT; Schema: public; Owner: -
|
|
| 1080 |
-- Name: COLUMN method.area; Type: COMMENT; Schema: public; Owner: -
|
|
| 1048 | 1081 |
-- |
| 1049 | 1082 |
|
| 1050 | 1083 |
|
| 1051 | 1084 |
|
| 1052 | 1085 |
|
| 1053 | 1086 |
-- |
| 1054 |
-- Name: COLUMN method.radius; Type: COMMENT; Schema: public; Owner: -
|
|
| 1087 |
-- Name: COLUMN method.samplearea; Type: COMMENT; Schema: public; Owner: -
|
|
| 1055 | 1088 |
-- |
| 1056 | 1089 |
|
| 1057 | 1090 |
|
| 1058 | 1091 |
|
| 1059 | 1092 |
|
| 1060 | 1093 |
-- |
| 1061 |
-- Name: COLUMN method.area; Type: COMMENT; Schema: public; Owner: -
|
|
| 1094 |
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 1062 | 1095 |
-- |
| 1063 | 1096 |
|
| 1064 | 1097 |
|
| 1065 | 1098 |
|
| 1066 | 1099 |
|
| 1067 | 1100 |
-- |
| 1068 |
-- Name: COLUMN method.samplearea; Type: COMMENT; Schema: public; Owner: -
|
|
| 1101 |
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 1069 | 1102 |
-- |
| 1070 | 1103 |
|
| 1071 | 1104 |
|
| 1072 | 1105 |
|
| 1073 | 1106 |
|
| 1107 |
|
|
| 1108 |
|
|
| 1074 | 1109 |
-- |
| 1075 |
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 1110 |
-- Name: methodgrowthform; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 1076 | 1111 |
-- |
| 1077 | 1112 |
|
| 1113 |
CREATE TABLE methodgrowthform ( |
|
| 1114 |
methodgrowthform_id int(11) NOT NULL, |
|
| 1115 |
method_id int(11) NOT NULL, |
|
| 1116 |
growthform_id int(11) NOT NULL, |
|
| 1117 |
included int(1) DEFAULT true NOT NULL |
|
| 1118 |
); |
|
| 1078 | 1119 |
|
| 1079 | 1120 |
|
| 1121 |
-- |
|
| 1122 |
-- Name: COLUMN methodgrowthform.included; Type: COMMENT; Schema: public; Owner: - |
|
| 1123 |
-- |
|
| 1080 | 1124 |
|
| 1125 |
|
|
| 1126 |
|
|
| 1127 |
|
|
| 1081 | 1128 |
-- |
| 1082 |
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 1129 |
-- Name: methodgrowthform_methodgrowthform_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 1083 | 1130 |
-- |
| 1084 | 1131 |
|
| 1085 | 1132 |
|
| 1086 | 1133 |
|
| 1087 | 1134 |
|
| 1088 | 1135 |
-- |
| 1136 |
-- Name: methodgrowthform_methodgrowthform_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1137 |
-- |
|
| 1138 |
|
|
| 1139 |
|
|
| 1140 |
|
|
| 1141 |
|
|
| 1142 |
-- |
|
| 1143 |
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1144 |
-- |
|
| 1145 |
|
|
| 1146 |
CREATE TABLE methodtaxonclass ( |
|
| 1147 |
methodtaxonclass_id int(11) NOT NULL, |
|
| 1148 |
method_id int(11) NOT NULL, |
|
| 1149 |
plantconcept_id int(11) NOT NULL, |
|
| 1150 |
included int(1) DEFAULT true NOT NULL |
|
| 1151 |
); |
|
| 1152 |
|
|
| 1153 |
|
|
| 1154 |
-- |
|
| 1155 |
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: - |
|
| 1156 |
-- |
|
| 1157 |
|
|
| 1158 |
|
|
| 1159 |
|
|
| 1160 |
|
|
| 1161 |
-- |
|
| 1162 |
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1163 |
-- |
|
| 1164 |
|
|
| 1165 |
|
|
| 1166 |
|
|
| 1167 |
|
|
| 1168 |
-- |
|
| 1169 |
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1170 |
-- |
|
| 1171 |
|
|
| 1172 |
|
|
| 1173 |
|
|
| 1174 |
|
|
| 1175 |
|
|
| 1176 |
|
|
| 1177 |
-- |
|
| 1089 | 1178 |
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1090 | 1179 |
-- |
| 1091 | 1180 |
|
| ... | ... | |
| 2423 | 2512 |
|
| 2424 | 2513 |
|
| 2425 | 2514 |
-- |
| 2515 |
-- Name: growthform_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2516 |
-- |
|
| 2517 |
|
|
| 2518 |
|
|
| 2519 |
|
|
| 2520 |
|
|
| 2521 |
-- |
|
| 2426 | 2522 |
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: - |
| 2427 | 2523 |
-- |
| 2428 | 2524 |
|
| ... | ... | |
| 2465 | 2561 |
|
| 2466 | 2562 |
|
| 2467 | 2563 |
-- |
| 2564 |
-- Name: methodgrowthform_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2565 |
-- |
|
| 2566 |
|
|
| 2567 |
|
|
| 2568 |
|
|
| 2569 |
|
|
| 2570 |
-- |
|
| 2571 |
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2572 |
-- |
|
| 2573 |
|
|
| 2574 |
|
|
| 2575 |
|
|
| 2576 |
|
|
| 2577 |
-- |
|
| 2468 | 2578 |
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: - |
| 2469 | 2579 |
-- |
| 2470 | 2580 |
|
| ... | ... | |
| 2907 | 3017 |
|
| 2908 | 3018 |
|
| 2909 | 3019 |
-- |
| 3020 |
-- Name: growthform_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3021 |
-- |
|
| 3022 |
|
|
| 3023 |
ALTER TABLE growthform |
|
| 3024 |
ADD CONSTRAINT growthform_keys UNIQUE (name); |
|
| 3025 |
|
|
| 3026 |
|
|
| 3027 |
-- |
|
| 3028 |
-- Name: growthform_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3029 |
-- |
|
| 3030 |
|
|
| 3031 |
ALTER TABLE growthform |
|
| 3032 |
ADD CONSTRAINT growthform_pkey PRIMARY KEY (growthform_id); |
|
| 3033 |
|
|
| 3034 |
|
|
| 3035 |
-- |
|
| 2910 | 3036 |
-- Name: location_keys_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 2911 | 3037 |
-- |
| 2912 | 3038 |
|
| ... | ... | |
| 3003 | 3129 |
|
| 3004 | 3130 |
|
| 3005 | 3131 |
-- |
| 3132 |
-- Name: methodgrowthform_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3133 |
-- |
|
| 3134 |
|
|
| 3135 |
ALTER TABLE methodgrowthform |
|
| 3136 |
ADD CONSTRAINT methodgrowthform_pkey PRIMARY KEY (methodgrowthform_id); |
|
| 3137 |
|
|
| 3138 |
|
|
| 3139 |
-- |
|
| 3140 |
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3141 |
-- |
|
| 3142 |
|
|
| 3143 |
ALTER TABLE methodtaxonclass |
|
| 3144 |
ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id); |
|
| 3145 |
|
|
| 3146 |
|
|
| 3147 |
-- |
|
| 3006 | 3148 |
-- Name: namedplace_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3007 | 3149 |
-- |
| 3008 | 3150 |
|
| ... | ... | |
| 3808 | 3950 |
|
| 3809 | 3951 |
|
| 3810 | 3952 |
-- |
| 3953 |
-- Name: fki_methodgrowthform_growthform_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3954 |
-- |
|
| 3955 |
|
|
| 3956 |
CREATE INDEX fki_methodgrowthform_growthform_id ON methodgrowthform (growthform_id); |
|
| 3957 |
|
|
| 3958 |
|
|
| 3959 |
-- |
|
| 3960 |
-- Name: fki_methodgrowthform_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3961 |
-- |
|
| 3962 |
|
|
| 3963 |
CREATE INDEX fki_methodgrowthform_method_id ON methodgrowthform (method_id); |
|
| 3964 |
|
|
| 3965 |
|
|
| 3966 |
-- |
|
| 3967 |
-- Name: fki_methodtaxonclass_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3968 |
-- |
|
| 3969 |
|
|
| 3970 |
CREATE INDEX fki_methodtaxonclass_method_id ON methodtaxonclass (method_id); |
|
| 3971 |
|
|
| 3972 |
|
|
| 3973 |
-- |
|
| 3974 |
-- Name: fki_methodtaxonclass_plantconcept_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3975 |
-- |
|
| 3976 |
|
|
| 3977 |
CREATE INDEX fki_methodtaxonclass_plantconcept_id ON methodtaxonclass (plantconcept_id); |
|
| 3978 |
|
|
| 3979 |
|
|
| 3980 |
-- |
|
| 3811 | 3981 |
-- Name: fki_plantconcept_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3812 | 3982 |
-- |
| 3813 | 3983 |
|
| ... | ... | |
| 4990 | 5160 |
|
| 4991 | 5161 |
|
| 4992 | 5162 |
-- |
| 5163 |
-- Name: methodgrowthform_growthform_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5164 |
-- |
|
| 5165 |
|
|
| 5166 |
ALTER TABLE methodgrowthform |
|
| 5167 |
ADD CONSTRAINT methodgrowthform_growthform_id FOREIGN KEY (growthform_id) REFERENCES growthform(growthform_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5168 |
|
|
| 5169 |
|
|
| 5170 |
-- |
|
| 5171 |
-- Name: methodgrowthform_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5172 |
-- |
|
| 5173 |
|
|
| 5174 |
ALTER TABLE methodgrowthform |
|
| 5175 |
ADD CONSTRAINT methodgrowthform_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5176 |
|
|
| 5177 |
|
|
| 5178 |
-- |
|
| 5179 |
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5180 |
-- |
|
| 5181 |
|
|
| 5182 |
ALTER TABLE methodtaxonclass |
|
| 5183 |
ADD CONSTRAINT methodtaxonclass_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5184 |
|
|
| 5185 |
|
|
| 5186 |
-- |
|
| 5187 |
-- Name: methodtaxonclass_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5188 |
-- |
|
| 5189 |
|
|
| 5190 |
ALTER TABLE methodtaxonclass |
|
| 5191 |
ADD CONSTRAINT methodtaxonclass_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5192 |
|
|
| 5193 |
|
|
| 5194 |
-- |
|
| 4993 | 5195 |
-- Name: namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4994 | 5196 |
-- |
| 4995 | 5197 |
|
| schemas/vegbien_empty.sql | ||
|---|---|---|
| 15 | 15 |
TRUNCATE disturbanceobs CASCADE; |
| 16 | 16 |
TRUNCATE embargo CASCADE; |
| 17 | 17 |
TRUNCATE graphic CASCADE; |
| 18 |
TRUNCATE growthform CASCADE; |
|
| 18 | 19 |
TRUNCATE location CASCADE; |
| 19 | 20 |
TRUNCATE locationdetermination CASCADE; |
| 20 | 21 |
TRUNCATE locationevent CASCADE; |
| 21 | 22 |
TRUNCATE locationeventcontributor CASCADE; |
| 22 | 23 |
TRUNCATE locationeventsynonym CASCADE; |
| 23 | 24 |
TRUNCATE method CASCADE; |
| 25 |
TRUNCATE methodgrowthform CASCADE; |
|
| 26 |
TRUNCATE methodtaxonclass CASCADE; |
|
| 24 | 27 |
TRUNCATE namedplace CASCADE; |
| 25 | 28 |
TRUNCATE namedplacecorrelation CASCADE; |
| 26 | 29 |
TRUNCATE note CASCADE; |
| schemas/vegbien.sql | ||
|---|---|---|
| 693 | 693 |
ALTER SEQUENCE graphic_graphic_id_seq OWNED BY graphic.graphic_id; |
| 694 | 694 |
|
| 695 | 695 |
|
| 696 |
SET default_with_oids = false; |
|
| 697 |
|
|
| 696 | 698 |
-- |
| 699 |
-- Name: growthform; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 700 |
-- |
|
| 701 |
|
|
| 702 |
CREATE TABLE growthform ( |
|
| 703 |
growthform_id integer NOT NULL, |
|
| 704 |
name text NOT NULL |
|
| 705 |
); |
|
| 706 |
|
|
| 707 |
|
|
| 708 |
-- |
|
| 709 |
-- Name: COLUMN growthform.name; Type: COMMENT; Schema: public; Owner: - |
|
| 710 |
-- |
|
| 711 |
|
|
| 712 |
COMMENT ON COLUMN growthform.name IS 'e.g. tree, shrub, liana, vine, herb, hemiepiphyte, epiphyte, grass, forb, woody, non-woody, cultivated, non-cultivated (not planted), exotic, native, dominant, non-dominant, vascular, nonvascular'; |
|
| 713 |
|
|
| 714 |
|
|
| 715 |
-- |
|
| 716 |
-- Name: growthform_growthform_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 717 |
-- |
|
| 718 |
|
|
| 719 |
CREATE SEQUENCE growthform_growthform_id_seq |
|
| 720 |
START WITH 1 |
|
| 721 |
INCREMENT BY 1 |
|
| 722 |
NO MINVALUE |
|
| 723 |
NO MAXVALUE |
|
| 724 |
CACHE 1; |
|
| 725 |
|
|
| 726 |
|
|
| 727 |
-- |
|
| 728 |
-- Name: growthform_growthform_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 729 |
-- |
|
| 730 |
|
|
| 731 |
ALTER SEQUENCE growthform_growthform_id_seq OWNED BY growthform.growthform_id; |
|
| 732 |
|
|
| 733 |
|
|
| 734 |
SET default_with_oids = true; |
|
| 735 |
|
|
| 736 |
-- |
|
| 697 | 737 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 698 | 738 |
-- |
| 699 | 739 |
|
| ... | ... | |
| 1031 | 1071 |
observationtype text, |
| 1032 | 1072 |
observationmeasure text, |
| 1033 | 1073 |
observationmeasureunits text, |
| 1034 |
taxonclassincluded text, |
|
| 1035 |
taxonclassexcluded text, |
|
| 1036 | 1074 |
covermethod_id integer, |
| 1037 | 1075 |
samplingfactor double precision DEFAULT 1 NOT NULL, |
| 1038 | 1076 |
coverbasis text, |
| ... | ... | |
| 1131 | 1169 |
|
| 1132 | 1170 |
|
| 1133 | 1171 |
-- |
| 1134 |
-- Name: COLUMN method.taxonclassincluded; Type: COMMENT; Schema: public; Owner: - |
|
| 1135 |
-- |
|
| 1136 |
|
|
| 1137 |
COMMENT ON COLUMN method.taxonclassincluded IS 'e.g. tree, shrub, liana, vine, herb, hemiepiphyte, epiphyte, grass, forb, woody, non-woody, cultivated, non-cultivated (not planted), exotic, native, dominant, non-dominant, vascular, nonvascular'; |
|
| 1138 |
|
|
| 1139 |
|
|
| 1140 |
-- |
|
| 1141 |
-- Name: COLUMN method.taxonclassexcluded; Type: COMMENT; Schema: public; Owner: - |
|
| 1142 |
-- |
|
| 1143 |
|
|
| 1144 |
COMMENT ON COLUMN method.taxonclassexcluded IS 'e.g. tree, shrub, liana, vine, herb, hemiepiphyte, epiphyte, grass, forb, woody, non-woody, cultivated, non-cultivated (not planted), exotic, native, dominant, non-dominant, vascular, nonvascular'; |
|
| 1145 |
|
|
| 1146 |
|
|
| 1147 |
-- |
|
| 1148 | 1172 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: - |
| 1149 | 1173 |
-- |
| 1150 | 1174 |
|
| ... | ... | |
| 1249 | 1273 |
ALTER SEQUENCE method_method_id_seq OWNED BY method.method_id; |
| 1250 | 1274 |
|
| 1251 | 1275 |
|
| 1276 |
SET default_with_oids = false; |
|
| 1277 |
|
|
| 1252 | 1278 |
-- |
| 1279 |
-- Name: methodgrowthform; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1280 |
-- |
|
| 1281 |
|
|
| 1282 |
CREATE TABLE methodgrowthform ( |
|
| 1283 |
methodgrowthform_id integer NOT NULL, |
|
| 1284 |
method_id integer NOT NULL, |
|
| 1285 |
growthform_id integer NOT NULL, |
|
| 1286 |
included boolean DEFAULT true NOT NULL |
|
| 1287 |
); |
|
| 1288 |
|
|
| 1289 |
|
|
| 1290 |
-- |
|
| 1291 |
-- Name: COLUMN methodgrowthform.included; Type: COMMENT; Schema: public; Owner: - |
|
| 1292 |
-- |
|
| 1293 |
|
|
| 1294 |
COMMENT ON COLUMN methodgrowthform.included IS 'Whether the method includes or excludes this growth form.'; |
|
| 1295 |
|
|
| 1296 |
|
|
| 1297 |
-- |
|
| 1298 |
-- Name: methodgrowthform_methodgrowthform_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1299 |
-- |
|
| 1300 |
|
|
| 1301 |
CREATE SEQUENCE methodgrowthform_methodgrowthform_id_seq |
|
| 1302 |
START WITH 1 |
|
| 1303 |
INCREMENT BY 1 |
|
| 1304 |
NO MINVALUE |
|
| 1305 |
NO MAXVALUE |
|
| 1306 |
CACHE 1; |
|
| 1307 |
|
|
| 1308 |
|
|
| 1309 |
-- |
|
| 1310 |
-- Name: methodgrowthform_methodgrowthform_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1311 |
-- |
|
| 1312 |
|
|
| 1313 |
ALTER SEQUENCE methodgrowthform_methodgrowthform_id_seq OWNED BY methodgrowthform.methodgrowthform_id; |
|
| 1314 |
|
|
| 1315 |
|
|
| 1316 |
-- |
|
| 1317 |
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1318 |
-- |
|
| 1319 |
|
|
| 1320 |
CREATE TABLE methodtaxonclass ( |
|
| 1321 |
methodtaxonclass_id integer NOT NULL, |
|
| 1322 |
method_id integer NOT NULL, |
|
| 1323 |
plantconcept_id integer NOT NULL, |
|
| 1324 |
included boolean DEFAULT true NOT NULL |
|
| 1325 |
); |
|
| 1326 |
|
|
| 1327 |
|
|
| 1328 |
-- |
|
| 1329 |
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: - |
|
| 1330 |
-- |
|
| 1331 |
|
|
| 1332 |
COMMENT ON COLUMN methodtaxonclass.included IS 'Whether the method includes or excludes this taxon class.'; |
|
| 1333 |
|
|
| 1334 |
|
|
| 1335 |
-- |
|
| 1336 |
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1337 |
-- |
|
| 1338 |
|
|
| 1339 |
CREATE SEQUENCE methodtaxonclass_methodtaxonclass_id_seq |
|
| 1340 |
START WITH 1 |
|
| 1341 |
INCREMENT BY 1 |
|
| 1342 |
NO MINVALUE |
|
| 1343 |
NO MAXVALUE |
|
| 1344 |
CACHE 1; |
|
| 1345 |
|
|
| 1346 |
|
|
| 1347 |
-- |
|
| 1348 |
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1349 |
-- |
|
| 1350 |
|
|
| 1351 |
ALTER SEQUENCE methodtaxonclass_methodtaxonclass_id_seq OWNED BY methodtaxonclass.methodtaxonclass_id; |
|
| 1352 |
|
|
| 1353 |
|
|
| 1354 |
SET default_with_oids = true; |
|
| 1355 |
|
|
| 1356 |
-- |
|
| 1253 | 1357 |
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1254 | 1358 |
-- |
| 1255 | 1359 |
|
| ... | ... | |
| 2777 | 2881 |
|
| 2778 | 2882 |
|
| 2779 | 2883 |
-- |
| 2884 |
-- Name: growthform_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2885 |
-- |
|
| 2886 |
|
|
| 2887 |
ALTER TABLE growthform ALTER COLUMN growthform_id SET DEFAULT nextval('growthform_growthform_id_seq'::regclass);
|
|
| 2888 |
|
|
| 2889 |
|
|
| 2890 |
-- |
|
| 2780 | 2891 |
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: - |
| 2781 | 2892 |
-- |
| 2782 | 2893 |
|
| ... | ... | |
| 2819 | 2930 |
|
| 2820 | 2931 |
|
| 2821 | 2932 |
-- |
| 2933 |
-- Name: methodgrowthform_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2934 |
-- |
|
| 2935 |
|
|
| 2936 |
ALTER TABLE methodgrowthform ALTER COLUMN methodgrowthform_id SET DEFAULT nextval('methodgrowthform_methodgrowthform_id_seq'::regclass);
|
|
| 2937 |
|
|
| 2938 |
|
|
| 2939 |
-- |
|
| 2940 |
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2941 |
-- |
|
| 2942 |
|
|
| 2943 |
ALTER TABLE methodtaxonclass ALTER COLUMN methodtaxonclass_id SET DEFAULT nextval('methodtaxonclass_methodtaxonclass_id_seq'::regclass);
|
|
| 2944 |
|
|
| 2945 |
|
|
| 2946 |
-- |
|
| 2822 | 2947 |
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: - |
| 2823 | 2948 |
-- |
| 2824 | 2949 |
|
| ... | ... | |
| 3261 | 3386 |
|
| 3262 | 3387 |
|
| 3263 | 3388 |
-- |
| 3389 |
-- Name: growthform_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3390 |
-- |
|
| 3391 |
|
|
| 3392 |
ALTER TABLE ONLY growthform |
|
| 3393 |
ADD CONSTRAINT growthform_keys UNIQUE (name); |
|
| 3394 |
|
|
| 3395 |
|
|
| 3396 |
-- |
|
| 3397 |
-- Name: growthform_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3398 |
-- |
|
| 3399 |
|
|
| 3400 |
ALTER TABLE ONLY growthform |
|
| 3401 |
ADD CONSTRAINT growthform_pkey PRIMARY KEY (growthform_id); |
|
| 3402 |
|
|
| 3403 |
|
|
| 3404 |
-- |
|
| 3264 | 3405 |
-- Name: location_keys_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3265 | 3406 |
-- |
| 3266 | 3407 |
|
| ... | ... | |
| 3357 | 3498 |
|
| 3358 | 3499 |
|
| 3359 | 3500 |
-- |
| 3501 |
-- Name: methodgrowthform_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3502 |
-- |
|
| 3503 |
|
|
| 3504 |
ALTER TABLE ONLY methodgrowthform |
|
| 3505 |
ADD CONSTRAINT methodgrowthform_pkey PRIMARY KEY (methodgrowthform_id); |
|
| 3506 |
|
|
| 3507 |
|
|
| 3508 |
-- |
|
| 3509 |
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3510 |
-- |
|
| 3511 |
|
|
| 3512 |
ALTER TABLE ONLY methodtaxonclass |
|
| 3513 |
ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id); |
|
| 3514 |
|
|
| 3515 |
|
|
| 3516 |
-- |
|
| 3360 | 3517 |
-- Name: namedplace_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3361 | 3518 |
-- |
| 3362 | 3519 |
|
| ... | ... | |
| 4162 | 4319 |
|
| 4163 | 4320 |
|
| 4164 | 4321 |
-- |
| 4322 |
-- Name: fki_methodgrowthform_growthform_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4323 |
-- |
|
| 4324 |
|
|
| 4325 |
CREATE INDEX fki_methodgrowthform_growthform_id ON methodgrowthform USING btree (growthform_id); |
|
| 4326 |
|
|
| 4327 |
|
|
| 4328 |
-- |
|
| 4329 |
-- Name: fki_methodgrowthform_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4330 |
-- |
|
| 4331 |
|
|
| 4332 |
CREATE INDEX fki_methodgrowthform_method_id ON methodgrowthform USING btree (method_id); |
|
| 4333 |
|
|
| 4334 |
|
|
| 4335 |
-- |
|
| 4336 |
-- Name: fki_methodtaxonclass_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4337 |
-- |
|
| 4338 |
|
|
| 4339 |
CREATE INDEX fki_methodtaxonclass_method_id ON methodtaxonclass USING btree (method_id); |
|
| 4340 |
|
|
| 4341 |
|
|
| 4342 |
-- |
|
| 4343 |
-- Name: fki_methodtaxonclass_plantconcept_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4344 |
-- |
|
| 4345 |
|
|
| 4346 |
CREATE INDEX fki_methodtaxonclass_plantconcept_id ON methodtaxonclass USING btree (plantconcept_id); |
|
| 4347 |
|
|
| 4348 |
|
|
| 4349 |
-- |
|
| 4165 | 4350 |
-- Name: fki_plantconcept_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4166 | 4351 |
-- |
| 4167 | 4352 |
|
| ... | ... | |
| 5358 | 5543 |
|
| 5359 | 5544 |
|
| 5360 | 5545 |
-- |
| 5546 |
-- Name: methodgrowthform_growthform_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5547 |
-- |
|
| 5548 |
|
|
| 5549 |
ALTER TABLE ONLY methodgrowthform |
|
| 5550 |
ADD CONSTRAINT methodgrowthform_growthform_id FOREIGN KEY (growthform_id) REFERENCES growthform(growthform_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5551 |
|
|
| 5552 |
|
|
| 5553 |
-- |
|
| 5554 |
-- Name: methodgrowthform_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5555 |
-- |
|
| 5556 |
|
|
| 5557 |
ALTER TABLE ONLY methodgrowthform |
|
| 5558 |
ADD CONSTRAINT methodgrowthform_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5559 |
|
|
| 5560 |
|
|
| 5561 |
-- |
|
| 5562 |
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5563 |
-- |
|
| 5564 |
|
|
| 5565 |
ALTER TABLE ONLY methodtaxonclass |
|
| 5566 |
ADD CONSTRAINT methodtaxonclass_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5567 |
|
|
| 5568 |
|
|
| 5569 |
-- |
|
| 5570 |
-- Name: methodtaxonclass_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5571 |
-- |
|
| 5572 |
|
|
| 5573 |
ALTER TABLE ONLY methodtaxonclass |
|
| 5574 |
ADD CONSTRAINT methodtaxonclass_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5575 |
|
|
| 5576 |
|
|
| 5577 |
-- |
|
| 5361 | 5578 |
-- Name: namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5362 | 5579 |
-- |
| 5363 | 5580 |
|
Also available in: Unified diff
vegbien.sql: Replaced method.taxonclassincluded,taxonclassexcluded with new many:many methodtaxonclass table. Added methodgrowthform, growthform tables to do the same thing as methodtaxonclass for growth forms.