Revision 12509
Added by Aaron Marcuse-Kubitza almost 11 years ago
| 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 |
|
Also available in: Unified diff
schemas/vegbien.sql: added more ~type tables for plots queries