Revision 12509
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 1083 | 1083 |
|
| 1084 | 1084 |
|
| 1085 | 1085 |
|
| 1086 |
-- |
|
| 1087 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1088 |
-- |
|
| 1086 | 1089 |
|
| 1090 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 1091 |
projects varchar(255) |
|
| 1092 |
); |
|
| 1087 | 1093 |
|
| 1094 |
|
|
| 1088 | 1095 |
-- |
| 1096 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1097 |
-- |
|
| 1098 |
|
|
| 1099 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 1100 |
project_name varchar(255) |
|
| 1101 |
); |
|
| 1102 |
|
|
| 1103 |
|
|
| 1104 |
-- |
|
| 1105 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1106 |
-- |
|
| 1107 |
|
|
| 1108 |
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` ( |
|
| 1109 |
plots varchar(255) |
|
| 1110 |
); |
|
| 1111 |
|
|
| 1112 |
|
|
| 1113 |
-- |
|
| 1114 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1115 |
-- |
|
| 1116 |
|
|
| 1117 |
CREATE TABLE `~type._plots_10_count_of_individuals_per_plot_in_each_project` ( |
|
| 1118 |
project_name varchar(255), |
|
| 1119 |
plotcode varchar(255), |
|
| 1120 |
individuals varchar(255) |
|
| 1121 |
); |
|
| 1122 |
|
|
| 1123 |
|
|
| 1124 |
-- |
|
| 1125 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1126 |
-- |
|
| 1127 |
|
|
| 1128 |
CREATE TABLE `~type._plots_11_count_of_stems_per_plot_in_each_project` ( |
|
| 1129 |
project_name varchar(255), |
|
| 1130 |
plotcode varchar(255), |
|
| 1131 |
stems varchar(255) |
|
| 1132 |
); |
|
| 1133 |
|
|
| 1134 |
|
|
| 1135 |
-- |
|
| 1136 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1137 |
-- |
|
| 1138 |
|
|
| 1139 |
CREATE TABLE `~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project` ( |
|
| 1140 |
project_name varchar(255), |
|
| 1141 |
plotcode varchar(255), |
|
| 1142 |
taxa varchar(255) |
|
| 1143 |
); |
|
| 1144 |
|
|
| 1145 |
|
|
| 1146 |
-- |
|
| 1147 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1148 |
-- |
|
| 1149 |
|
|
| 1150 |
CREATE TABLE `~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_` ( |
|
| 1151 |
project_name varchar(255), |
|
| 1152 |
plotcode varchar(255), |
|
| 1153 |
taxon varchar(255) |
|
| 1154 |
); |
|
| 1155 |
|
|
| 1156 |
|
|
| 1157 |
-- |
|
| 1158 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1159 |
-- |
|
| 1160 |
|
|
| 1161 |
CREATE TABLE `~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e` ( |
|
| 1162 |
project_name varchar(255), |
|
| 1163 |
plotcode varchar(255), |
|
| 1164 |
taxon varchar(255), |
|
| 1165 |
individuals varchar(255) |
|
| 1166 |
); |
|
| 1167 |
|
|
| 1168 |
|
|
| 1169 |
-- |
|
| 1170 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1171 |
-- |
|
| 1172 |
|
|
| 1173 |
CREATE TABLE `~type._plots_17_count_of_subplots_per_plot_for_each_project` ( |
|
| 1174 |
project_name varchar(255), |
|
| 1175 |
plotcode varchar(255), |
|
| 1176 |
subplots varchar(255) |
|
| 1177 |
); |
|
| 1178 |
|
|
| 1179 |
|
|
| 1180 |
|
|
| 1181 |
|
|
| 1182 |
-- |
|
| 1089 | 1183 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1090 | 1184 |
-- |
| 1091 | 1185 |
|
| ... | ... | |
| 3897 | 3991 |
|
| 3898 | 3992 |
|
| 3899 | 3993 |
-- |
| 3900 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3901 |
-- |
|
| 3902 |
|
|
| 3903 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 3904 |
projects varchar(255) |
|
| 3905 |
); |
|
| 3906 |
|
|
| 3907 |
|
|
| 3908 |
-- |
|
| 3909 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3910 |
-- |
|
| 3911 |
|
|
| 3912 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 3913 |
project_name varchar(255) |
|
| 3914 |
); |
|
| 3915 |
|
|
| 3916 |
|
|
| 3917 |
-- |
|
| 3918 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3919 |
-- |
|
| 3920 |
|
|
| 3921 |
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` ( |
|
| 3922 |
plots varchar(255) |
|
| 3923 |
); |
|
| 3924 |
|
|
| 3925 |
|
|
| 3926 |
-- |
|
| 3927 | 3994 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3928 | 3995 |
-- |
| 3929 | 3996 |
|
| ... | ... | |
| 6813 | 6880 |
|
| 6814 | 6881 |
|
| 6815 | 6882 |
-- |
| 6883 |
-- Data for Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6884 |
-- |
|
| 6885 |
|
|
| 6886 |
|
|
| 6887 |
|
|
| 6888 |
-- |
|
| 6889 |
-- Data for Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6890 |
-- |
|
| 6891 |
|
|
| 6892 |
|
|
| 6893 |
|
|
| 6894 |
-- |
|
| 6895 |
-- Data for Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6896 |
-- |
|
| 6897 |
|
|
| 6898 |
|
|
| 6899 |
|
|
| 6900 |
-- |
|
| 6901 |
-- Data for Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6902 |
-- |
|
| 6903 |
|
|
| 6904 |
|
|
| 6905 |
|
|
| 6906 |
-- |
|
| 6907 |
-- Data for Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6908 |
-- |
|
| 6909 |
|
|
| 6910 |
|
|
| 6911 |
|
|
| 6912 |
-- |
|
| 6913 |
-- Data for Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6914 |
-- |
|
| 6915 |
|
|
| 6916 |
|
|
| 6917 |
|
|
| 6918 |
-- |
|
| 6816 | 6919 |
-- Data for Name: ~type._traits_01_count_records; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 6817 | 6920 |
-- |
| 6818 | 6921 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 2470 | 2470 |
$_$; |
| 2471 | 2471 |
|
| 2472 | 2472 |
|
| 2473 |
-- |
|
| 2474 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2475 |
-- |
|
| 2476 |
|
|
| 2477 |
CREATE TABLE "~type._plots_01_count_of_projects" ( |
|
| 2478 |
projects bigint |
|
| 2479 |
); |
|
| 2480 |
|
|
| 2481 |
|
|
| 2482 |
-- |
|
| 2483 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2484 |
-- |
|
| 2485 |
|
|
| 2486 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
| 2487 |
project_name text |
|
| 2488 |
); |
|
| 2489 |
|
|
| 2490 |
|
|
| 2491 |
-- |
|
| 2492 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2493 |
-- |
|
| 2494 |
|
|
| 2495 |
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" ( |
|
| 2496 |
plots bigint |
|
| 2497 |
); |
|
| 2498 |
|
|
| 2499 |
|
|
| 2500 |
-- |
|
| 2501 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2502 |
-- |
|
| 2503 |
|
|
| 2504 |
CREATE TABLE "~type._plots_10_count_of_individuals_per_plot_in_each_project" ( |
|
| 2505 |
project_name text, |
|
| 2506 |
plotcode text, |
|
| 2507 |
individuals bigint |
|
| 2508 |
); |
|
| 2509 |
|
|
| 2510 |
|
|
| 2511 |
-- |
|
| 2512 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2513 |
-- |
|
| 2514 |
|
|
| 2515 |
CREATE TABLE "~type._plots_11_count_of_stems_per_plot_in_each_project" ( |
|
| 2516 |
project_name text, |
|
| 2517 |
plotcode text, |
|
| 2518 |
stems bigint |
|
| 2519 |
); |
|
| 2520 |
|
|
| 2521 |
|
|
| 2522 |
-- |
|
| 2523 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2524 |
-- |
|
| 2525 |
|
|
| 2526 |
CREATE TABLE "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project" ( |
|
| 2527 |
project_name text, |
|
| 2528 |
plotcode text, |
|
| 2529 |
taxa bigint |
|
| 2530 |
); |
|
| 2531 |
|
|
| 2532 |
|
|
| 2533 |
-- |
|
| 2534 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2535 |
-- |
|
| 2536 |
|
|
| 2537 |
CREATE TABLE "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_" ( |
|
| 2538 |
project_name text, |
|
| 2539 |
plotcode text, |
|
| 2540 |
taxon text |
|
| 2541 |
); |
|
| 2542 |
|
|
| 2543 |
|
|
| 2544 |
-- |
|
| 2545 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2546 |
-- |
|
| 2547 |
|
|
| 2548 |
CREATE TABLE "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e" ( |
|
| 2549 |
project_name text, |
|
| 2550 |
plotcode text, |
|
| 2551 |
taxon text, |
|
| 2552 |
individuals bigint |
|
| 2553 |
); |
|
| 2554 |
|
|
| 2555 |
|
|
| 2556 |
-- |
|
| 2557 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2558 |
-- |
|
| 2559 |
|
|
| 2560 |
CREATE TABLE "~type._plots_17_count_of_subplots_per_plot_for_each_project" ( |
|
| 2561 |
project_name text, |
|
| 2562 |
plotcode text, |
|
| 2563 |
subplots bigint |
|
| 2564 |
); |
|
| 2565 |
|
|
| 2566 |
|
|
| 2473 | 2567 |
SET search_path = public, pg_catalog; |
| 2474 | 2568 |
|
| 2475 | 2569 |
-- |
| ... | ... | |
| 6385 | 6479 |
|
| 6386 | 6480 |
|
| 6387 | 6481 |
-- |
| 6388 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6389 |
-- |
|
| 6390 |
|
|
| 6391 |
CREATE TABLE "~type._plots_01_count_of_projects" ( |
|
| 6392 |
projects bigint |
|
| 6393 |
); |
|
| 6394 |
|
|
| 6395 |
|
|
| 6396 |
-- |
|
| 6397 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6398 |
-- |
|
| 6399 |
|
|
| 6400 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
| 6401 |
project_name text |
|
| 6402 |
); |
|
| 6403 |
|
|
| 6404 |
|
|
| 6405 |
-- |
|
| 6406 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6407 |
-- |
|
| 6408 |
|
|
| 6409 |
CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" ( |
|
| 6410 |
plots bigint |
|
| 6411 |
); |
|
| 6412 |
|
|
| 6413 |
|
|
| 6414 |
-- |
|
| 6415 | 6482 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 6416 | 6483 |
-- |
| 6417 | 6484 |
|
| ... | ... | |
| 9301 | 9368 |
|
| 9302 | 9369 |
|
| 9303 | 9370 |
-- |
| 9371 |
-- Data for Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9372 |
-- |
|
| 9373 |
|
|
| 9374 |
|
|
| 9375 |
|
|
| 9376 |
-- |
|
| 9377 |
-- Data for Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9378 |
-- |
|
| 9379 |
|
|
| 9380 |
|
|
| 9381 |
|
|
| 9382 |
-- |
|
| 9383 |
-- Data for Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9384 |
-- |
|
| 9385 |
|
|
| 9386 |
|
|
| 9387 |
|
|
| 9388 |
-- |
|
| 9389 |
-- Data for Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9390 |
-- |
|
| 9391 |
|
|
| 9392 |
|
|
| 9393 |
|
|
| 9394 |
-- |
|
| 9395 |
-- Data for Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9396 |
-- |
|
| 9397 |
|
|
| 9398 |
|
|
| 9399 |
|
|
| 9400 |
-- |
|
| 9401 |
-- Data for Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9402 |
-- |
|
| 9403 |
|
|
| 9404 |
|
|
| 9405 |
|
|
| 9406 |
-- |
|
| 9304 | 9407 |
-- Data for Name: ~type._traits_01_count_records; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 9305 | 9408 |
-- |
| 9306 | 9409 |
|
Also available in: Unified diff
schemas/vegbien.sql: added more ~type tables for plots queries