Revision 12550
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 |
-- |
|
| 1059 | 1062 |
|
| 1063 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 1064 |
projects varchar(255) |
|
| 1065 |
); |
|
| 1060 | 1066 |
|
| 1067 |
|
|
| 1061 | 1068 |
-- |
| 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_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1098 |
-- |
|
| 1099 |
|
|
| 1100 |
CREATE TABLE `~type._plots_05_list_of_plot_codes_by_project` ( |
|
| 1101 |
project_name varchar(255), |
|
| 1102 |
plot_code varchar(255) |
|
| 1103 |
); |
|
| 1104 |
|
|
| 1105 |
|
|
| 1106 |
-- |
|
| 1107 |
-- Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1108 |
-- |
|
| 1109 |
|
|
| 1110 |
CREATE TABLE `~type._plots_06_list_of_plots_with_stem_measurements` ( |
|
| 1111 |
project_name varchar(255), |
|
| 1112 |
plot_code varchar(255) |
|
| 1113 |
); |
|
| 1114 |
|
|
| 1115 |
|
|
| 1116 |
-- |
|
| 1117 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1118 |
-- |
|
| 1119 |
|
|
| 1120 |
CREATE TABLE `~type._plots_10_count_of_individuals_per_plot_in_each_project` ( |
|
| 1121 |
project_name varchar(255), |
|
| 1122 |
plot_code varchar(255), |
|
| 1123 |
individuals varchar(255) |
|
| 1124 |
); |
|
| 1125 |
|
|
| 1126 |
|
|
| 1127 |
-- |
|
| 1128 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1129 |
-- |
|
| 1130 |
|
|
| 1131 |
CREATE TABLE `~type._plots_11_count_of_stems_per_plot_in_each_project` ( |
|
| 1132 |
project_name varchar(255), |
|
| 1133 |
plot_code varchar(255), |
|
| 1134 |
stems varchar(255) |
|
| 1135 |
); |
|
| 1136 |
|
|
| 1137 |
|
|
| 1138 |
-- |
|
| 1139 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1140 |
-- |
|
| 1141 |
|
|
| 1142 |
CREATE TABLE `~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project` ( |
|
| 1143 |
project_name varchar(255), |
|
| 1144 |
plot_code varchar(255), |
|
| 1145 |
taxa varchar(255) |
|
| 1146 |
); |
|
| 1147 |
|
|
| 1148 |
|
|
| 1149 |
-- |
|
| 1150 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1151 |
-- |
|
| 1152 |
|
|
| 1153 |
CREATE TABLE `~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_` ( |
|
| 1154 |
project_name varchar(255), |
|
| 1155 |
plot_code varchar(255), |
|
| 1156 |
taxon varchar(255) |
|
| 1157 |
); |
|
| 1158 |
|
|
| 1159 |
|
|
| 1160 |
-- |
|
| 1161 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1162 |
-- |
|
| 1163 |
|
|
| 1164 |
CREATE TABLE `~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e` ( |
|
| 1165 |
project_name varchar(255), |
|
| 1166 |
plot_code varchar(255), |
|
| 1167 |
taxon varchar(255), |
|
| 1168 |
individuals varchar(255) |
|
| 1169 |
); |
|
| 1170 |
|
|
| 1171 |
|
|
| 1172 |
-- |
|
| 1173 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1174 |
-- |
|
| 1175 |
|
|
| 1176 |
CREATE TABLE `~type._plots_17_count_of_subplots_per_plot_for_each_project` ( |
|
| 1177 |
project_name varchar(255), |
|
| 1178 |
plot_code varchar(255), |
|
| 1179 |
subplots varchar(255) |
|
| 1180 |
); |
|
| 1181 |
|
|
| 1182 |
|
|
| 1183 |
|
|
| 1184 |
|
|
| 1185 |
-- |
|
| 1062 | 1186 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1063 | 1187 |
-- |
| 1064 | 1188 |
|
| ... | ... | |
| 3870 | 3994 |
|
| 3871 | 3995 |
|
| 3872 | 3996 |
-- |
| 3873 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3874 |
-- |
|
| 3875 |
|
|
| 3876 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 3877 |
projects varchar(255) |
|
| 3878 |
); |
|
| 3879 |
|
|
| 3880 |
|
|
| 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 | 3997 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3978 | 3998 |
-- |
| 3979 | 3999 |
|
| ... | ... | |
| 6873 | 6893 |
|
| 6874 | 6894 |
|
| 6875 | 6895 |
-- |
| 6896 |
-- Data for Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6897 |
-- |
|
| 6898 |
|
|
| 6899 |
|
|
| 6900 |
|
|
| 6901 |
-- |
|
| 6902 |
-- Data for Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6903 |
-- |
|
| 6904 |
|
|
| 6905 |
|
|
| 6906 |
|
|
| 6907 |
-- |
|
| 6876 | 6908 |
-- Data for Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 6877 | 6909 |
-- |
| 6878 | 6910 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 2455 | 2455 |
$_$; |
| 2456 | 2456 |
|
| 2457 | 2457 |
|
| 2458 |
-- |
|
| 2459 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2460 |
-- |
|
| 2461 |
|
|
| 2462 |
CREATE TABLE "~type._plots_01_count_of_projects" ( |
|
| 2463 |
projects bigint |
|
| 2464 |
); |
|
| 2465 |
|
|
| 2466 |
|
|
| 2467 |
-- |
|
| 2468 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2469 |
-- |
|
| 2470 |
|
|
| 2471 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
| 2472 |
project_name text |
|
| 2473 |
); |
|
| 2474 |
|
|
| 2475 |
|
|
| 2476 |
-- |
|
| 2477 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2478 |
-- |
|
| 2479 |
|
|
| 2480 |
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" ( |
|
| 2481 |
plots bigint |
|
| 2482 |
); |
|
| 2483 |
|
|
| 2484 |
|
|
| 2485 |
-- |
|
| 2486 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2487 |
-- |
|
| 2488 |
|
|
| 2489 |
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" ( |
|
| 2490 |
project_name text, |
|
| 2491 |
plots bigint |
|
| 2492 |
); |
|
| 2493 |
|
|
| 2494 |
|
|
| 2495 |
-- |
|
| 2496 |
-- Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2497 |
-- |
|
| 2498 |
|
|
| 2499 |
CREATE TABLE "~type._plots_05_list_of_plot_codes_by_project" ( |
|
| 2500 |
project_name text, |
|
| 2501 |
plot_code text |
|
| 2502 |
); |
|
| 2503 |
|
|
| 2504 |
|
|
| 2505 |
-- |
|
| 2506 |
-- Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2507 |
-- |
|
| 2508 |
|
|
| 2509 |
CREATE TABLE "~type._plots_06_list_of_plots_with_stem_measurements" ( |
|
| 2510 |
project_name text, |
|
| 2511 |
plot_code text |
|
| 2512 |
); |
|
| 2513 |
|
|
| 2514 |
|
|
| 2515 |
-- |
|
| 2516 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2517 |
-- |
|
| 2518 |
|
|
| 2519 |
CREATE TABLE "~type._plots_10_count_of_individuals_per_plot_in_each_project" ( |
|
| 2520 |
project_name text, |
|
| 2521 |
plot_code text, |
|
| 2522 |
individuals bigint |
|
| 2523 |
); |
|
| 2524 |
|
|
| 2525 |
|
|
| 2526 |
-- |
|
| 2527 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2528 |
-- |
|
| 2529 |
|
|
| 2530 |
CREATE TABLE "~type._plots_11_count_of_stems_per_plot_in_each_project" ( |
|
| 2531 |
project_name text, |
|
| 2532 |
plot_code text, |
|
| 2533 |
stems bigint |
|
| 2534 |
); |
|
| 2535 |
|
|
| 2536 |
|
|
| 2537 |
-- |
|
| 2538 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2539 |
-- |
|
| 2540 |
|
|
| 2541 |
CREATE TABLE "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project" ( |
|
| 2542 |
project_name text, |
|
| 2543 |
plot_code text, |
|
| 2544 |
taxa bigint |
|
| 2545 |
); |
|
| 2546 |
|
|
| 2547 |
|
|
| 2548 |
-- |
|
| 2549 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2550 |
-- |
|
| 2551 |
|
|
| 2552 |
CREATE TABLE "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_" ( |
|
| 2553 |
project_name text, |
|
| 2554 |
plot_code text, |
|
| 2555 |
taxon text |
|
| 2556 |
); |
|
| 2557 |
|
|
| 2558 |
|
|
| 2559 |
-- |
|
| 2560 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2561 |
-- |
|
| 2562 |
|
|
| 2563 |
CREATE TABLE "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e" ( |
|
| 2564 |
project_name text, |
|
| 2565 |
plot_code text, |
|
| 2566 |
taxon text, |
|
| 2567 |
individuals bigint |
|
| 2568 |
); |
|
| 2569 |
|
|
| 2570 |
|
|
| 2571 |
-- |
|
| 2572 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2573 |
-- |
|
| 2574 |
|
|
| 2575 |
CREATE TABLE "~type._plots_17_count_of_subplots_per_plot_for_each_project" ( |
|
| 2576 |
project_name text, |
|
| 2577 |
plot_code text, |
|
| 2578 |
subplots bigint |
|
| 2579 |
); |
|
| 2580 |
|
|
| 2581 |
|
|
| 2458 | 2582 |
SET search_path = public, pg_catalog; |
| 2459 | 2583 |
|
| 2460 | 2584 |
-- |
| ... | ... | |
| 6373 | 6497 |
|
| 6374 | 6498 |
|
| 6375 | 6499 |
-- |
| 6376 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6377 |
-- |
|
| 6378 |
|
|
| 6379 |
CREATE TABLE "~type._plots_01_count_of_projects" ( |
|
| 6380 |
projects bigint |
|
| 6381 |
); |
|
| 6382 |
|
|
| 6383 |
|
|
| 6384 |
-- |
|
| 6385 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6386 |
-- |
|
| 6387 |
|
|
| 6388 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
| 6389 |
project_name text |
|
| 6390 |
); |
|
| 6391 |
|
|
| 6392 |
|
|
| 6393 |
-- |
|
| 6394 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6395 |
-- |
|
| 6396 |
|
|
| 6397 |
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" ( |
|
| 6398 |
plots bigint |
|
| 6399 |
); |
|
| 6400 |
|
|
| 6401 |
|
|
| 6402 |
-- |
|
| 6403 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6404 |
-- |
|
| 6405 |
|
|
| 6406 |
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" ( |
|
| 6407 |
project_name text, |
|
| 6408 |
plots bigint |
|
| 6409 |
); |
|
| 6410 |
|
|
| 6411 |
|
|
| 6412 |
-- |
|
| 6413 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6414 |
-- |
|
| 6415 |
|
|
| 6416 |
CREATE TABLE "~type._plots_10_count_of_individuals_per_plot_in_each_project" ( |
|
| 6417 |
project_name text, |
|
| 6418 |
plot_code text, |
|
| 6419 |
individuals bigint |
|
| 6420 |
); |
|
| 6421 |
|
|
| 6422 |
|
|
| 6423 |
-- |
|
| 6424 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6425 |
-- |
|
| 6426 |
|
|
| 6427 |
CREATE TABLE "~type._plots_11_count_of_stems_per_plot_in_each_project" ( |
|
| 6428 |
project_name text, |
|
| 6429 |
plot_code text, |
|
| 6430 |
stems bigint |
|
| 6431 |
); |
|
| 6432 |
|
|
| 6433 |
|
|
| 6434 |
-- |
|
| 6435 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6436 |
-- |
|
| 6437 |
|
|
| 6438 |
CREATE TABLE "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project" ( |
|
| 6439 |
project_name text, |
|
| 6440 |
plot_code text, |
|
| 6441 |
taxa bigint |
|
| 6442 |
); |
|
| 6443 |
|
|
| 6444 |
|
|
| 6445 |
-- |
|
| 6446 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6447 |
-- |
|
| 6448 |
|
|
| 6449 |
CREATE TABLE "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_" ( |
|
| 6450 |
project_name text, |
|
| 6451 |
plot_code text, |
|
| 6452 |
taxon text |
|
| 6453 |
); |
|
| 6454 |
|
|
| 6455 |
|
|
| 6456 |
-- |
|
| 6457 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6458 |
-- |
|
| 6459 |
|
|
| 6460 |
CREATE TABLE "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e" ( |
|
| 6461 |
project_name text, |
|
| 6462 |
plot_code text, |
|
| 6463 |
taxon text, |
|
| 6464 |
individuals bigint |
|
| 6465 |
); |
|
| 6466 |
|
|
| 6467 |
|
|
| 6468 |
-- |
|
| 6469 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6470 |
-- |
|
| 6471 |
|
|
| 6472 |
CREATE TABLE "~type._plots_17_count_of_subplots_per_plot_for_each_project" ( |
|
| 6473 |
project_name text, |
|
| 6474 |
plot_code text, |
|
| 6475 |
subplots bigint |
|
| 6476 |
); |
|
| 6477 |
|
|
| 6478 |
|
|
| 6479 |
-- |
|
| 6480 | 6500 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 6481 | 6501 |
-- |
| 6482 | 6502 |
|
| ... | ... | |
| 9376 | 9396 |
|
| 9377 | 9397 |
|
| 9378 | 9398 |
-- |
| 9399 |
-- Data for Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9400 |
-- |
|
| 9401 |
|
|
| 9402 |
|
|
| 9403 |
|
|
| 9404 |
-- |
|
| 9405 |
-- Data for Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9406 |
-- |
|
| 9407 |
|
|
| 9408 |
|
|
| 9409 |
|
|
| 9410 |
-- |
|
| 9379 | 9411 |
-- Data for Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 9380 | 9412 |
-- |
| 9381 | 9413 |
|
Also available in: Unified diff
schemas/vegbien.sql: added new ~type tables