Revision 12557
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 1090 | 1090 |
|
| 1091 | 1091 |
|
| 1092 | 1092 |
|
| 1093 |
-- |
|
| 1094 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1095 |
-- |
|
| 1096 | 1093 |
|
| 1097 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 1098 |
projects varchar(255) |
|
| 1099 |
); |
|
| 1100 | 1094 |
|
| 1101 |
|
|
| 1102 | 1095 |
-- |
| 1103 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1104 |
-- |
|
| 1105 |
|
|
| 1106 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 1107 |
project_name varchar(255) |
|
| 1108 |
); |
|
| 1109 |
|
|
| 1110 |
|
|
| 1111 |
-- |
|
| 1112 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1113 |
-- |
|
| 1114 |
|
|
| 1115 |
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` ( |
|
| 1116 |
plots varchar(255) |
|
| 1117 |
); |
|
| 1118 |
|
|
| 1119 |
|
|
| 1120 |
-- |
|
| 1121 |
-- Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1122 |
-- |
|
| 1123 |
|
|
| 1124 |
CREATE TABLE `~type._plots_05_list_of_plot_codes_by_project` ( |
|
| 1125 |
project_name varchar(255), |
|
| 1126 |
plot_code varchar(255) |
|
| 1127 |
); |
|
| 1128 |
|
|
| 1129 |
|
|
| 1130 |
-- |
|
| 1131 |
-- Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1132 |
-- |
|
| 1133 |
|
|
| 1134 |
CREATE TABLE `~type._plots_06_list_of_plots_with_stem_measurements` ( |
|
| 1135 |
project_name varchar(255), |
|
| 1136 |
plot_code varchar(255) |
|
| 1137 |
); |
|
| 1138 |
|
|
| 1139 |
|
|
| 1140 |
-- |
|
| 1141 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1142 |
-- |
|
| 1143 |
|
|
| 1144 |
CREATE TABLE `~type._plots_10_count_of_individuals_per_plot_in_each_project` ( |
|
| 1145 |
project_name varchar(255), |
|
| 1146 |
plot_code varchar(255), |
|
| 1147 |
individuals varchar(255) |
|
| 1148 |
); |
|
| 1149 |
|
|
| 1150 |
|
|
| 1151 |
-- |
|
| 1152 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1153 |
-- |
|
| 1154 |
|
|
| 1155 |
CREATE TABLE `~type._plots_11_count_of_stems_per_plot_in_each_project` ( |
|
| 1156 |
project_name varchar(255), |
|
| 1157 |
plot_code varchar(255), |
|
| 1158 |
stems varchar(255) |
|
| 1159 |
); |
|
| 1160 |
|
|
| 1161 |
|
|
| 1162 |
-- |
|
| 1163 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1164 |
-- |
|
| 1165 |
|
|
| 1166 |
CREATE TABLE `~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project` ( |
|
| 1167 |
project_name varchar(255), |
|
| 1168 |
plot_code varchar(255), |
|
| 1169 |
taxa varchar(255) |
|
| 1170 |
); |
|
| 1171 |
|
|
| 1172 |
|
|
| 1173 |
-- |
|
| 1174 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1175 |
-- |
|
| 1176 |
|
|
| 1177 |
CREATE TABLE `~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_` ( |
|
| 1178 |
project_name varchar(255), |
|
| 1179 |
plot_code varchar(255), |
|
| 1180 |
taxon varchar(255) |
|
| 1181 |
); |
|
| 1182 |
|
|
| 1183 |
|
|
| 1184 |
-- |
|
| 1185 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1186 |
-- |
|
| 1187 |
|
|
| 1188 |
CREATE TABLE `~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e` ( |
|
| 1189 |
project_name varchar(255), |
|
| 1190 |
plot_code varchar(255), |
|
| 1191 |
taxon varchar(255), |
|
| 1192 |
individuals varchar(255) |
|
| 1193 |
); |
|
| 1194 |
|
|
| 1195 |
|
|
| 1196 |
-- |
|
| 1197 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1198 |
-- |
|
| 1199 |
|
|
| 1200 |
CREATE TABLE `~type._plots_17_count_of_subplots_per_plot_for_each_project` ( |
|
| 1201 |
project_name varchar(255), |
|
| 1202 |
plot_code varchar(255), |
|
| 1203 |
subplots varchar(255) |
|
| 1204 |
); |
|
| 1205 |
|
|
| 1206 |
|
|
| 1207 |
|
|
| 1208 |
|
|
| 1209 |
-- |
|
| 1210 | 1096 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1211 | 1097 |
-- |
| 1212 | 1098 |
|
| ... | ... | |
| 4018 | 3904 |
|
| 4019 | 3905 |
|
| 4020 | 3906 |
-- |
| 3907 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3908 |
-- |
|
| 3909 |
|
|
| 3910 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 3911 |
projects varchar(255) |
|
| 3912 |
); |
|
| 3913 |
|
|
| 3914 |
|
|
| 3915 |
-- |
|
| 3916 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3917 |
-- |
|
| 3918 |
|
|
| 3919 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 3920 |
project_name varchar(255) |
|
| 3921 |
); |
|
| 3922 |
|
|
| 3923 |
|
|
| 3924 |
-- |
|
| 3925 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3926 |
-- |
|
| 3927 |
|
|
| 3928 |
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` ( |
|
| 3929 |
plots varchar(255) |
|
| 3930 |
); |
|
| 3931 |
|
|
| 3932 |
|
|
| 3933 |
-- |
|
| 3934 |
-- Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3935 |
-- |
|
| 3936 |
|
|
| 3937 |
CREATE TABLE `~type._plots_05_list_of_plot_codes_by_project` ( |
|
| 3938 |
project_name varchar(255), |
|
| 3939 |
plot_code varchar(255) |
|
| 3940 |
); |
|
| 3941 |
|
|
| 3942 |
|
|
| 3943 |
-- |
|
| 3944 |
-- Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3945 |
-- |
|
| 3946 |
|
|
| 3947 |
CREATE TABLE `~type._plots_06_list_of_plots_with_stem_measurements` ( |
|
| 3948 |
project_name varchar(255), |
|
| 3949 |
plot_code varchar(255) |
|
| 3950 |
); |
|
| 3951 |
|
|
| 3952 |
|
|
| 3953 |
-- |
|
| 3954 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3955 |
-- |
|
| 3956 |
|
|
| 3957 |
CREATE TABLE `~type._plots_10_count_of_individuals_per_plot_in_each_project` ( |
|
| 3958 |
project_name varchar(255), |
|
| 3959 |
plot_code varchar(255), |
|
| 3960 |
individuals varchar(255) |
|
| 3961 |
); |
|
| 3962 |
|
|
| 3963 |
|
|
| 3964 |
-- |
|
| 3965 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3966 |
-- |
|
| 3967 |
|
|
| 3968 |
CREATE TABLE `~type._plots_11_count_of_stems_per_plot_in_each_project` ( |
|
| 3969 |
project_name varchar(255), |
|
| 3970 |
plot_code varchar(255), |
|
| 3971 |
stems varchar(255) |
|
| 3972 |
); |
|
| 3973 |
|
|
| 3974 |
|
|
| 3975 |
-- |
|
| 3976 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3977 |
-- |
|
| 3978 |
|
|
| 3979 |
CREATE TABLE `~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project` ( |
|
| 3980 |
project_name varchar(255), |
|
| 3981 |
plot_code varchar(255), |
|
| 3982 |
taxa varchar(255) |
|
| 3983 |
); |
|
| 3984 |
|
|
| 3985 |
|
|
| 3986 |
-- |
|
| 3987 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3988 |
-- |
|
| 3989 |
|
|
| 3990 |
CREATE TABLE `~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_` ( |
|
| 3991 |
project_name varchar(255), |
|
| 3992 |
plot_code varchar(255), |
|
| 3993 |
taxon varchar(255) |
|
| 3994 |
); |
|
| 3995 |
|
|
| 3996 |
|
|
| 3997 |
-- |
|
| 3998 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3999 |
-- |
|
| 4000 |
|
|
| 4001 |
CREATE TABLE `~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e` ( |
|
| 4002 |
project_name varchar(255), |
|
| 4003 |
plot_code varchar(255), |
|
| 4004 |
taxon varchar(255), |
|
| 4005 |
individuals varchar(255) |
|
| 4006 |
); |
|
| 4007 |
|
|
| 4008 |
|
|
| 4009 |
-- |
|
| 4010 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4011 |
-- |
|
| 4012 |
|
|
| 4013 |
CREATE TABLE `~type._plots_17_count_of_subplots_per_plot_for_each_project` ( |
|
| 4014 |
project_name varchar(255), |
|
| 4015 |
plot_code varchar(255), |
|
| 4016 |
subplots varchar(255) |
|
| 4017 |
); |
|
| 4018 |
|
|
| 4019 |
|
|
| 4020 |
-- |
|
| 4021 | 4021 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 4022 | 4022 |
-- |
| 4023 | 4023 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 2498 | 2498 |
$_$; |
| 2499 | 2499 |
|
| 2500 | 2500 |
|
| 2501 |
-- |
|
| 2502 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2503 |
-- |
|
| 2504 |
|
|
| 2505 |
CREATE TABLE "~type._plots_01_count_of_projects" ( |
|
| 2506 |
projects bigint |
|
| 2507 |
); |
|
| 2508 |
|
|
| 2509 |
|
|
| 2510 |
-- |
|
| 2511 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2512 |
-- |
|
| 2513 |
|
|
| 2514 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
| 2515 |
project_name text |
|
| 2516 |
); |
|
| 2517 |
|
|
| 2518 |
|
|
| 2519 |
-- |
|
| 2520 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2521 |
-- |
|
| 2522 |
|
|
| 2523 |
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" ( |
|
| 2524 |
plots bigint |
|
| 2525 |
); |
|
| 2526 |
|
|
| 2527 |
|
|
| 2528 |
-- |
|
| 2529 |
-- Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2530 |
-- |
|
| 2531 |
|
|
| 2532 |
CREATE TABLE "~type._plots_05_list_of_plot_codes_by_project" ( |
|
| 2533 |
project_name text, |
|
| 2534 |
plot_code text |
|
| 2535 |
); |
|
| 2536 |
|
|
| 2537 |
|
|
| 2538 |
-- |
|
| 2539 |
-- Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2540 |
-- |
|
| 2541 |
|
|
| 2542 |
CREATE TABLE "~type._plots_06_list_of_plots_with_stem_measurements" ( |
|
| 2543 |
project_name text, |
|
| 2544 |
plot_code text |
|
| 2545 |
); |
|
| 2546 |
|
|
| 2547 |
|
|
| 2548 |
-- |
|
| 2549 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2550 |
-- |
|
| 2551 |
|
|
| 2552 |
CREATE TABLE "~type._plots_10_count_of_individuals_per_plot_in_each_project" ( |
|
| 2553 |
project_name text, |
|
| 2554 |
plot_code text, |
|
| 2555 |
individuals bigint |
|
| 2556 |
); |
|
| 2557 |
|
|
| 2558 |
|
|
| 2559 |
-- |
|
| 2560 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2561 |
-- |
|
| 2562 |
|
|
| 2563 |
CREATE TABLE "~type._plots_11_count_of_stems_per_plot_in_each_project" ( |
|
| 2564 |
project_name text, |
|
| 2565 |
plot_code text, |
|
| 2566 |
stems bigint |
|
| 2567 |
); |
|
| 2568 |
|
|
| 2569 |
|
|
| 2570 |
-- |
|
| 2571 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2572 |
-- |
|
| 2573 |
|
|
| 2574 |
CREATE TABLE "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project" ( |
|
| 2575 |
project_name text, |
|
| 2576 |
plot_code text, |
|
| 2577 |
taxa bigint |
|
| 2578 |
); |
|
| 2579 |
|
|
| 2580 |
|
|
| 2581 |
-- |
|
| 2582 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2583 |
-- |
|
| 2584 |
|
|
| 2585 |
CREATE TABLE "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_" ( |
|
| 2586 |
project_name text, |
|
| 2587 |
plot_code text, |
|
| 2588 |
taxon text |
|
| 2589 |
); |
|
| 2590 |
|
|
| 2591 |
|
|
| 2592 |
-- |
|
| 2593 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2594 |
-- |
|
| 2595 |
|
|
| 2596 |
CREATE TABLE "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e" ( |
|
| 2597 |
project_name text, |
|
| 2598 |
plot_code text, |
|
| 2599 |
taxon text, |
|
| 2600 |
individuals bigint |
|
| 2601 |
); |
|
| 2602 |
|
|
| 2603 |
|
|
| 2604 |
-- |
|
| 2605 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2606 |
-- |
|
| 2607 |
|
|
| 2608 |
CREATE TABLE "~type._plots_17_count_of_subplots_per_plot_for_each_project" ( |
|
| 2609 |
project_name text, |
|
| 2610 |
plot_code text, |
|
| 2611 |
subplots bigint |
|
| 2612 |
); |
|
| 2613 |
|
|
| 2614 |
|
|
| 2615 | 2501 |
SET search_path = public, pg_catalog; |
| 2616 | 2502 |
|
| 2617 | 2503 |
-- |
| ... | ... | |
| 6530 | 6416 |
|
| 6531 | 6417 |
|
| 6532 | 6418 |
-- |
| 6419 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6420 |
-- |
|
| 6421 |
|
|
| 6422 |
CREATE TABLE "~type._plots_01_count_of_projects" ( |
|
| 6423 |
projects bigint |
|
| 6424 |
); |
|
| 6425 |
|
|
| 6426 |
|
|
| 6427 |
-- |
|
| 6428 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6429 |
-- |
|
| 6430 |
|
|
| 6431 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
| 6432 |
project_name text |
|
| 6433 |
); |
|
| 6434 |
|
|
| 6435 |
|
|
| 6436 |
-- |
|
| 6437 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6438 |
-- |
|
| 6439 |
|
|
| 6440 |
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" ( |
|
| 6441 |
plots bigint |
|
| 6442 |
); |
|
| 6443 |
|
|
| 6444 |
|
|
| 6445 |
-- |
|
| 6446 |
-- Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6447 |
-- |
|
| 6448 |
|
|
| 6449 |
CREATE TABLE "~type._plots_05_list_of_plot_codes_by_project" ( |
|
| 6450 |
project_name text, |
|
| 6451 |
plot_code text |
|
| 6452 |
); |
|
| 6453 |
|
|
| 6454 |
|
|
| 6455 |
-- |
|
| 6456 |
-- Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6457 |
-- |
|
| 6458 |
|
|
| 6459 |
CREATE TABLE "~type._plots_06_list_of_plots_with_stem_measurements" ( |
|
| 6460 |
project_name text, |
|
| 6461 |
plot_code text |
|
| 6462 |
); |
|
| 6463 |
|
|
| 6464 |
|
|
| 6465 |
-- |
|
| 6466 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6467 |
-- |
|
| 6468 |
|
|
| 6469 |
CREATE TABLE "~type._plots_10_count_of_individuals_per_plot_in_each_project" ( |
|
| 6470 |
project_name text, |
|
| 6471 |
plot_code text, |
|
| 6472 |
individuals bigint |
|
| 6473 |
); |
|
| 6474 |
|
|
| 6475 |
|
|
| 6476 |
-- |
|
| 6477 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6478 |
-- |
|
| 6479 |
|
|
| 6480 |
CREATE TABLE "~type._plots_11_count_of_stems_per_plot_in_each_project" ( |
|
| 6481 |
project_name text, |
|
| 6482 |
plot_code text, |
|
| 6483 |
stems bigint |
|
| 6484 |
); |
|
| 6485 |
|
|
| 6486 |
|
|
| 6487 |
-- |
|
| 6488 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6489 |
-- |
|
| 6490 |
|
|
| 6491 |
CREATE TABLE "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project" ( |
|
| 6492 |
project_name text, |
|
| 6493 |
plot_code text, |
|
| 6494 |
taxa bigint |
|
| 6495 |
); |
|
| 6496 |
|
|
| 6497 |
|
|
| 6498 |
-- |
|
| 6499 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6500 |
-- |
|
| 6501 |
|
|
| 6502 |
CREATE TABLE "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_" ( |
|
| 6503 |
project_name text, |
|
| 6504 |
plot_code text, |
|
| 6505 |
taxon text |
|
| 6506 |
); |
|
| 6507 |
|
|
| 6508 |
|
|
| 6509 |
-- |
|
| 6510 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6511 |
-- |
|
| 6512 |
|
|
| 6513 |
CREATE TABLE "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e" ( |
|
| 6514 |
project_name text, |
|
| 6515 |
plot_code text, |
|
| 6516 |
taxon text, |
|
| 6517 |
individuals bigint |
|
| 6518 |
); |
|
| 6519 |
|
|
| 6520 |
|
|
| 6521 |
-- |
|
| 6522 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6523 |
-- |
|
| 6524 |
|
|
| 6525 |
CREATE TABLE "~type._plots_17_count_of_subplots_per_plot_for_each_project" ( |
|
| 6526 |
project_name text, |
|
| 6527 |
plot_code text, |
|
| 6528 |
subplots bigint |
|
| 6529 |
); |
|
| 6530 |
|
|
| 6531 |
|
|
| 6532 |
-- |
|
| 6533 | 6533 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 6534 | 6534 |
-- |
| 6535 | 6535 |
|
Also available in: Unified diff
schemas/vegbien.sql: synced with DB, which reorders ~type tables