Revision 14943
Added by Aaron Marcuse-Kubitza over 9 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4450 | 4450 |
|
| 4451 | 4451 |
|
| 4452 | 4452 |
-- |
| 4453 |
-- Name: 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private; Type: VIEW; Schema: public; Owner: - |
|
| 4454 |
-- |
|
| 4455 |
|
|
| 4456 |
|
|
| 4457 |
|
|
| 4458 |
|
|
| 4459 |
-- |
|
| 4453 | 4460 |
-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: - |
| 4454 | 4461 |
-- |
| 4455 | 4462 |
|
| ... | ... | |
| 5901 | 5908 |
|
| 5902 | 5909 |
|
| 5903 | 5910 |
-- |
| 5904 |
-- Name: iucn_red_list_view; Type: VIEW; Schema: public; Owner: - |
|
| 5905 |
-- |
|
| 5906 |
|
|
| 5907 |
|
|
| 5908 |
|
|
| 5909 |
|
|
| 5910 |
-- |
|
| 5911 |
-- Name: VIEW iucn_red_list_view; Type: COMMENT; Schema: public; Owner: - |
|
| 5912 |
-- |
|
| 5913 |
|
|
| 5914 |
|
|
| 5915 |
|
|
| 5916 |
|
|
| 5917 |
-- |
|
| 5918 | 5911 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 5919 | 5912 |
-- |
| 5920 | 5913 |
|
| ... | ... | |
| 7417 | 7410 |
|
| 7418 | 7411 |
|
| 7419 | 7412 |
-- |
| 7420 |
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 7421 |
-- |
|
| 7422 |
|
|
| 7423 |
CREATE TABLE taxondetermination ( |
|
| 7424 |
taxondetermination_id int(11) NOT NULL, |
|
| 7425 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 7426 |
source_id int(11) NOT NULL, |
|
| 7427 |
taxonverbatim_id int(11) NOT NULL, |
|
| 7428 |
party_id int(11), |
|
| 7429 |
role varchar(255) DEFAULT 'unknown' NOT NULL, |
|
| 7430 |
determinationtype varchar(255), |
|
| 7431 |
reference_id int(11), |
|
| 7432 |
isoriginal int(1), |
|
| 7433 |
iscurrent__verbatim int(1), |
|
| 7434 |
iscurrent int(1) DEFAULT false NOT NULL, |
|
| 7435 |
taxonfit varchar(255), |
|
| 7436 |
taxonconfidence varchar(255), |
|
| 7437 |
grouptype varchar(255), |
|
| 7438 |
notes varchar(255), |
|
| 7439 |
revisions int(1), |
|
| 7440 |
determinationdate date |
|
| 7441 |
); |
|
| 7442 |
|
|
| 7443 |
|
|
| 7444 |
-- |
|
| 7445 |
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: - |
|
| 7446 |
-- |
|
| 7447 |
|
|
| 7448 |
|
|
| 7449 |
|
|
| 7450 |
|
|
| 7451 |
-- |
|
| 7452 |
-- Name: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 7453 |
-- |
|
| 7454 |
|
|
| 7455 |
CREATE TABLE taxonverbatim ( |
|
| 7456 |
taxonverbatim_id int(11) NOT NULL, |
|
| 7457 |
source_id int(11) NOT NULL, |
|
| 7458 |
taxonlabel_id int(11), |
|
| 7459 |
verbatimrank varchar(255), |
|
| 7460 |
taxonomicname varchar(255), |
|
| 7461 |
taxonname varchar(255), |
|
| 7462 |
author varchar(255), |
|
| 7463 |
family varchar(255), |
|
| 7464 |
genus varchar(255), |
|
| 7465 |
specific_epithet varchar(255), |
|
| 7466 |
subspecies varchar(255), |
|
| 7467 |
morphospecies varchar(255), |
|
| 7468 |
morphoname varchar(255), |
|
| 7469 |
growthform varchar(255), |
|
| 7470 |
description varchar(255) |
|
| 7471 |
); |
|
| 7472 |
|
|
| 7473 |
|
|
| 7474 |
-- |
|
| 7475 |
-- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: - |
|
| 7476 |
-- |
|
| 7477 |
|
|
| 7478 |
|
|
| 7479 |
|
|
| 7480 |
|
|
| 7481 |
-- |
|
| 7482 |
-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: - |
|
| 7483 |
-- |
|
| 7484 |
|
|
| 7485 |
|
|
| 7486 |
|
|
| 7487 |
|
|
| 7488 |
-- |
|
| 7489 |
-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: - |
|
| 7490 |
-- |
|
| 7491 |
|
|
| 7492 |
|
|
| 7493 |
|
|
| 7494 |
|
|
| 7495 |
-- |
|
| 7496 |
-- Name: COLUMN taxonverbatim.taxonname; Type: COMMENT; Schema: public; Owner: - |
|
| 7497 |
-- |
|
| 7498 |
|
|
| 7499 |
|
|
| 7500 |
|
|
| 7501 |
|
|
| 7502 |
-- |
|
| 7503 |
-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: - |
|
| 7504 |
-- |
|
| 7505 |
|
|
| 7506 |
|
|
| 7507 |
|
|
| 7508 |
|
|
| 7509 |
-- |
|
| 7510 |
-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: - |
|
| 7511 |
-- |
|
| 7512 |
|
|
| 7513 |
|
|
| 7514 |
|
|
| 7515 |
|
|
| 7516 |
-- |
|
| 7517 |
-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: - |
|
| 7518 |
-- |
|
| 7519 |
|
|
| 7520 |
|
|
| 7521 |
|
|
| 7522 |
|
|
| 7523 |
-- |
|
| 7524 |
-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: - |
|
| 7525 |
-- |
|
| 7526 |
|
|
| 7527 |
|
|
| 7528 |
|
|
| 7529 |
|
|
| 7530 |
-- |
|
| 7531 |
-- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: - |
|
| 7532 |
-- |
|
| 7533 |
|
|
| 7534 |
|
|
| 7535 |
|
|
| 7536 |
|
|
| 7537 |
-- |
|
| 7538 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 7539 |
-- |
|
| 7540 |
|
|
| 7541 |
CREATE TABLE trait ( |
|
| 7542 |
trait_id int(11) NOT NULL, |
|
| 7543 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 7544 |
name varchar(255) NOT NULL, |
|
| 7545 |
value varchar(255), |
|
| 7546 |
units varchar(255) |
|
| 7547 |
); |
|
| 7548 |
|
|
| 7549 |
|
|
| 7550 |
-- |
|
| 7551 |
-- Name: taxon_trait_view; Type: VIEW; Schema: public; Owner: - |
|
| 7552 |
-- |
|
| 7553 |
|
|
| 7554 |
|
|
| 7555 |
|
|
| 7556 |
|
|
| 7557 |
-- |
|
| 7558 | 7413 |
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 7559 | 7414 |
-- |
| 7560 | 7415 |
|
| ... | ... | |
| 7649 | 7504 |
|
| 7650 | 7505 |
|
| 7651 | 7506 |
-- |
| 7507 |
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 7508 |
-- |
|
| 7509 |
|
|
| 7510 |
CREATE TABLE taxondetermination ( |
|
| 7511 |
taxondetermination_id int(11) NOT NULL, |
|
| 7512 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 7513 |
source_id int(11) NOT NULL, |
|
| 7514 |
taxonverbatim_id int(11) NOT NULL, |
|
| 7515 |
party_id int(11), |
|
| 7516 |
role varchar(255) DEFAULT 'unknown' NOT NULL, |
|
| 7517 |
determinationtype varchar(255), |
|
| 7518 |
reference_id int(11), |
|
| 7519 |
isoriginal int(1), |
|
| 7520 |
iscurrent__verbatim int(1), |
|
| 7521 |
iscurrent int(1) DEFAULT false NOT NULL, |
|
| 7522 |
taxonfit varchar(255), |
|
| 7523 |
taxonconfidence varchar(255), |
|
| 7524 |
grouptype varchar(255), |
|
| 7525 |
notes varchar(255), |
|
| 7526 |
revisions int(1), |
|
| 7527 |
determinationdate date |
|
| 7528 |
); |
|
| 7529 |
|
|
| 7530 |
|
|
| 7531 |
-- |
|
| 7532 |
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: - |
|
| 7533 |
-- |
|
| 7534 |
|
|
| 7535 |
|
|
| 7536 |
|
|
| 7537 |
|
|
| 7538 |
-- |
|
| 7652 | 7539 |
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 7653 | 7540 |
-- |
| 7654 | 7541 |
|
| ... | ... | |
| 7771 | 7658 |
|
| 7772 | 7659 |
|
| 7773 | 7660 |
-- |
| 7774 |
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 7661 |
-- Name: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 7775 | 7662 |
-- |
| 7776 | 7663 |
|
| 7777 |
|
|
| 7778 |
|
|
| 7779 |
|
|
| 7780 |
-- |
|
| 7781 |
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 7782 |
-- |
|
| 7783 |
|
|
| 7784 |
|
|
| 7785 |
|
|
| 7786 |
|
|
| 7787 |
-- |
|
| 7788 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 7789 |
-- |
|
| 7790 |
|
|
| 7791 |
CREATE TABLE telephone ( |
|
| 7792 |
telephone_id int(11) NOT NULL, |
|
| 7793 |
party_id int(11) NOT NULL, |
|
| 7794 |
phonenumber varchar(255) NOT NULL, |
|
| 7795 |
phonetype varchar(255) NOT NULL |
|
| 7664 |
CREATE TABLE taxonverbatim ( |
|
| 7665 |
taxonverbatim_id int(11) NOT NULL, |
|
| 7666 |
source_id int(11) NOT NULL, |
|
| 7667 |
taxonlabel_id int(11), |
|
| 7668 |
verbatimrank varchar(255), |
|
| 7669 |
taxonomicname varchar(255), |
|
| 7670 |
taxonname varchar(255), |
|
| 7671 |
author varchar(255), |
|
| 7672 |
family varchar(255), |
|
| 7673 |
genus varchar(255), |
|
| 7674 |
specific_epithet varchar(255), |
|
| 7675 |
subspecies varchar(255), |
|
| 7676 |
morphospecies varchar(255), |
|
| 7677 |
morphoname varchar(255), |
|
| 7678 |
growthform varchar(255), |
|
| 7679 |
description varchar(255) |
|
| 7796 | 7680 |
); |
| 7797 | 7681 |
|
| 7798 | 7682 |
|
| 7799 | 7683 |
-- |
| 7800 |
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 7684 |
-- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: -
|
|
| 7801 | 7685 |
-- |
| 7802 | 7686 |
|
| 7803 | 7687 |
|
| 7804 | 7688 |
|
| 7805 | 7689 |
|
| 7806 | 7690 |
-- |
| 7807 |
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 7691 |
-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -
|
|
| 7808 | 7692 |
-- |
| 7809 | 7693 |
|
| 7810 | 7694 |
|
| 7811 | 7695 |
|
| 7812 | 7696 |
|
| 7813 | 7697 |
-- |
| 7814 |
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: -
|
|
| 7698 |
-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -
|
|
| 7815 | 7699 |
-- |
| 7816 | 7700 |
|
| 7817 | 7701 |
|
| 7818 | 7702 |
|
| 7819 | 7703 |
|
| 7820 | 7704 |
-- |
| 7821 |
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 7705 |
-- Name: COLUMN taxonverbatim.taxonname; Type: COMMENT; Schema: public; Owner: -
|
|
| 7822 | 7706 |
-- |
| 7823 | 7707 |
|
| 7824 | 7708 |
|
| 7825 | 7709 |
|
| 7826 | 7710 |
|
| 7827 | 7711 |
-- |
| 7828 |
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 7712 |
-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -
|
|
| 7829 | 7713 |
-- |
| 7830 | 7714 |
|
| 7831 | 7715 |
|
| 7832 | 7716 |
|
| 7833 | 7717 |
|
| 7834 | 7718 |
-- |
| 7835 |
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 7719 |
-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -
|
|
| 7836 | 7720 |
-- |
| 7837 | 7721 |
|
| 7838 |
CREATE TABLE userdefined ( |
|
| 7839 |
userdefined_id int(11) NOT NULL, |
|
| 7840 |
userdefinedname varchar(255) NOT NULL, |
|
| 7841 |
userdefinedmetadata varchar(255), |
|
| 7842 |
userdefinedcategory varchar(255), |
|
| 7843 |
userdefinedtype varchar(255) DEFAULT 'varchar(255)' NOT NULL, |
|
| 7844 |
tablename varchar(255) NOT NULL |
|
| 7845 |
); |
|
| 7846 | 7722 |
|
| 7847 | 7723 |
|
| 7848 |
-- |
|
| 7849 |
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 7850 |
-- |
|
| 7851 | 7724 |
|
| 7852 |
|
|
| 7853 |
|
|
| 7854 |
|
|
| 7855 | 7725 |
-- |
| 7856 |
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 7726 |
-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 7857 | 7727 |
-- |
| 7858 | 7728 |
|
| 7859 | 7729 |
|
| 7860 | 7730 |
|
| 7861 | 7731 |
|
| 7862 | 7732 |
-- |
| 7863 |
-- Name: view_full_occurrence_CVS; Type: VIEW; Schema: public; Owner: -
|
|
| 7733 |
-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: -
|
|
| 7864 | 7734 |
-- |
| 7865 | 7735 |
|
| 7866 | 7736 |
|
| 7867 | 7737 |
|
| 7868 | 7738 |
|
| 7869 | 7739 |
-- |
| 7870 |
-- Name: VIEW `view_full_occurrence_CVS`; Type: COMMENT; Schema: public; Owner: -
|
|
| 7740 |
-- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: -
|
|
| 7871 | 7741 |
-- |
| 7872 | 7742 |
|
| 7873 | 7743 |
|
| 7874 | 7744 |
|
| 7875 | 7745 |
|
| 7876 | 7746 |
-- |
| 7877 |
-- Name: view_full_occurrence_NCU; Type: VIEW; Schema: public; Owner: -
|
|
| 7747 |
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 7878 | 7748 |
-- |
| 7879 | 7749 |
|
| 7880 | 7750 |
|
| 7881 | 7751 |
|
| 7882 | 7752 |
|
| 7883 | 7753 |
-- |
| 7884 |
-- Name: VIEW `view_full_occurrence_NCU`; Type: COMMENT; Schema: public; Owner: -
|
|
| 7754 |
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 7885 | 7755 |
-- |
| 7886 | 7756 |
|
| 7887 | 7757 |
|
| 7888 | 7758 |
|
| 7889 | 7759 |
|
| 7890 | 7760 |
-- |
| 7891 |
-- Name: view_full_occurrence_VegBank; Type: VIEW; Schema: public; Owner: -
|
|
| 7761 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 7892 | 7762 |
-- |
| 7893 | 7763 |
|
| 7764 |
CREATE TABLE telephone ( |
|
| 7765 |
telephone_id int(11) NOT NULL, |
|
| 7766 |
party_id int(11) NOT NULL, |
|
| 7767 |
phonenumber varchar(255) NOT NULL, |
|
| 7768 |
phonetype varchar(255) NOT NULL |
|
| 7769 |
); |
|
| 7894 | 7770 |
|
| 7895 | 7771 |
|
| 7896 |
|
|
| 7897 | 7772 |
-- |
| 7898 |
-- Name: VIEW `view_full_occurrence_VegBank`; Type: COMMENT; Schema: public; Owner: -
|
|
| 7773 |
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 7899 | 7774 |
-- |
| 7900 | 7775 |
|
| 7901 | 7776 |
|
| 7902 | 7777 |
|
| 7903 | 7778 |
|
| 7904 | 7779 |
-- |
| 7905 |
-- Name: view_full_occurrence_individual_GBIF; Type: VIEW; Schema: public; Owner: -
|
|
| 7780 |
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 7906 | 7781 |
-- |
| 7907 | 7782 |
|
| 7908 | 7783 |
|
| 7909 | 7784 |
|
| 7910 | 7785 |
|
| 7911 | 7786 |
-- |
| 7912 |
-- Name: view_full_occurrence_individual__new_taxonobservation_id_seq1; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 7787 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 7913 | 7788 |
-- |
| 7914 | 7789 |
|
| 7790 |
CREATE TABLE trait ( |
|
| 7791 |
trait_id int(11) NOT NULL, |
|
| 7792 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 7793 |
name varchar(255) NOT NULL, |
|
| 7794 |
value varchar(255), |
|
| 7795 |
units varchar(255) |
|
| 7796 |
); |
|
| 7915 | 7797 |
|
| 7916 | 7798 |
|
| 7917 |
|
|
| 7918 | 7799 |
-- |
| 7919 |
-- Name: view_full_occurrence_individual__new_taxonobservation_id_seq1; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 7800 |
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 7920 | 7801 |
-- |
| 7921 | 7802 |
|
| 7922 | 7803 |
|
| 7923 | 7804 |
|
| 7924 | 7805 |
|
| 7925 | 7806 |
-- |
| 7926 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: VIEW; Schema: public; Owner: -
|
|
| 7807 |
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 7927 | 7808 |
-- |
| 7928 | 7809 |
|
| 7929 | 7810 |
|
| 7930 | 7811 |
|
| 7931 | 7812 |
|
| 7932 | 7813 |
-- |
| 7933 |
-- Name: view_full_occurrence_individual_view; Type: VIEW; Schema: public; Owner: -
|
|
| 7814 |
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 7934 | 7815 |
-- |
| 7935 | 7816 |
|
| 7817 |
CREATE TABLE userdefined ( |
|
| 7818 |
userdefined_id int(11) NOT NULL, |
|
| 7819 |
userdefinedname varchar(255) NOT NULL, |
|
| 7820 |
userdefinedmetadata varchar(255), |
|
| 7821 |
userdefinedcategory varchar(255), |
|
| 7822 |
userdefinedtype varchar(255) DEFAULT 'varchar(255)' NOT NULL, |
|
| 7823 |
tablename varchar(255) NOT NULL |
|
| 7824 |
); |
|
| 7936 | 7825 |
|
| 7937 | 7826 |
|
| 7938 |
|
|
| 7939 | 7827 |
-- |
| 7940 |
-- Name: VIEW view_full_occurrence_individual_view; Type: COMMENT; Schema: public; Owner: -
|
|
| 7828 |
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 7941 | 7829 |
-- |
| 7942 | 7830 |
|
| 7943 | 7831 |
|
| 7944 | 7832 |
|
| 7945 | 7833 |
|
| 7946 | 7834 |
-- |
| 7947 |
-- Name: COLUMN view_full_occurrence_individual_view.datasource; Type: COMMENT; Schema: public; Owner: -
|
|
| 7835 |
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 7948 | 7836 |
-- |
| 7949 | 7837 |
|
| 7950 | 7838 |
|
| 7951 | 7839 |
|
| 7952 | 7840 |
|
| 7953 | 7841 |
-- |
| 7954 |
-- Name: COLUMN view_full_occurrence_individual_view.country; Type: COMMENT; Schema: public; Owner: -
|
|
| 7842 |
-- Name: view_full_occurrence_CVS; Type: VIEW; Schema: public; Owner: -
|
|
| 7955 | 7843 |
-- |
| 7956 | 7844 |
|
| 7957 | 7845 |
|
| 7958 | 7846 |
|
| 7959 | 7847 |
|
| 7960 | 7848 |
-- |
| 7961 |
-- Name: COLUMN view_full_occurrence_individual_view.state_province; Type: COMMENT; Schema: public; Owner: -
|
|
| 7849 |
-- Name: VIEW `view_full_occurrence_CVS`; Type: COMMENT; Schema: public; Owner: -
|
|
| 7962 | 7850 |
-- |
| 7963 | 7851 |
|
| 7964 | 7852 |
|
| 7965 | 7853 |
|
| 7966 | 7854 |
|
| 7967 | 7855 |
-- |
| 7968 |
-- Name: COLUMN view_full_occurrence_individual_view.county; Type: COMMENT; Schema: public; Owner: -
|
|
| 7856 |
-- Name: view_full_occurrence_NCU; Type: VIEW; Schema: public; Owner: -
|
|
| 7969 | 7857 |
-- |
| 7970 | 7858 |
|
| 7971 | 7859 |
|
| 7972 | 7860 |
|
| 7973 | 7861 |
|
| 7974 | 7862 |
-- |
| 7975 |
-- Name: COLUMN view_full_occurrence_individual_view.locality; Type: COMMENT; Schema: public; Owner: -
|
|
| 7863 |
-- Name: VIEW `view_full_occurrence_NCU`; Type: COMMENT; Schema: public; Owner: -
|
|
| 7976 | 7864 |
-- |
| 7977 | 7865 |
|
| 7978 | 7866 |
|
| 7979 | 7867 |
|
| 7980 | 7868 |
|
| 7981 | 7869 |
-- |
| 7982 |
-- Name: COLUMN view_full_occurrence_individual_view.latitude; Type: COMMENT; Schema: public; Owner: -
|
|
| 7870 |
-- Name: view_full_occurrence_VegBank; Type: VIEW; Schema: public; Owner: -
|
|
| 7983 | 7871 |
-- |
| 7984 | 7872 |
|
| 7985 | 7873 |
|
| 7986 | 7874 |
|
| 7987 | 7875 |
|
| 7988 | 7876 |
-- |
| 7989 |
-- Name: COLUMN view_full_occurrence_individual_view.longitude; Type: COMMENT; Schema: public; Owner: -
|
|
| 7877 |
-- Name: VIEW `view_full_occurrence_VegBank`; Type: COMMENT; Schema: public; Owner: -
|
|
| 7990 | 7878 |
-- |
| 7991 | 7879 |
|
| 7992 | 7880 |
|
| 7993 | 7881 |
|
| 7994 | 7882 |
|
| 7995 | 7883 |
-- |
| 7996 |
-- Name: COLUMN view_full_occurrence_individual_view.coord_uncertainty_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 7884 |
-- Name: view_full_occurrence_individual_GBIF; Type: VIEW; Schema: public; Owner: -
|
|
| 7997 | 7885 |
-- |
| 7998 | 7886 |
|
| 7999 | 7887 |
|
| 8000 | 7888 |
|
| 8001 | 7889 |
|
| 8002 | 7890 |
-- |
| 8003 |
-- Name: COLUMN view_full_occurrence_individual_view.georef_sources; Type: COMMENT; Schema: public; Owner: -
|
|
| 7891 |
-- Name: view_full_occurrence_individual__new_taxonobservation_id_seq1; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 8004 | 7892 |
-- |
| 8005 | 7893 |
|
| 8006 | 7894 |
|
| 8007 | 7895 |
|
| 8008 | 7896 |
|
| 8009 | 7897 |
-- |
| 8010 |
-- Name: COLUMN view_full_occurrence_individual_view.georef_protocol; Type: COMMENT; Schema: public; Owner: -
|
|
| 7898 |
-- Name: view_full_occurrence_individual__new_taxonobservation_id_seq1; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 8011 | 7899 |
-- |
| 8012 | 7900 |
|
| 8013 | 7901 |
|
| 8014 | 7902 |
|
| 8015 | 7903 |
|
| 8016 | 7904 |
-- |
| 8017 |
-- Name: COLUMN view_full_occurrence_individual_view.is_geovalid; Type: COMMENT; Schema: public; Owner: -
|
|
| 7905 |
-- Name: view_full_occurrence_individual_non_GBIF; Type: VIEW; Schema: public; Owner: -
|
|
| 8018 | 7906 |
-- |
| 8019 | 7907 |
|
| 8020 | 7908 |
|
| 8021 | 7909 |
|
| 8022 | 7910 |
|
| 8023 | 7911 |
-- |
| 8024 |
-- Name: COLUMN view_full_occurrence_individual_view.is_new_world; Type: COMMENT; Schema: public; Owner: - |
|
| 8025 |
-- |
|
| 8026 |
|
|
| 8027 |
|
|
| 8028 |
|
|
| 8029 |
|
|
| 8030 |
-- |
|
| 8031 |
-- Name: COLUMN view_full_occurrence_individual_view.project_id; Type: COMMENT; Schema: public; Owner: - |
|
| 8032 |
-- |
|
| 8033 |
|
|
| 8034 |
|
|
| 8035 |
|
|
| 8036 |
|
|
| 8037 |
-- |
|
| 8038 |
-- Name: COLUMN view_full_occurrence_individual_view.project_contributors; Type: COMMENT; Schema: public; Owner: - |
|
| 8039 |
-- |
|
| 8040 |
|
|
| 8041 |
|
|
| 8042 |
|
|
| 8043 |
|
|
| 8044 |
-- |
|
| 8045 |
-- Name: COLUMN view_full_occurrence_individual_view.location_id; Type: COMMENT; Schema: public; Owner: - |
|
| 8046 |
-- |
|
| 8047 |
|
|
| 8048 |
|
|
| 8049 |
|
|
| 8050 |
|
|
| 8051 |
-- |
|
| 8052 |
-- Name: COLUMN view_full_occurrence_individual_view.plot_name; Type: COMMENT; Schema: public; Owner: - |
|
| 8053 |
-- |
|
| 8054 |
|
|
| 8055 |
|
|
| 8056 |
|
|
| 8057 |
|
|
| 8058 |
-- |
|
| 8059 |
-- Name: COLUMN view_full_occurrence_individual_view.subplot; Type: COMMENT; Schema: public; Owner: - |
|
| 8060 |
-- |
|
| 8061 |
|
|
| 8062 |
|
|
| 8063 |
|
|
| 8064 |
|
|
| 8065 |
-- |
|
| 8066 |
-- Name: COLUMN view_full_occurrence_individual_view.is_location_cultivated; Type: COMMENT; Schema: public; Owner: - |
|
| 8067 |
-- |
|
| 8068 |
|
|
| 8069 |
|
|
| 8070 |
|
|
| 8071 |
|
|
| 8072 |
-- |
|
| 8073 |
-- Name: COLUMN view_full_occurrence_individual_view.locationevent_id; Type: COMMENT; Schema: public; Owner: - |
|
| 8074 |
-- |
|
| 8075 |
|
|
| 8076 |
|
|
| 8077 |
|
|
| 8078 |
|
|
| 8079 |
-- |
|
| 8080 |
-- Name: COLUMN view_full_occurrence_individual_view.event_date; Type: COMMENT; Schema: public; Owner: - |
|
| 8081 |
-- |
|
| 8082 |
|
|
| 8083 |
|
|
| 8084 |
|
|
| 8085 |
|
|
| 8086 |
-- |
|
| 8087 |
-- Name: COLUMN view_full_occurrence_individual_view.elevation_m; Type: COMMENT; Schema: public; Owner: - |
|
| 8088 |
-- |
|
| 8089 |
|
|
| 8090 |
|
|
| 8091 |
|
|
| 8092 |
|
|
| 8093 |
-- |
|
| 8094 |
-- Name: COLUMN view_full_occurrence_individual_view.slope_aspect_deg; Type: COMMENT; Schema: public; Owner: - |
|
| 8095 |
-- |
|
| 8096 |
|
|
| 8097 |
|
|
| 8098 |
|
|
| 8099 |
|
|
| 8100 |
-- |
|
| 8101 |
-- Name: COLUMN view_full_occurrence_individual_view.slope_gradient_deg; Type: COMMENT; Schema: public; Owner: - |
|
| 8102 |
-- |
|
| 8103 |
|
|
| 8104 |
|
|
| 8105 |
|
|
| 8106 |
|
|
| 8107 |
-- |
|
| 8108 |
-- Name: COLUMN view_full_occurrence_individual_view.plot_area_ha; Type: COMMENT; Schema: public; Owner: - |
|
| 8109 |
-- |
|
| 8110 |
|
|
| 8111 |
|
|
| 8112 |
|
|
| 8113 |
|
|
| 8114 |
-- |
|
| 8115 |
-- Name: COLUMN view_full_occurrence_individual_view.sampling_protocol; Type: COMMENT; Schema: public; Owner: - |
|
| 8116 |
-- |
|
| 8117 |
|
|
| 8118 |
|
|
| 8119 |
|
|
| 8120 |
|
|
| 8121 |
-- |
|
| 8122 |
-- Name: COLUMN view_full_occurrence_individual_view.temperature_c; Type: COMMENT; Schema: public; Owner: - |
|
| 8123 |
-- |
|
| 8124 |
|
|
| 8125 |
|
|
| 8126 |
|
|
| 8127 |
|
|
| 8128 |
-- |
|
| 8129 |
-- Name: COLUMN view_full_occurrence_individual_view.precip_mm; Type: COMMENT; Schema: public; Owner: - |
|
| 8130 |
-- |
|
| 8131 |
|
|
| 8132 |
|
|
| 8133 |
|
|
| 8134 |
|
|
| 8135 |
-- |
|
| 8136 |
-- Name: COLUMN view_full_occurrence_individual_view.stratum_name; Type: COMMENT; Schema: public; Owner: - |
|
| 8137 |
-- |
|
| 8138 |
|
|
| 8139 |
|
|
| 8140 |
|
|
| 8141 |
|
|
| 8142 |
-- |
|
| 8143 |
-- Name: COLUMN view_full_occurrence_individual_view.community_concept_name; Type: COMMENT; Schema: public; Owner: - |
|
| 8144 |
-- |
|
| 8145 |
|
|
| 8146 |
|
|
| 8147 |
|
|
| 8148 |
|
|
| 8149 |
-- |
|
| 8150 |
-- Name: COLUMN view_full_occurrence_individual_view.observation_contributors; Type: COMMENT; Schema: public; Owner: - |
|
| 8151 |
-- |
|
| 8152 |
|
|
| 8153 |
|
|
| 8154 |
|
|
| 8155 |
|
|
| 8156 |
-- |
|
| 8157 |
-- Name: COLUMN view_full_occurrence_individual_view.custodial_institution_codes; Type: COMMENT; Schema: public; Owner: - |
|
| 8158 |
-- |
|
| 8159 |
|
|
| 8160 |
|
|
| 8161 |
|
|
| 8162 |
|
|
| 8163 |
-- |
|
| 8164 |
-- Name: COLUMN view_full_occurrence_individual_view.collection_code; Type: COMMENT; Schema: public; Owner: - |
|
| 8165 |
-- |
|
| 8166 |
|
|
| 8167 |
|
|
| 8168 |
|
|
| 8169 |
|
|
| 8170 |
-- |
|
| 8171 |
-- Name: COLUMN view_full_occurrence_individual_view.catalog_number; Type: COMMENT; Schema: public; Owner: - |
|
| 8172 |
-- |
|
| 8173 |
|
|
| 8174 |
|
|
| 8175 |
|
|
| 8176 |
|
|
| 8177 |
-- |
|
| 8178 |
-- Name: COLUMN view_full_occurrence_individual_view.occurrence_id; Type: COMMENT; Schema: public; Owner: - |
|
| 8179 |
-- |
|
| 8180 |
|
|
| 8181 |
|
|
| 8182 |
|
|
| 8183 |
|
|
| 8184 |
-- |
|
| 8185 |
-- Name: COLUMN view_full_occurrence_individual_view.recorded_by; Type: COMMENT; Schema: public; Owner: - |
|
| 8186 |
-- |
|
| 8187 |
|
|
| 8188 |
|
|
| 8189 |
|
|
| 8190 |
|
|
| 8191 |
-- |
|
| 8192 |
-- Name: COLUMN view_full_occurrence_individual_view.record_number; Type: COMMENT; Schema: public; Owner: - |
|
| 8193 |
-- |
|
| 8194 |
|
|
| 8195 |
|
|
| 8196 |
|
|
| 8197 |
|
|
| 8198 |
-- |
|
| 8199 |
-- Name: COLUMN view_full_occurrence_individual_view.date_collected; Type: COMMENT; Schema: public; Owner: - |
|
| 8200 |
-- |
|
| 8201 |
|
|
| 8202 |
|
|
| 8203 |
|
|
| 8204 |
|
|
| 8205 |
-- |
|
| 8206 |
-- Name: COLUMN view_full_occurrence_individual_view.verbatim_family; Type: COMMENT; Schema: public; Owner: - |
|
| 8207 |
-- |
|
| 8208 |
|
|
| 8209 |
|
|
| 8210 |
|
|
| 8211 |
|
|
| 8212 |
-- |
|
| 8213 |
-- Name: COLUMN view_full_occurrence_individual_view.verbatim_scientific_name; Type: COMMENT; Schema: public; Owner: - |
|
| 8214 |
-- |
|
| 8215 |
|
|
| 8216 |
|
|
| 8217 |
|
|
| 8218 |
|
|
| 8219 |
-- |
|
| 8220 |
-- Name: COLUMN view_full_occurrence_individual_view.identified_by; Type: COMMENT; Schema: public; Owner: - |
|
| 8221 |
-- |
|
| 8222 |
|
|
| 8223 |
|
|
| 8224 |
|
|
| 8225 |
|
|
| 8226 |
-- |
|
| 8227 |
-- Name: COLUMN view_full_occurrence_individual_view.date_identified; Type: COMMENT; Schema: public; Owner: - |
|
| 8228 |
-- |
|
| 8229 |
|
|
| 8230 |
|
|
| 8231 |
|
|
| 8232 |
|
|
| 8233 |
-- |
|
| 8234 |
-- Name: COLUMN view_full_occurrence_individual_view.identification_remarks; Type: COMMENT; Schema: public; Owner: - |
|
| 8235 |
-- |
|
| 8236 |
|
|
| 8237 |
|
|
| 8238 |
|
|
| 8239 |
|
|
| 8240 |
-- |
|
| 8241 |
-- Name: COLUMN view_full_occurrence_individual_view.family_matched; Type: COMMENT; Schema: public; Owner: - |
|
| 8242 |
-- |
|
| 8243 |
|
|
| 8244 |
|
|
| 8245 |
|
|
| 8246 |
|
|
| 8247 |
-- |
|
| 8248 |
-- Name: COLUMN view_full_occurrence_individual_view.name_matched; Type: COMMENT; Schema: public; Owner: - |
|
| 8249 |
-- |
|
| 8250 |
|
|
| 8251 |
|
|
| 8252 |
|
|
| 8253 |
|
|
| 8254 |
-- |
|
| 8255 |
-- Name: COLUMN view_full_occurrence_individual_view.name_matched_author; Type: COMMENT; Schema: public; Owner: - |
|
| 8256 |
-- |
|
| 8257 |
|
|
| 8258 |
|
|
| 8259 |
|
|
| 8260 |
|
|
| 8261 |
-- |
|
| 8262 |
-- Name: COLUMN view_full_occurrence_individual_view.higher_plant_group; Type: COMMENT; Schema: public; Owner: - |
|
| 8263 |
-- |
|
| 8264 |
|
|
| 8265 |
|
|
| 8266 |
|
|
| 8267 |
|
|
| 8268 |
-- |
|
| 8269 |
-- Name: COLUMN view_full_occurrence_individual_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: - |
|
| 8270 |
-- |
|
| 8271 |
|
|
| 8272 |
|
|
| 8273 |
|
|
| 8274 |
|
|
| 8275 |
-- |
|
| 8276 |
-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 8277 |
-- |
|
| 8278 |
|
|
| 8279 |
|
|
| 8280 |
|
|
| 8281 |
|
|
| 8282 |
-- |
|
| 8283 |
-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 8284 |
-- |
|
| 8285 |
|
|
| 8286 |
|
|
| 8287 |
|
|
| 8288 |
|
|
| 8289 |
-- |
|
| 8290 |
-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: - |
|
| 8291 |
-- |
|
| 8292 |
|
|
| 8293 |
|
|
| 8294 |
|
|
| 8295 |
|
|
| 8296 |
-- |
|
| 8297 |
-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 8298 |
-- |
|
| 8299 |
|
|
| 8300 |
|
|
| 8301 |
|
|
| 8302 |
|
|
| 8303 |
-- |
|
| 8304 |
-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 8305 |
-- |
|
| 8306 |
|
|
| 8307 |
|
|
| 8308 |
|
|
| 8309 |
|
|
| 8310 |
-- |
|
| 8311 |
-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 8312 |
-- |
|
| 8313 |
|
|
| 8314 |
|
|
| 8315 |
|
|
| 8316 |
|
|
| 8317 |
-- |
|
| 8318 |
-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: - |
|
| 8319 |
-- |
|
| 8320 |
|
|
| 8321 |
|
|
| 8322 |
|
|
| 8323 |
|
|
| 8324 |
-- |
|
| 8325 |
-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_species_binomial_with_morphospecies; Type: COMMENT; Schema: public; Owner: - |
|
| 8326 |
-- |
|
| 8327 |
|
|
| 8328 |
|
|
| 8329 |
|
|
| 8330 |
|
|
| 8331 |
-- |
|
| 8332 |
-- Name: COLUMN view_full_occurrence_individual_view.growth_form; Type: COMMENT; Schema: public; Owner: - |
|
| 8333 |
-- |
|
| 8334 |
|
|
| 8335 |
|
|
| 8336 |
|
|
| 8337 |
|
|
| 8338 |
-- |
|
| 8339 |
-- Name: COLUMN view_full_occurrence_individual_view.reproductive_condition; Type: COMMENT; Schema: public; Owner: - |
|
| 8340 |
-- |
|
| 8341 |
|
|
| 8342 |
|
|
| 8343 |
|
|
| 8344 |
|
|
| 8345 |
-- |
|
| 8346 |
-- Name: COLUMN view_full_occurrence_individual_view.is_cultivated; Type: COMMENT; Schema: public; Owner: - |
|
| 8347 |
-- |
|
| 8348 |
|
|
| 8349 |
|
|
| 8350 |
|
|
| 8351 |
|
|
| 8352 |
-- |
|
| 8353 |
-- Name: COLUMN view_full_occurrence_individual_view.is_cultivated_basis; Type: COMMENT; Schema: public; Owner: - |
|
| 8354 |
-- |
|
| 8355 |
|
|
| 8356 |
|
|
| 8357 |
|
|
| 8358 |
|
|
| 8359 |
-- |
|
| 8360 |
-- Name: COLUMN view_full_occurrence_individual_view.occurrence_remarks; Type: COMMENT; Schema: public; Owner: - |
|
| 8361 |
-- |
|
| 8362 |
|
|
| 8363 |
|
|
| 8364 |
|
|
| 8365 |
|
|
| 8366 |
-- |
|
| 8367 |
-- Name: COLUMN view_full_occurrence_individual_view.cover_percent; Type: COMMENT; Schema: public; Owner: - |
|
| 8368 |
-- |
|
| 8369 |
|
|
| 8370 |
|
|
| 8371 |
|
|
| 8372 |
|
|
| 8373 |
-- |
|
| 8374 |
-- Name: COLUMN view_full_occurrence_individual_view.taxon_observation_id; Type: COMMENT; Schema: public; Owner: - |
|
| 8375 |
-- |
|
| 8376 |
|
|
| 8377 |
|
|
| 8378 |
|
|
| 8379 |
|
|
| 8380 |
-- |
|
| 8381 |
-- Name: COLUMN view_full_occurrence_individual_view.taxon_name_usage_concept_author_code; Type: COMMENT; Schema: public; Owner: - |
|
| 8382 |
-- |
|
| 8383 |
|
|
| 8384 |
|
|
| 8385 |
|
|
| 8386 |
|
|
| 8387 |
-- |
|
| 8388 |
-- Name: COLUMN view_full_occurrence_individual_view.aggregate_organism_observation_id; Type: COMMENT; Schema: public; Owner: - |
|
| 8389 |
-- |
|
| 8390 |
|
|
| 8391 |
|
|
| 8392 |
|
|
| 8393 |
|
|
| 8394 |
-- |
|
| 8395 |
-- Name: COLUMN view_full_occurrence_individual_view.individual_organism_observation_id; Type: COMMENT; Schema: public; Owner: - |
|
| 8396 |
-- |
|
| 8397 |
|
|
| 8398 |
|
|
| 8399 |
|
|
| 8400 |
|
|
| 8401 |
-- |
|
| 8402 |
-- Name: COLUMN view_full_occurrence_individual_view.individual_id; Type: COMMENT; Schema: public; Owner: - |
|
| 8403 |
-- |
|
| 8404 |
|
|
| 8405 |
|
|
| 8406 |
|
|
| 8407 |
|
|
| 8408 |
-- |
|
| 8409 |
-- Name: COLUMN view_full_occurrence_individual_view.individual_count; Type: COMMENT; Schema: public; Owner: - |
|
| 8410 |
-- |
|
| 8411 |
|
|
| 8412 |
|
|
| 8413 |
|
|
| 8414 |
|
|
| 8415 |
-- |
|
| 8416 |
-- Name: COLUMN view_full_occurrence_individual_view.plantobservation_id; Type: COMMENT; Schema: public; Owner: - |
|
| 8417 |
-- |
|
| 8418 |
|
|
| 8419 |
|
|
| 8420 |
|
|
| 8421 |
|
|
| 8422 |
-- |
|
| 8423 | 7912 |
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 8424 | 7913 |
-- |
| 8425 | 7914 |
|
| ... | ... | |
| 8657 | 8146 |
|
| 8658 | 8147 |
|
| 8659 | 8148 |
-- |
| 8660 |
-- Name: _plots_20_tnrs_names; Type: VIEW; Schema: public_validations; Owner: - |
|
| 8661 |
-- |
|
| 8662 |
|
|
| 8663 |
|
|
| 8664 |
|
|
| 8665 |
|
|
| 8666 |
-- |
|
| 8667 |
-- Name: VIEW _plots_20_tnrs_names; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 8668 |
-- |
|
| 8669 |
|
|
| 8670 |
|
|
| 8671 |
|
|
| 8672 |
|
|
| 8673 |
-- |
|
| 8674 | 8149 |
-- Name: _specimens_01_count_of_total_records_specimens_in_source_db; Type: VIEW; Schema: public_validations; Owner: - |
| 8675 | 8150 |
-- |
| 8676 | 8151 |
|
| ... | ... | |
| 13605 | 13080 |
|
| 13606 | 13081 |
|
| 13607 | 13082 |
-- |
| 13608 |
-- Name: taxonlabel_taxonomicname_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13609 |
-- |
|
| 13610 |
|
|
| 13611 |
|
|
| 13612 |
|
|
| 13613 |
|
|
| 13614 |
-- |
|
| 13615 | 13083 |
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 13616 | 13084 |
-- |
| 13617 | 13085 |
|
| ... | ... | |
| 15117 | 14585 |
|
| 15118 | 14586 |
|
| 15119 | 14587 |
-- |
| 14588 |
-- Name: 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private; Type: ACL; Schema: public; Owner: - |
|
| 14589 |
-- |
|
| 14590 |
|
|
| 14591 |
|
|
| 14592 |
|
|
| 14593 |
|
|
| 14594 |
|
|
| 14595 |
|
|
| 14596 |
|
|
| 14597 |
-- |
|
| 15120 | 14598 |
-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: ACL; Schema: public; Owner: - |
| 15121 | 14599 |
-- |
| 15122 | 14600 |
|
| ... | ... | |
| 15440 | 14918 |
|
| 15441 | 14919 |
|
| 15442 | 14920 |
-- |
| 15443 |
-- Name: iucn_red_list_view; Type: ACL; Schema: public; Owner: - |
|
| 15444 |
-- |
|
| 15445 |
|
|
| 15446 |
|
|
| 15447 |
|
|
| 15448 |
|
|
| 15449 |
|
|
| 15450 |
|
|
| 15451 |
|
|
| 15452 |
-- |
|
| 15453 | 14921 |
-- Name: location; Type: ACL; Schema: public; Owner: - |
| 15454 | 14922 |
-- |
| 15455 | 14923 |
|
| ... | ... | |
| 15813 | 15281 |
|
| 15814 | 15282 |
|
| 15815 | 15283 |
-- |
| 15816 |
-- Name: taxondetermination; Type: ACL; Schema: public; Owner: -
|
|
| 15284 |
-- Name: taxonalt; Type: ACL; Schema: public; Owner: -
|
|
| 15817 | 15285 |
-- |
| 15818 | 15286 |
|
| 15819 | 15287 |
|
| ... | ... | |
| 15823 | 15291 |
|
| 15824 | 15292 |
|
| 15825 | 15293 |
-- |
| 15826 |
-- Name: taxonverbatim; Type: ACL; Schema: public; Owner: -
|
|
| 15294 |
-- Name: taxonconcept; Type: ACL; Schema: public; Owner: -
|
|
| 15827 | 15295 |
-- |
| 15828 | 15296 |
|
| 15829 | 15297 |
|
| ... | ... | |
| 15833 | 15301 |
|
| 15834 | 15302 |
|
| 15835 | 15303 |
-- |
| 15836 |
-- Name: trait; Type: ACL; Schema: public; Owner: -
|
|
| 15304 |
-- Name: taxoncorrelation; Type: ACL; Schema: public; Owner: -
|
|
| 15837 | 15305 |
-- |
| 15838 | 15306 |
|
| 15839 | 15307 |
|
| ... | ... | |
| 15843 | 15311 |
|
| 15844 | 15312 |
|
| 15845 | 15313 |
-- |
| 15846 |
-- Name: taxon_trait_view; Type: ACL; Schema: public; Owner: -
|
|
| 15314 |
-- Name: taxondetermination; Type: ACL; Schema: public; Owner: -
|
|
| 15847 | 15315 |
-- |
| 15848 | 15316 |
|
| 15849 | 15317 |
|
| ... | ... | |
| 15853 | 15321 |
|
| 15854 | 15322 |
|
| 15855 | 15323 |
-- |
| 15856 |
-- Name: taxonalt; Type: ACL; Schema: public; Owner: -
|
|
| 15324 |
-- Name: taxonlabel_relationship; Type: ACL; Schema: public; Owner: -
|
|
| 15857 | 15325 |
-- |
| 15858 | 15326 |
|
| 15859 | 15327 |
|
| ... | ... | |
| 15863 | 15331 |
|
| 15864 | 15332 |
|
| 15865 | 15333 |
-- |
| 15866 |
-- Name: taxonconcept; Type: ACL; Schema: public; Owner: -
|
|
| 15334 |
-- Name: taxonlineage; Type: ACL; Schema: public; Owner: -
|
|
| 15867 | 15335 |
-- |
| 15868 | 15336 |
|
| 15869 | 15337 |
|
| ... | ... | |
| 15873 | 15341 |
|
| 15874 | 15342 |
|
| 15875 | 15343 |
-- |
| 15876 |
-- Name: taxoncorrelation; Type: ACL; Schema: public; Owner: -
|
|
| 15344 |
-- Name: taxonstatus; Type: ACL; Schema: public; Owner: -
|
|
| 15877 | 15345 |
-- |
| 15878 | 15346 |
|
| 15879 | 15347 |
|
| ... | ... | |
| 15883 | 15351 |
|
| 15884 | 15352 |
|
| 15885 | 15353 |
-- |
| 15886 |
-- Name: taxonlabel_relationship; Type: ACL; Schema: public; Owner: -
|
|
| 15354 |
-- Name: taxonverbatim; Type: ACL; Schema: public; Owner: -
|
|
| 15887 | 15355 |
-- |
| 15888 | 15356 |
|
| 15889 | 15357 |
|
| ... | ... | |
| 15893 | 15361 |
|
| 15894 | 15362 |
|
| 15895 | 15363 |
-- |
| 15896 |
-- Name: taxonlineage; Type: ACL; Schema: public; Owner: - |
|
| 15897 |
-- |
|
| 15898 |
|
|
| 15899 |
|
|
| 15900 |
|
|
| 15901 |
|
|
| 15902 |
|
|
| 15903 |
|
|
| 15904 |
|
|
| 15905 |
-- |
|
| 15906 |
-- Name: taxonstatus; Type: ACL; Schema: public; Owner: - |
|
| 15907 |
-- |
|
| 15908 |
|
|
| 15909 |
|
|
| 15910 |
|
|
| 15911 |
|
|
| 15912 |
|
|
| 15913 |
|
|
| 15914 |
|
|
| 15915 |
-- |
|
| 15916 | 15364 |
-- Name: telephone; Type: ACL; Schema: public; Owner: - |
| 15917 | 15365 |
-- |
| 15918 | 15366 |
|
| ... | ... | |
| 15923 | 15371 |
|
| 15924 | 15372 |
|
| 15925 | 15373 |
-- |
| 15926 |
-- Name: tnrs_input_name; Type: ACL; Schema: public; Owner: -
|
|
| 15374 |
-- Name: trait; Type: ACL; Schema: public; Owner: -
|
|
| 15927 | 15375 |
-- |
| 15928 | 15376 |
|
| 15929 | 15377 |
|
| ... | ... | |
| 15993 | 15441 |
|
| 15994 | 15442 |
|
| 15995 | 15443 |
-- |
| 15996 |
-- Name: view_full_occurrence_individual_view; Type: ACL; Schema: public; Owner: - |
|
| 15997 |
-- |
|
| 15998 |
|
|
| 15999 |
|
|
| 16000 |
|
|
| 16001 |
|
|
| 16002 |
|
|
| 16003 |
|
|
| 16004 |
|
|
| 16005 |
-- |
|
| 16006 | 15444 |
-- Name: voucher; Type: ACL; Schema: public; Owner: - |
| 16007 | 15445 |
-- |
| 16008 | 15446 |
|
Also available in: Unified diff
schemas/public_.sql: added 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private view