Revision 12573
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1397 | 1397 |
|
| 1398 | 1398 |
|
| 1399 | 1399 |
|
| 1400 |
-- |
|
| 1401 |
-- Name: values_(`~type._plots_01_count_of_projects`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1402 |
-- |
|
| 1400 | 1403 |
|
| 1401 | 1404 |
|
| 1405 |
|
|
| 1406 |
|
|
| 1402 | 1407 |
-- |
| 1408 |
-- Name: values_(`~type._plots_02_list_of_project_names`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1409 |
-- |
|
| 1410 |
|
|
| 1411 |
|
|
| 1412 |
|
|
| 1413 |
|
|
| 1414 |
-- |
|
| 1415 |
-- Name: values_(`~type._plots_03_count_of_all_plots_in_this_source`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1416 |
-- |
|
| 1417 |
|
|
| 1418 |
|
|
| 1419 |
|
|
| 1420 |
|
|
| 1421 |
-- |
|
| 1422 |
-- Name: values_(`~type._plots_04_count_of_plots_in_each_project_in_this_source`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1423 |
-- |
|
| 1424 |
|
|
| 1425 |
|
|
| 1426 |
|
|
| 1427 |
|
|
| 1428 |
-- |
|
| 1429 |
-- Name: values_(`~type._plots_05_list_of_plot_codes_by_project`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1430 |
-- |
|
| 1431 |
|
|
| 1432 |
|
|
| 1433 |
|
|
| 1434 |
|
|
| 1435 |
-- |
|
| 1436 |
-- Name: values_(`~type._plots_06_list_of_plots_with_stem_measurements`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1437 |
-- |
|
| 1438 |
|
|
| 1439 |
|
|
| 1440 |
|
|
| 1441 |
|
|
| 1442 |
-- |
|
| 1443 |
-- Name: values_(`~type._plots_10_count_of_individuals_per_plot_in_each_project`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1444 |
-- |
|
| 1445 |
|
|
| 1446 |
|
|
| 1447 |
|
|
| 1448 |
|
|
| 1449 |
-- |
|
| 1450 |
-- Name: values_(`~type._plots_11_count_of_stems_per_plot_in_each_project`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1451 |
-- |
|
| 1452 |
|
|
| 1453 |
|
|
| 1454 |
|
|
| 1455 |
|
|
| 1456 |
-- |
|
| 1457 |
-- Name: values_(`~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1458 |
-- |
|
| 1459 |
|
|
| 1460 |
|
|
| 1461 |
|
|
| 1462 |
|
|
| 1463 |
-- |
|
| 1464 |
-- Name: values_(`~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1465 |
-- |
|
| 1466 |
|
|
| 1467 |
|
|
| 1468 |
|
|
| 1469 |
|
|
| 1470 |
-- |
|
| 1471 |
-- Name: values_(`~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1472 |
-- |
|
| 1473 |
|
|
| 1474 |
|
|
| 1475 |
|
|
| 1476 |
|
|
| 1477 |
-- |
|
| 1478 |
-- Name: values_(`~type._plots_17_count_of_subplots_per_plot_for_each_project`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1479 |
-- |
|
| 1480 |
|
|
| 1481 |
|
|
| 1482 |
|
|
| 1483 |
|
|
| 1484 |
-- |
|
| 1485 |
-- Name: values_(`~type._traits_02_count_trait_names`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1486 |
-- |
|
| 1487 |
|
|
| 1488 |
|
|
| 1489 |
|
|
| 1490 |
|
|
| 1491 |
-- |
|
| 1492 |
-- Name: values_(`~type._traits_03_list_trait_names`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1493 |
-- |
|
| 1494 |
|
|
| 1495 |
|
|
| 1496 |
|
|
| 1497 |
|
|
| 1498 |
-- |
|
| 1499 |
-- Name: values_(`~type._traits_04_count_records_per_trait`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1500 |
-- |
|
| 1501 |
|
|
| 1502 |
|
|
| 1503 |
|
|
| 1504 |
|
|
| 1505 |
-- |
|
| 1506 |
-- Name: values_(`~type._traits_05_count_taxa`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1507 |
-- |
|
| 1508 |
|
|
| 1509 |
|
|
| 1510 |
|
|
| 1511 |
|
|
| 1512 |
-- |
|
| 1513 |
-- Name: values_(`~type._traits_06_list_distinct_taxa`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1514 |
-- |
|
| 1515 |
|
|
| 1516 |
|
|
| 1517 |
|
|
| 1518 |
|
|
| 1519 |
-- |
|
| 1520 |
-- Name: values_(`~type._traits_07_trait_value_and_units`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1521 |
-- |
|
| 1522 |
|
|
| 1523 |
|
|
| 1524 |
|
|
| 1525 |
|
|
| 1526 |
-- |
|
| 1527 |
-- Name: values_(`~type._traits_08_taxonname_trait_and_value`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1528 |
-- |
|
| 1529 |
|
|
| 1530 |
|
|
| 1531 |
|
|
| 1532 |
|
|
| 1533 |
|
|
| 1534 |
|
|
| 1535 |
-- |
|
| 1403 | 1536 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1404 | 1537 |
-- |
| 1405 | 1538 |
|
Also available in: Unified diff
schemas/vegbien.sql: public_validations: auto-added values_() functions for all queries