Revision 12542
Added by Aaron Marcuse-Kubitza almost 11 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