Revision 12647
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 329 | 329 |
|
| 330 | 330 |
|
| 331 | 331 |
-- |
| 332 |
-- Name: keys_~type._plots_16_intercepts_for_each_verb_taxon_in_each_plo; Type: TYPE; Schema: public_validations; Owner: - |
|
| 333 |
-- |
|
| 334 |
|
|
| 335 |
|
|
| 336 |
|
|
| 337 |
|
|
| 338 |
-- |
|
| 332 | 339 |
-- Name: keys_~type._plots_17_count_of_subplots_per_plot_for_each_projec; Type: TYPE; Schema: public_validations; Owner: - |
| 333 | 340 |
-- |
| 334 | 341 |
|
| ... | ... | |
| 532 | 539 |
|
| 533 | 540 |
|
| 534 | 541 |
-- |
| 542 |
-- Name: values__~type._plots_16_intercepts_for_each_verb_taxon_in_each_; Type: TYPE; Schema: public_validations; Owner: - |
|
| 543 |
-- |
|
| 544 |
|
|
| 545 |
|
|
| 546 |
|
|
| 547 |
|
|
| 548 |
-- |
|
| 535 | 549 |
-- Name: values__~type._plots_17_count_of_subplots_per_plot_for_each_pro; Type: TYPE; Schema: public_validations; Owner: - |
| 536 | 550 |
-- |
| 537 | 551 |
|
| ... | ... | |
| 1557 | 1571 |
|
| 1558 | 1572 |
|
| 1559 | 1573 |
-- |
| 1574 |
-- Name: ~type._plots_16_intercepts_for_each_verb_taxon_in_each_plot_eac; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1575 |
-- |
|
| 1576 |
|
|
| 1577 |
CREATE TABLE `~type._plots_16_intercepts_for_each_verb_taxon_in_each_plot_eac` ( |
|
| 1578 |
project_name varchar(255), |
|
| 1579 |
plot_code varchar(255), |
|
| 1580 |
taxon varchar(255), |
|
| 1581 |
intercept_cm double precision |
|
| 1582 |
); |
|
| 1583 |
|
|
| 1584 |
|
|
| 1585 |
-- |
|
| 1586 |
-- Name: keys(`~type._plots_16_intercepts_for_each_verb_taxon_in_each_plot_eac`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1587 |
-- |
|
| 1588 |
|
|
| 1589 |
|
|
| 1590 |
|
|
| 1591 |
|
|
| 1592 |
-- |
|
| 1560 | 1593 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 1561 | 1594 |
-- |
| 1562 | 1595 |
|
| ... | ... | |
| 2027 | 2060 |
|
| 2028 | 2061 |
|
| 2029 | 2062 |
-- |
| 2063 |
-- Name: values_(`~type._plots_16_intercepts_for_each_verb_taxon_in_each_plot_eac`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2064 |
-- |
|
| 2065 |
|
|
| 2066 |
|
|
| 2067 |
|
|
| 2068 |
|
|
| 2069 |
-- |
|
| 2030 | 2070 |
-- Name: values_(`~type._plots_17_count_of_subplots_per_plot_for_each_project`); Type: FUNCTION; Schema: public_validations; Owner: - |
| 2031 | 2071 |
-- |
| 2032 | 2072 |
|
| ... | ... | |
| 4884 | 4924 |
|
| 4885 | 4925 |
|
| 4886 | 4926 |
-- |
| 4927 |
-- Name: _plots_16_intercepts_for_each_verb_taxon_in_each_plot_each_proj; Type: VIEW; Schema: public_validations; Owner: - |
|
| 4928 |
-- |
|
| 4929 |
|
|
| 4930 |
|
|
| 4931 |
|
|
| 4932 |
|
|
| 4933 |
-- |
|
| 4934 |
-- Name: VIEW _plots_16_intercepts_for_each_verb_taxon_in_each_plot_each_proj; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 4935 |
-- |
|
| 4936 |
|
|
| 4937 |
|
|
| 4938 |
|
|
| 4939 |
|
|
| 4940 |
-- |
|
| 4887 | 4941 |
-- Name: _plots_17_count_of_subplots_per_plot_for_each_project; Type: VIEW; Schema: public_validations; Owner: - |
| 4888 | 4942 |
-- |
| 4889 | 4943 |
|
| ... | ... | |
| 7882 | 7936 |
|
| 7883 | 7937 |
|
| 7884 | 7938 |
-- |
| 7939 |
-- Data for Name: ~type._plots_16_intercepts_for_each_verb_taxon_in_each_plot_eac; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 7940 |
-- |
|
| 7941 |
|
|
| 7942 |
|
|
| 7943 |
|
|
| 7944 |
-- |
|
| 7885 | 7945 |
-- Data for Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 7886 | 7946 |
-- |
| 7887 | 7947 |
|
Also available in: Unified diff
schemas/vegbien.sql: implemented _plots_16_intercepts_for_each_verb_taxon_in_each_plot_each_proj