Revision 12542
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 1056 | 1056 |
|
| 1057 | 1057 |
|
| 1058 | 1058 |
|
| 1059 |
-- |
|
| 1060 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1061 |
-- |
|
| 1062 | 1059 |
|
| 1063 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 1064 |
projects varchar(255) |
|
| 1065 |
); |
|
| 1066 | 1060 |
|
| 1067 |
|
|
| 1068 | 1061 |
-- |
| 1069 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1070 |
-- |
|
| 1071 |
|
|
| 1072 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 1073 |
project_name varchar(255) |
|
| 1074 |
); |
|
| 1075 |
|
|
| 1076 |
|
|
| 1077 |
-- |
|
| 1078 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1079 |
-- |
|
| 1080 |
|
|
| 1081 |
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` ( |
|
| 1082 |
plots varchar(255) |
|
| 1083 |
); |
|
| 1084 |
|
|
| 1085 |
|
|
| 1086 |
-- |
|
| 1087 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1088 |
-- |
|
| 1089 |
|
|
| 1090 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 1091 |
project_name varchar(255), |
|
| 1092 |
plots varchar(255) |
|
| 1093 |
); |
|
| 1094 |
|
|
| 1095 |
|
|
| 1096 |
-- |
|
| 1097 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1098 |
-- |
|
| 1099 |
|
|
| 1100 |
CREATE TABLE `~type._plots_10_count_of_individuals_per_plot_in_each_project` ( |
|
| 1101 |
project_name varchar(255), |
|
| 1102 |
plot_code varchar(255), |
|
| 1103 |
individuals varchar(255) |
|
| 1104 |
); |
|
| 1105 |
|
|
| 1106 |
|
|
| 1107 |
-- |
|
| 1108 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1109 |
-- |
|
| 1110 |
|
|
| 1111 |
CREATE TABLE `~type._plots_11_count_of_stems_per_plot_in_each_project` ( |
|
| 1112 |
project_name varchar(255), |
|
| 1113 |
plot_code varchar(255), |
|
| 1114 |
stems varchar(255) |
|
| 1115 |
); |
|
| 1116 |
|
|
| 1117 |
|
|
| 1118 |
-- |
|
| 1119 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1120 |
-- |
|
| 1121 |
|
|
| 1122 |
CREATE TABLE `~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project` ( |
|
| 1123 |
project_name varchar(255), |
|
| 1124 |
plot_code varchar(255), |
|
| 1125 |
taxa varchar(255) |
|
| 1126 |
); |
|
| 1127 |
|
|
| 1128 |
|
|
| 1129 |
-- |
|
| 1130 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1131 |
-- |
|
| 1132 |
|
|
| 1133 |
CREATE TABLE `~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_` ( |
|
| 1134 |
project_name varchar(255), |
|
| 1135 |
plot_code varchar(255), |
|
| 1136 |
taxon varchar(255) |
|
| 1137 |
); |
|
| 1138 |
|
|
| 1139 |
|
|
| 1140 |
-- |
|
| 1141 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1142 |
-- |
|
| 1143 |
|
|
| 1144 |
CREATE TABLE `~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e` ( |
|
| 1145 |
project_name varchar(255), |
|
| 1146 |
plot_code varchar(255), |
|
| 1147 |
taxon varchar(255), |
|
| 1148 |
individuals varchar(255) |
|
| 1149 |
); |
|
| 1150 |
|
|
| 1151 |
|
|
| 1152 |
-- |
|
| 1153 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1154 |
-- |
|
| 1155 |
|
|
| 1156 |
CREATE TABLE `~type._plots_17_count_of_subplots_per_plot_for_each_project` ( |
|
| 1157 |
project_name varchar(255), |
|
| 1158 |
plot_code varchar(255), |
|
| 1159 |
subplots varchar(255) |
|
| 1160 |
); |
|
| 1161 |
|
|
| 1162 |
|
|
| 1163 |
-- |
|
| 1164 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1165 |
-- |
|
| 1166 |
|
|
| 1167 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 1168 |
`totalRecords` varchar(255) |
|
| 1169 |
); |
|
| 1170 |
|
|
| 1171 |
|
|
| 1172 |
-- |
|
| 1173 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1174 |
-- |
|
| 1175 |
|
|
| 1176 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 1177 |
traits varchar(255) |
|
| 1178 |
); |
|
| 1179 |
|
|
| 1180 |
|
|
| 1181 |
-- |
|
| 1182 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1183 |
-- |
|
| 1184 |
|
|
| 1185 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 1186 |
trait varchar(255) |
|
| 1187 |
); |
|
| 1188 |
|
|
| 1189 |
|
|
| 1190 |
-- |
|
| 1191 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1192 |
-- |
|
| 1193 |
|
|
| 1194 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 1195 |
trait varchar(255), |
|
| 1196 |
measurements varchar(255) |
|
| 1197 |
); |
|
| 1198 |
|
|
| 1199 |
|
|
| 1200 |
-- |
|
| 1201 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1202 |
-- |
|
| 1203 |
|
|
| 1204 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 1205 |
taxa varchar(255) |
|
| 1206 |
); |
|
| 1207 |
|
|
| 1208 |
|
|
| 1209 |
-- |
|
| 1210 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1211 |
-- |
|
| 1212 |
|
|
| 1213 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 1214 |
taxonwithauthor varchar(255) |
|
| 1215 |
); |
|
| 1216 |
|
|
| 1217 |
|
|
| 1218 |
-- |
|
| 1219 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1220 |
-- |
|
| 1221 |
|
|
| 1222 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 1223 |
trait varchar(255), |
|
| 1224 |
value varchar(255), |
|
| 1225 |
units varchar(255) |
|
| 1226 |
); |
|
| 1227 |
|
|
| 1228 |
|
|
| 1229 |
-- |
|
| 1230 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1231 |
-- |
|
| 1232 |
|
|
| 1233 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 1234 |
taxonwithauthor varchar(255), |
|
| 1235 |
trait varchar(255), |
|
| 1236 |
value varchar(255) |
|
| 1237 |
); |
|
| 1238 |
|
|
| 1239 |
|
|
| 1240 |
|
|
| 1241 |
|
|
| 1242 |
-- |
|
| 1243 | 1062 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1244 | 1063 |
-- |
| 1245 | 1064 |
|
| ... | ... | |
| 4050 | 3869 |
|
| 4051 | 3870 |
|
| 4052 | 3871 |
|
| 3872 |
-- |
|
| 3873 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3874 |
-- |
|
| 4053 | 3875 |
|
| 3876 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 3877 |
projects varchar(255) |
|
| 3878 |
); |
|
| 4054 | 3879 |
|
| 3880 |
|
|
| 4055 | 3881 |
-- |
| 3882 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3883 |
-- |
|
| 3884 |
|
|
| 3885 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 3886 |
project_name varchar(255) |
|
| 3887 |
); |
|
| 3888 |
|
|
| 3889 |
|
|
| 3890 |
-- |
|
| 3891 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3892 |
-- |
|
| 3893 |
|
|
| 3894 |
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` ( |
|
| 3895 |
plots varchar(255) |
|
| 3896 |
); |
|
| 3897 |
|
|
| 3898 |
|
|
| 3899 |
-- |
|
| 3900 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3901 |
-- |
|
| 3902 |
|
|
| 3903 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 3904 |
project_name varchar(255), |
|
| 3905 |
plots varchar(255) |
|
| 3906 |
); |
|
| 3907 |
|
|
| 3908 |
|
|
| 3909 |
-- |
|
| 3910 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3911 |
-- |
|
| 3912 |
|
|
| 3913 |
CREATE TABLE `~type._plots_10_count_of_individuals_per_plot_in_each_project` ( |
|
| 3914 |
project_name varchar(255), |
|
| 3915 |
plot_code varchar(255), |
|
| 3916 |
individuals varchar(255) |
|
| 3917 |
); |
|
| 3918 |
|
|
| 3919 |
|
|
| 3920 |
-- |
|
| 3921 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3922 |
-- |
|
| 3923 |
|
|
| 3924 |
CREATE TABLE `~type._plots_11_count_of_stems_per_plot_in_each_project` ( |
|
| 3925 |
project_name varchar(255), |
|
| 3926 |
plot_code varchar(255), |
|
| 3927 |
stems varchar(255) |
|
| 3928 |
); |
|
| 3929 |
|
|
| 3930 |
|
|
| 3931 |
-- |
|
| 3932 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3933 |
-- |
|
| 3934 |
|
|
| 3935 |
CREATE TABLE `~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project` ( |
|
| 3936 |
project_name varchar(255), |
|
| 3937 |
plot_code varchar(255), |
|
| 3938 |
taxa varchar(255) |
|
| 3939 |
); |
|
| 3940 |
|
|
| 3941 |
|
|
| 3942 |
-- |
|
| 3943 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3944 |
-- |
|
| 3945 |
|
|
| 3946 |
CREATE TABLE `~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_` ( |
|
| 3947 |
project_name varchar(255), |
|
| 3948 |
plot_code varchar(255), |
|
| 3949 |
taxon varchar(255) |
|
| 3950 |
); |
|
| 3951 |
|
|
| 3952 |
|
|
| 3953 |
-- |
|
| 3954 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3955 |
-- |
|
| 3956 |
|
|
| 3957 |
CREATE TABLE `~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e` ( |
|
| 3958 |
project_name varchar(255), |
|
| 3959 |
plot_code varchar(255), |
|
| 3960 |
taxon varchar(255), |
|
| 3961 |
individuals varchar(255) |
|
| 3962 |
); |
|
| 3963 |
|
|
| 3964 |
|
|
| 3965 |
-- |
|
| 3966 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3967 |
-- |
|
| 3968 |
|
|
| 3969 |
CREATE TABLE `~type._plots_17_count_of_subplots_per_plot_for_each_project` ( |
|
| 3970 |
project_name varchar(255), |
|
| 3971 |
plot_code varchar(255), |
|
| 3972 |
subplots varchar(255) |
|
| 3973 |
); |
|
| 3974 |
|
|
| 3975 |
|
|
| 3976 |
-- |
|
| 3977 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3978 |
-- |
|
| 3979 |
|
|
| 3980 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 3981 |
`totalRecords` varchar(255) |
|
| 3982 |
); |
|
| 3983 |
|
|
| 3984 |
|
|
| 3985 |
-- |
|
| 3986 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3987 |
-- |
|
| 3988 |
|
|
| 3989 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 3990 |
traits varchar(255) |
|
| 3991 |
); |
|
| 3992 |
|
|
| 3993 |
|
|
| 3994 |
-- |
|
| 3995 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3996 |
-- |
|
| 3997 |
|
|
| 3998 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 3999 |
trait varchar(255) |
|
| 4000 |
); |
|
| 4001 |
|
|
| 4002 |
|
|
| 4003 |
-- |
|
| 4004 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4005 |
-- |
|
| 4006 |
|
|
| 4007 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 4008 |
trait varchar(255), |
|
| 4009 |
measurements varchar(255) |
|
| 4010 |
); |
|
| 4011 |
|
|
| 4012 |
|
|
| 4013 |
-- |
|
| 4014 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4015 |
-- |
|
| 4016 |
|
|
| 4017 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 4018 |
taxa varchar(255) |
|
| 4019 |
); |
|
| 4020 |
|
|
| 4021 |
|
|
| 4022 |
-- |
|
| 4023 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4024 |
-- |
|
| 4025 |
|
|
| 4026 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 4027 |
taxonwithauthor varchar(255) |
|
| 4028 |
); |
|
| 4029 |
|
|
| 4030 |
|
|
| 4031 |
-- |
|
| 4032 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4033 |
-- |
|
| 4034 |
|
|
| 4035 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 4036 |
trait varchar(255), |
|
| 4037 |
value varchar(255), |
|
| 4038 |
units varchar(255) |
|
| 4039 |
); |
|
| 4040 |
|
|
| 4041 |
|
|
| 4042 |
-- |
|
| 4043 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4044 |
-- |
|
| 4045 |
|
|
| 4046 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 4047 |
taxonwithauthor varchar(255), |
|
| 4048 |
trait varchar(255), |
|
| 4049 |
value varchar(255) |
|
| 4050 |
); |
|
| 4051 |
|
|
| 4052 |
|
|
| 4053 |
|
|
| 4054 |
|
|
| 4055 |
-- |
|
| 4056 | 4056 |
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: - |
| 4057 | 4057 |
-- |
| 4058 | 4058 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 2451 | 2451 |
$_$; |
| 2452 | 2452 |
|
| 2453 | 2453 |
|
| 2454 |
-- |
|
| 2455 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2456 |
-- |
|
| 2457 |
|
|
| 2458 |
CREATE TABLE "~type._plots_01_count_of_projects" ( |
|
| 2459 |
projects bigint |
|
| 2460 |
); |
|
| 2461 |
|
|
| 2462 |
|
|
| 2463 |
-- |
|
| 2464 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2465 |
-- |
|
| 2466 |
|
|
| 2467 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
| 2468 |
project_name text |
|
| 2469 |
); |
|
| 2470 |
|
|
| 2471 |
|
|
| 2472 |
-- |
|
| 2473 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2474 |
-- |
|
| 2475 |
|
|
| 2476 |
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" ( |
|
| 2477 |
plots bigint |
|
| 2478 |
); |
|
| 2479 |
|
|
| 2480 |
|
|
| 2481 |
-- |
|
| 2482 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2483 |
-- |
|
| 2484 |
|
|
| 2485 |
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" ( |
|
| 2486 |
project_name text, |
|
| 2487 |
plots bigint |
|
| 2488 |
); |
|
| 2489 |
|
|
| 2490 |
|
|
| 2491 |
-- |
|
| 2492 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2493 |
-- |
|
| 2494 |
|
|
| 2495 |
CREATE TABLE "~type._plots_10_count_of_individuals_per_plot_in_each_project" ( |
|
| 2496 |
project_name text, |
|
| 2497 |
plot_code text, |
|
| 2498 |
individuals bigint |
|
| 2499 |
); |
|
| 2500 |
|
|
| 2501 |
|
|
| 2502 |
-- |
|
| 2503 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2504 |
-- |
|
| 2505 |
|
|
| 2506 |
CREATE TABLE "~type._plots_11_count_of_stems_per_plot_in_each_project" ( |
|
| 2507 |
project_name text, |
|
| 2508 |
plot_code text, |
|
| 2509 |
stems bigint |
|
| 2510 |
); |
|
| 2511 |
|
|
| 2512 |
|
|
| 2513 |
-- |
|
| 2514 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2515 |
-- |
|
| 2516 |
|
|
| 2517 |
CREATE TABLE "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project" ( |
|
| 2518 |
project_name text, |
|
| 2519 |
plot_code text, |
|
| 2520 |
taxa bigint |
|
| 2521 |
); |
|
| 2522 |
|
|
| 2523 |
|
|
| 2524 |
-- |
|
| 2525 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2526 |
-- |
|
| 2527 |
|
|
| 2528 |
CREATE TABLE "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_" ( |
|
| 2529 |
project_name text, |
|
| 2530 |
plot_code text, |
|
| 2531 |
taxon text |
|
| 2532 |
); |
|
| 2533 |
|
|
| 2534 |
|
|
| 2535 |
-- |
|
| 2536 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2537 |
-- |
|
| 2538 |
|
|
| 2539 |
CREATE TABLE "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e" ( |
|
| 2540 |
project_name text, |
|
| 2541 |
plot_code text, |
|
| 2542 |
taxon text, |
|
| 2543 |
individuals bigint |
|
| 2544 |
); |
|
| 2545 |
|
|
| 2546 |
|
|
| 2547 |
-- |
|
| 2548 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2549 |
-- |
|
| 2550 |
|
|
| 2551 |
CREATE TABLE "~type._plots_17_count_of_subplots_per_plot_for_each_project" ( |
|
| 2552 |
project_name text, |
|
| 2553 |
plot_code text, |
|
| 2554 |
subplots bigint |
|
| 2555 |
); |
|
| 2556 |
|
|
| 2557 |
|
|
| 2558 |
-- |
|
| 2559 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2560 |
-- |
|
| 2561 |
|
|
| 2562 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 2563 |
"totalRecords" bigint |
|
| 2564 |
); |
|
| 2565 |
|
|
| 2566 |
|
|
| 2567 |
-- |
|
| 2568 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2569 |
-- |
|
| 2570 |
|
|
| 2571 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 2572 |
traits bigint |
|
| 2573 |
); |
|
| 2574 |
|
|
| 2575 |
|
|
| 2576 |
-- |
|
| 2577 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2578 |
-- |
|
| 2579 |
|
|
| 2580 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 2581 |
trait text |
|
| 2582 |
); |
|
| 2583 |
|
|
| 2584 |
|
|
| 2585 |
-- |
|
| 2586 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2587 |
-- |
|
| 2588 |
|
|
| 2589 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 2590 |
trait text, |
|
| 2591 |
measurements bigint |
|
| 2592 |
); |
|
| 2593 |
|
|
| 2594 |
|
|
| 2595 |
-- |
|
| 2596 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2597 |
-- |
|
| 2598 |
|
|
| 2599 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 2600 |
taxa bigint |
|
| 2601 |
); |
|
| 2602 |
|
|
| 2603 |
|
|
| 2604 |
-- |
|
| 2605 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2606 |
-- |
|
| 2607 |
|
|
| 2608 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 2609 |
taxonwithauthor text |
|
| 2610 |
); |
|
| 2611 |
|
|
| 2612 |
|
|
| 2613 |
-- |
|
| 2614 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2615 |
-- |
|
| 2616 |
|
|
| 2617 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 2618 |
trait text, |
|
| 2619 |
value text, |
|
| 2620 |
units text |
|
| 2621 |
); |
|
| 2622 |
|
|
| 2623 |
|
|
| 2624 |
-- |
|
| 2625 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2626 |
-- |
|
| 2627 |
|
|
| 2628 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 2629 |
taxonwithauthor text, |
|
| 2630 |
trait text, |
|
| 2631 |
value text |
|
| 2632 |
); |
|
| 2633 |
|
|
| 2634 |
|
|
| 2635 | 2454 |
SET search_path = public, pg_catalog; |
| 2636 | 2455 |
|
| 2637 | 2456 |
-- |
| ... | ... | |
| 6549 | 6368 |
ORDER BY taxonverbatim.taxonname; |
| 6550 | 6369 |
|
| 6551 | 6370 |
|
| 6371 |
-- |
|
| 6372 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6373 |
-- |
|
| 6374 |
|
|
| 6375 |
CREATE TABLE "~type._plots_01_count_of_projects" ( |
|
| 6376 |
projects bigint |
|
| 6377 |
); |
|
| 6378 |
|
|
| 6379 |
|
|
| 6380 |
-- |
|
| 6381 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6382 |
-- |
|
| 6383 |
|
|
| 6384 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
| 6385 |
project_name text |
|
| 6386 |
); |
|
| 6387 |
|
|
| 6388 |
|
|
| 6389 |
-- |
|
| 6390 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6391 |
-- |
|
| 6392 |
|
|
| 6393 |
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" ( |
|
| 6394 |
plots bigint |
|
| 6395 |
); |
|
| 6396 |
|
|
| 6397 |
|
|
| 6398 |
-- |
|
| 6399 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6400 |
-- |
|
| 6401 |
|
|
| 6402 |
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" ( |
|
| 6403 |
project_name text, |
|
| 6404 |
plots bigint |
|
| 6405 |
); |
|
| 6406 |
|
|
| 6407 |
|
|
| 6408 |
-- |
|
| 6409 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6410 |
-- |
|
| 6411 |
|
|
| 6412 |
CREATE TABLE "~type._plots_10_count_of_individuals_per_plot_in_each_project" ( |
|
| 6413 |
project_name text, |
|
| 6414 |
plot_code text, |
|
| 6415 |
individuals bigint |
|
| 6416 |
); |
|
| 6417 |
|
|
| 6418 |
|
|
| 6419 |
-- |
|
| 6420 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6421 |
-- |
|
| 6422 |
|
|
| 6423 |
CREATE TABLE "~type._plots_11_count_of_stems_per_plot_in_each_project" ( |
|
| 6424 |
project_name text, |
|
| 6425 |
plot_code text, |
|
| 6426 |
stems bigint |
|
| 6427 |
); |
|
| 6428 |
|
|
| 6429 |
|
|
| 6430 |
-- |
|
| 6431 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6432 |
-- |
|
| 6433 |
|
|
| 6434 |
CREATE TABLE "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project" ( |
|
| 6435 |
project_name text, |
|
| 6436 |
plot_code text, |
|
| 6437 |
taxa bigint |
|
| 6438 |
); |
|
| 6439 |
|
|
| 6440 |
|
|
| 6441 |
-- |
|
| 6442 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6443 |
-- |
|
| 6444 |
|
|
| 6445 |
CREATE TABLE "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_" ( |
|
| 6446 |
project_name text, |
|
| 6447 |
plot_code text, |
|
| 6448 |
taxon text |
|
| 6449 |
); |
|
| 6450 |
|
|
| 6451 |
|
|
| 6452 |
-- |
|
| 6453 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6454 |
-- |
|
| 6455 |
|
|
| 6456 |
CREATE TABLE "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e" ( |
|
| 6457 |
project_name text, |
|
| 6458 |
plot_code text, |
|
| 6459 |
taxon text, |
|
| 6460 |
individuals bigint |
|
| 6461 |
); |
|
| 6462 |
|
|
| 6463 |
|
|
| 6464 |
-- |
|
| 6465 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6466 |
-- |
|
| 6467 |
|
|
| 6468 |
CREATE TABLE "~type._plots_17_count_of_subplots_per_plot_for_each_project" ( |
|
| 6469 |
project_name text, |
|
| 6470 |
plot_code text, |
|
| 6471 |
subplots bigint |
|
| 6472 |
); |
|
| 6473 |
|
|
| 6474 |
|
|
| 6475 |
-- |
|
| 6476 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6477 |
-- |
|
| 6478 |
|
|
| 6479 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 6480 |
"totalRecords" bigint |
|
| 6481 |
); |
|
| 6482 |
|
|
| 6483 |
|
|
| 6484 |
-- |
|
| 6485 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6486 |
-- |
|
| 6487 |
|
|
| 6488 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 6489 |
traits bigint |
|
| 6490 |
); |
|
| 6491 |
|
|
| 6492 |
|
|
| 6493 |
-- |
|
| 6494 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6495 |
-- |
|
| 6496 |
|
|
| 6497 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 6498 |
trait text |
|
| 6499 |
); |
|
| 6500 |
|
|
| 6501 |
|
|
| 6502 |
-- |
|
| 6503 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6504 |
-- |
|
| 6505 |
|
|
| 6506 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 6507 |
trait text, |
|
| 6508 |
measurements bigint |
|
| 6509 |
); |
|
| 6510 |
|
|
| 6511 |
|
|
| 6512 |
-- |
|
| 6513 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6514 |
-- |
|
| 6515 |
|
|
| 6516 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 6517 |
taxa bigint |
|
| 6518 |
); |
|
| 6519 |
|
|
| 6520 |
|
|
| 6521 |
-- |
|
| 6522 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6523 |
-- |
|
| 6524 |
|
|
| 6525 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 6526 |
taxonwithauthor text |
|
| 6527 |
); |
|
| 6528 |
|
|
| 6529 |
|
|
| 6530 |
-- |
|
| 6531 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6532 |
-- |
|
| 6533 |
|
|
| 6534 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 6535 |
trait text, |
|
| 6536 |
value text, |
|
| 6537 |
units text |
|
| 6538 |
); |
|
| 6539 |
|
|
| 6540 |
|
|
| 6541 |
-- |
|
| 6542 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6543 |
-- |
|
| 6544 |
|
|
| 6545 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 6546 |
taxonwithauthor text, |
|
| 6547 |
trait text, |
|
| 6548 |
value text |
|
| 6549 |
); |
|
| 6550 |
|
|
| 6551 |
|
|
| 6552 | 6552 |
SET search_path = public, pg_catalog; |
| 6553 | 6553 |
|
| 6554 | 6554 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: synced with DB, which reorders ~type tables