Revision 12604
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 294 | 294 |
|
| 295 | 295 |
|
| 296 | 296 |
-- |
| 297 |
-- Name: keys_~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_; Type: TYPE; Schema: public_validations; Owner: - |
|
| 298 |
-- |
|
| 299 |
|
|
| 300 |
|
|
| 301 |
|
|
| 302 |
|
|
| 303 |
-- |
|
| 297 | 304 |
-- Name: keys_~type._plots_17_count_of_subplots_per_plot_for_each_projec; Type: TYPE; Schema: public_validations; Owner: - |
| 298 | 305 |
-- |
| 299 | 306 |
|
| ... | ... | |
| 455 | 462 |
|
| 456 | 463 |
|
| 457 | 464 |
-- |
| 465 |
-- Name: values__~type._plots_15_pct_cover_of_each_verb_taxon_in_each_pl; Type: TYPE; Schema: public_validations; Owner: - |
|
| 466 |
-- |
|
| 467 |
|
|
| 468 |
|
|
| 469 |
|
|
| 470 |
|
|
| 471 |
-- |
|
| 458 | 472 |
-- Name: values__~type._plots_17_count_of_subplots_per_plot_for_each_pro; Type: TYPE; Schema: public_validations; Owner: - |
| 459 | 473 |
-- |
| 460 | 474 |
|
| ... | ... | |
| 1378 | 1392 |
|
| 1379 | 1393 |
|
| 1380 | 1394 |
-- |
| 1395 |
-- Name: ~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1396 |
-- |
|
| 1397 |
|
|
| 1398 |
CREATE TABLE `~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea` ( |
|
| 1399 |
project_name varchar(255), |
|
| 1400 |
plot_code varchar(255), |
|
| 1401 |
taxon varchar(255), |
|
| 1402 |
totalpercentcover double precision |
|
| 1403 |
); |
|
| 1404 |
|
|
| 1405 |
|
|
| 1406 |
-- |
|
| 1407 |
-- Name: keys(`~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1408 |
-- |
|
| 1409 |
|
|
| 1410 |
|
|
| 1411 |
|
|
| 1412 |
|
|
| 1413 |
-- |
|
| 1381 | 1414 |
-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 1382 | 1415 |
-- |
| 1383 | 1416 |
|
| ... | ... | |
| 1795 | 1828 |
|
| 1796 | 1829 |
|
| 1797 | 1830 |
-- |
| 1831 |
-- Name: values_(`~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1832 |
-- |
|
| 1833 |
|
|
| 1834 |
|
|
| 1835 |
|
|
| 1836 |
|
|
| 1837 |
-- |
|
| 1798 | 1838 |
-- Name: values_(`~type._plots_17_count_of_subplots_per_plot_for_each_project`); Type: FUNCTION; Schema: public_validations; Owner: - |
| 1799 | 1839 |
-- |
| 1800 | 1840 |
|
| ... | ... | |
| 7570 | 7610 |
|
| 7571 | 7611 |
|
| 7572 | 7612 |
-- |
| 7613 |
-- Data for Name: ~type._plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_ea; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 7614 |
-- |
|
| 7615 |
|
|
| 7616 |
|
|
| 7617 |
|
|
| 7618 |
-- |
|
| 7573 | 7619 |
-- Data for Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 7574 | 7620 |
-- |
| 7575 | 7621 |
|
Also available in: Unified diff
schemas/vegbien.sql: _plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_pro: added ~type table