Revision 12527
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 875 | 875 |
|
| 876 | 876 |
|
| 877 | 877 |
-- |
| 878 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 879 |
-- |
|
| 880 |
|
|
| 881 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 882 |
project_name varchar(255), |
|
| 883 |
plots varchar(255) |
|
| 884 |
); |
|
| 885 |
|
|
| 886 |
|
|
| 887 |
-- |
|
| 888 |
-- Name: keys(`~type._plots_04_count_of_plots_in_each_project_in_this_source`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 889 |
-- |
|
| 890 |
|
|
| 891 |
|
|
| 892 |
|
|
| 893 |
|
|
| 894 |
-- |
|
| 895 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 896 |
-- |
|
| 897 |
|
|
| 898 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 899 |
trait varchar(255), |
|
| 900 |
measurements varchar(255) |
|
| 901 |
); |
|
| 902 |
|
|
| 903 |
|
|
| 904 |
-- |
|
| 905 |
-- Name: keys(`~type._traits_04_count_records_per_trait`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 906 |
-- |
|
| 907 |
|
|
| 908 |
|
|
| 909 |
|
|
| 910 |
|
|
| 911 |
-- |
|
| 912 | 878 |
-- Name: query_view_relation_max_prefix_len(); Type: FUNCTION; Schema: public_validations; Owner: - |
| 913 | 879 |
-- |
| 914 | 880 |
|
| ... | ... | |
| 1090 | 1056 |
|
| 1091 | 1057 |
|
| 1092 | 1058 |
|
| 1059 |
-- |
|
| 1060 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1061 |
-- |
|
| 1093 | 1062 |
|
| 1063 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 1064 |
projects varchar(255) |
|
| 1065 |
); |
|
| 1094 | 1066 |
|
| 1067 |
|
|
| 1095 | 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_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 |
|
|
| 1165 |
-- |
|
| 1096 | 1166 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1097 | 1167 |
-- |
| 1098 | 1168 |
|
| ... | ... | |
| 3903 | 3973 |
|
| 3904 | 3974 |
|
| 3905 | 3975 |
|
| 3906 |
-- |
|
| 3907 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3908 |
-- |
|
| 3909 | 3976 |
|
| 3910 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 3911 |
projects varchar(255) |
|
| 3912 |
); |
|
| 3913 | 3977 |
|
| 3914 |
|
|
| 3915 | 3978 |
-- |
| 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_06_list_of_plots_with_stem_measurements; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3935 |
-- |
|
| 3936 |
|
|
| 3937 |
CREATE TABLE `~type._plots_06_list_of_plots_with_stem_measurements` ( |
|
| 3938 |
project_name varchar(255), |
|
| 3939 |
`SiteCode` varchar(255) |
|
| 3940 |
); |
|
| 3941 |
|
|
| 3942 |
|
|
| 3943 |
-- |
|
| 3944 |
-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3945 |
-- |
|
| 3946 |
|
|
| 3947 |
CREATE TABLE `~type._plots_10_count_of_individuals_per_plot_in_each_project` ( |
|
| 3948 |
project_name varchar(255), |
|
| 3949 |
plotcode varchar(255), |
|
| 3950 |
individuals varchar(255) |
|
| 3951 |
); |
|
| 3952 |
|
|
| 3953 |
|
|
| 3954 |
-- |
|
| 3955 |
-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3956 |
-- |
|
| 3957 |
|
|
| 3958 |
CREATE TABLE `~type._plots_11_count_of_stems_per_plot_in_each_project` ( |
|
| 3959 |
project_name varchar(255), |
|
| 3960 |
plotcode varchar(255), |
|
| 3961 |
stems varchar(255) |
|
| 3962 |
); |
|
| 3963 |
|
|
| 3964 |
|
|
| 3965 |
-- |
|
| 3966 |
-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3967 |
-- |
|
| 3968 |
|
|
| 3969 |
CREATE TABLE `~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project` ( |
|
| 3970 |
project_name varchar(255), |
|
| 3971 |
plotcode varchar(255), |
|
| 3972 |
taxa varchar(255) |
|
| 3973 |
); |
|
| 3974 |
|
|
| 3975 |
|
|
| 3976 |
-- |
|
| 3977 |
-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3978 |
-- |
|
| 3979 |
|
|
| 3980 |
CREATE TABLE `~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_` ( |
|
| 3981 |
project_name varchar(255), |
|
| 3982 |
plotcode varchar(255), |
|
| 3983 |
taxon varchar(255) |
|
| 3984 |
); |
|
| 3985 |
|
|
| 3986 |
|
|
| 3987 |
-- |
|
| 3988 |
-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3989 |
-- |
|
| 3990 |
|
|
| 3991 |
CREATE TABLE `~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e` ( |
|
| 3992 |
project_name varchar(255), |
|
| 3993 |
plotcode varchar(255), |
|
| 3994 |
taxon varchar(255), |
|
| 3995 |
individuals varchar(255) |
|
| 3996 |
); |
|
| 3997 |
|
|
| 3998 |
|
|
| 3999 |
-- |
|
| 4000 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4001 |
-- |
|
| 4002 |
|
|
| 4003 |
CREATE TABLE `~type._plots_17_count_of_subplots_per_plot_for_each_project` ( |
|
| 4004 |
project_name varchar(255), |
|
| 4005 |
plotcode varchar(255), |
|
| 4006 |
subplots varchar(255) |
|
| 4007 |
); |
|
| 4008 |
|
|
| 4009 |
|
|
| 4010 |
-- |
|
| 4011 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4012 |
-- |
|
| 4013 |
|
|
| 4014 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 4015 |
`totalRecords` varchar(255) |
|
| 4016 |
); |
|
| 4017 |
|
|
| 4018 |
|
|
| 4019 |
-- |
|
| 4020 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4021 |
-- |
|
| 4022 |
|
|
| 4023 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 4024 |
traits varchar(255) |
|
| 4025 |
); |
|
| 4026 |
|
|
| 4027 |
|
|
| 4028 |
-- |
|
| 4029 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4030 |
-- |
|
| 4031 |
|
|
| 4032 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 4033 |
trait varchar(255) |
|
| 4034 |
); |
|
| 4035 |
|
|
| 4036 |
|
|
| 4037 |
-- |
|
| 4038 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4039 |
-- |
|
| 4040 |
|
|
| 4041 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 4042 |
taxa varchar(255) |
|
| 4043 |
); |
|
| 4044 |
|
|
| 4045 |
|
|
| 4046 |
-- |
|
| 4047 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4048 |
-- |
|
| 4049 |
|
|
| 4050 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 4051 |
taxonwithauthor varchar(255) |
|
| 4052 |
); |
|
| 4053 |
|
|
| 4054 |
|
|
| 4055 |
-- |
|
| 4056 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4057 |
-- |
|
| 4058 |
|
|
| 4059 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 4060 |
trait varchar(255), |
|
| 4061 |
value varchar(255), |
|
| 4062 |
units varchar(255) |
|
| 4063 |
); |
|
| 4064 |
|
|
| 4065 |
|
|
| 4066 |
-- |
|
| 4067 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 4068 |
-- |
|
| 4069 |
|
|
| 4070 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 4071 |
taxonwithauthor varchar(255), |
|
| 4072 |
trait varchar(255), |
|
| 4073 |
value varchar(255) |
|
| 4074 |
); |
|
| 4075 |
|
|
| 4076 |
|
|
| 4077 |
|
|
| 4078 |
|
|
| 4079 |
-- |
|
| 4080 | 3979 |
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: - |
| 4081 | 3980 |
-- |
| 4082 | 3981 |
|
| ... | ... | |
| 6897 | 6796 |
|
| 6898 | 6797 |
|
| 6899 | 6798 |
-- |
| 6900 |
-- Data for Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6901 |
-- |
|
| 6902 |
|
|
| 6903 |
|
|
| 6904 |
|
|
| 6905 |
-- |
|
| 6906 | 6799 |
-- Data for Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 6907 | 6800 |
-- |
| 6908 | 6801 |
|
| ... | ... | |
| 6938 | 6831 |
|
| 6939 | 6832 |
|
| 6940 | 6833 |
|
| 6941 |
-- |
|
| 6942 |
-- Data for Name: ~type._traits_01_count_records; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6943 |
-- |
|
| 6944 | 6834 |
|
| 6945 | 6835 |
|
| 6946 |
|
|
| 6947 | 6836 |
-- |
| 6948 |
-- Data for Name: ~type._traits_02_count_trait_names; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6949 |
-- |
|
| 6950 |
|
|
| 6951 |
|
|
| 6952 |
|
|
| 6953 |
-- |
|
| 6954 |
-- Data for Name: ~type._traits_03_list_trait_names; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6955 |
-- |
|
| 6956 |
|
|
| 6957 |
|
|
| 6958 |
|
|
| 6959 |
-- |
|
| 6960 |
-- Data for Name: ~type._traits_04_count_records_per_trait; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6961 |
-- |
|
| 6962 |
|
|
| 6963 |
|
|
| 6964 |
|
|
| 6965 |
-- |
|
| 6966 |
-- Data for Name: ~type._traits_05_count_taxa; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6967 |
-- |
|
| 6968 |
|
|
| 6969 |
|
|
| 6970 |
|
|
| 6971 |
-- |
|
| 6972 |
-- Data for Name: ~type._traits_06_list_distinct_taxa; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6973 |
-- |
|
| 6974 |
|
|
| 6975 |
|
|
| 6976 |
|
|
| 6977 |
-- |
|
| 6978 |
-- Data for Name: ~type._traits_07_trait_value_and_units; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6979 |
-- |
|
| 6980 |
|
|
| 6981 |
|
|
| 6982 |
|
|
| 6983 |
-- |
|
| 6984 |
-- Data for Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6985 |
-- |
|
| 6986 |
|
|
| 6987 |
|
|
| 6988 |
|
|
| 6989 |
|
|
| 6990 |
|
|
| 6991 |
-- |
|
| 6992 | 6837 |
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 6993 | 6838 |
-- |
| 6994 | 6839 |
|
Also available in: Unified diff
fix: schemas/vegbien.sql: plots* validation queries: renamed plot_code columns (with names plotcode, plotCode, SiteCode) to match the input queries (plot_code)