Revision 13654
Added by Aaron Marcuse-Kubitza over 10 years ago
vegbien.sql | ||
---|---|---|
6842 | 6842 |
|
6843 | 6843 |
|
6844 | 6844 |
-- |
6845 |
-- Name: COLUMN analytical_stem_view.datasource; Type: COMMENT; Schema: public; Owner: - |
|
6846 |
-- |
|
6847 |
|
|
6848 |
COMMENT ON COLUMN analytical_stem_view.datasource IS 'where this database got the data; the proximate data provider'; |
|
6849 |
|
|
6850 |
|
|
6851 |
-- |
|
6852 |
-- Name: COLUMN analytical_stem_view.country; Type: COMMENT; Schema: public; Owner: - |
|
6853 |
-- |
|
6854 |
|
|
6855 |
COMMENT ON COLUMN analytical_stem_view.country IS 'from DwC'; |
|
6856 |
|
|
6857 |
|
|
6858 |
-- |
|
6859 |
-- Name: COLUMN analytical_stem_view."stateProvince"; Type: COMMENT; Schema: public; Owner: - |
|
6860 |
-- |
|
6861 |
|
|
6862 |
COMMENT ON COLUMN analytical_stem_view."stateProvince" IS 'from DwC'; |
|
6863 |
|
|
6864 |
|
|
6865 |
-- |
|
6866 |
-- Name: COLUMN analytical_stem_view.county; Type: COMMENT; Schema: public; Owner: - |
|
6867 |
-- |
|
6868 |
|
|
6869 |
COMMENT ON COLUMN analytical_stem_view.county IS 'from DwC'; |
|
6870 |
|
|
6871 |
|
|
6872 |
-- |
|
6873 |
-- Name: COLUMN analytical_stem_view.locality; Type: COMMENT; Schema: public; Owner: - |
|
6874 |
-- |
|
6875 |
|
|
6876 |
COMMENT ON COLUMN analytical_stem_view.locality IS 'from DwC'; |
|
6877 |
|
|
6878 |
|
|
6879 |
-- |
|
6880 |
-- Name: COLUMN analytical_stem_view."decimalLatitude"; Type: COMMENT; Schema: public; Owner: - |
|
6881 |
-- |
|
6882 |
|
|
6883 |
COMMENT ON COLUMN analytical_stem_view."decimalLatitude" IS 'from DwC'; |
|
6884 |
|
|
6885 |
|
|
6886 |
-- |
|
6887 |
-- Name: COLUMN analytical_stem_view."decimalLongitude"; Type: COMMENT; Schema: public; Owner: - |
|
6888 |
-- |
|
6889 |
|
|
6890 |
COMMENT ON COLUMN analytical_stem_view."decimalLongitude" IS 'from DwC'; |
|
6891 |
|
|
6892 |
|
|
6893 |
-- |
|
6894 |
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters"; Type: COMMENT; Schema: public; Owner: - |
|
6895 |
-- |
|
6896 |
|
|
6897 |
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters" IS 'from DwC'; |
|
6898 |
|
|
6899 |
|
|
6900 |
-- |
|
6901 |
-- Name: COLUMN analytical_stem_view."locationID"; Type: COMMENT; Schema: public; Owner: - |
|
6902 |
-- |
|
6903 |
|
|
6904 |
COMMENT ON COLUMN analytical_stem_view."locationID" IS 'from DwC'; |
|
6905 |
|
|
6906 |
|
|
6907 |
-- |
|
6908 |
-- Name: COLUMN analytical_stem_view."locationName"; Type: COMMENT; Schema: public; Owner: - |
|
6909 |
-- |
|
6910 |
|
|
6911 |
COMMENT ON COLUMN analytical_stem_view."locationName" IS 'from DwC'; |
|
6912 |
|
|
6913 |
|
|
6914 |
-- |
|
6915 |
-- Name: COLUMN analytical_stem_view."eventDate"; Type: COMMENT; Schema: public; Owner: - |
|
6916 |
-- |
|
6917 |
|
|
6918 |
COMMENT ON COLUMN analytical_stem_view."eventDate" IS 'from DwC'; |
|
6919 |
|
|
6920 |
|
|
6921 |
-- |
|
6922 |
-- Name: COLUMN analytical_stem_view."elevationInMeters"; Type: COMMENT; Schema: public; Owner: - |
|
6923 |
-- |
|
6924 |
|
|
6925 |
COMMENT ON COLUMN analytical_stem_view."elevationInMeters" IS 'variant of DwC term'; |
|
6926 |
|
|
6927 |
|
|
6928 |
-- |
|
6929 |
-- Name: COLUMN analytical_stem_view."samplingProtocol"; Type: COMMENT; Schema: public; Owner: - |
|
6930 |
-- |
|
6931 |
|
|
6932 |
COMMENT ON COLUMN analytical_stem_view."samplingProtocol" IS 'from DwC'; |
|
6933 |
|
|
6934 |
|
|
6935 |
-- |
|
6936 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: - |
|
6937 |
-- |
|
6938 |
|
|
6939 |
COMMENT ON COLUMN analytical_stem_view.collection IS 'from DwC, renamed'; |
|
6940 |
|
|
6941 |
|
|
6942 |
-- |
|
6943 |
-- Name: COLUMN analytical_stem_view."occurrenceID"; Type: COMMENT; Schema: public; Owner: - |
|
6944 |
-- |
|
6945 |
|
|
6946 |
COMMENT ON COLUMN analytical_stem_view."occurrenceID" IS 'from DwC'; |
|
6947 |
|
|
6948 |
|
|
6949 |
-- |
|
6950 |
-- Name: COLUMN analytical_stem_view."recordedBy"; Type: COMMENT; Schema: public; Owner: - |
|
6951 |
-- |
|
6952 |
|
|
6953 |
COMMENT ON COLUMN analytical_stem_view."recordedBy" IS 'from DwC'; |
|
6954 |
|
|
6955 |
|
|
6956 |
-- |
|
6957 |
-- Name: COLUMN analytical_stem_view."recordNumber"; Type: COMMENT; Schema: public; Owner: - |
|
6958 |
-- |
|
6959 |
|
|
6960 |
COMMENT ON COLUMN analytical_stem_view."recordNumber" IS 'from DwC'; |
|
6961 |
|
|
6962 |
|
|
6963 |
-- |
|
6964 |
-- Name: COLUMN analytical_stem_view."dateCollected"; Type: COMMENT; Schema: public; Owner: - |
|
6965 |
-- |
|
6966 |
|
|
6967 |
COMMENT ON COLUMN analytical_stem_view."dateCollected" IS 'variant of DwC term'; |
|
6968 |
|
|
6969 |
|
|
6970 |
-- |
|
6971 |
-- Name: COLUMN analytical_stem_view.family_verbatim; Type: COMMENT; Schema: public; Owner: - |
|
6972 |
-- |
|
6973 |
|
|
6974 |
COMMENT ON COLUMN analytical_stem_view.family_verbatim IS 'variant of DwC term'; |
|
6975 |
|
|
6976 |
|
|
6977 |
-- |
|
6978 |
-- Name: COLUMN analytical_stem_view."scientificName_verbatim"; Type: COMMENT; Schema: public; Owner: - |
|
6979 |
-- |
|
6980 |
|
|
6981 |
COMMENT ON COLUMN analytical_stem_view."scientificName_verbatim" IS 'variant of DwC term'; |
|
6982 |
|
|
6983 |
|
|
6984 |
-- |
|
6985 |
-- Name: COLUMN analytical_stem_view."identifiedBy"; Type: COMMENT; Schema: public; Owner: - |
|
6986 |
-- |
|
6987 |
|
|
6988 |
COMMENT ON COLUMN analytical_stem_view."identifiedBy" IS 'from DwC'; |
|
6989 |
|
|
6990 |
|
|
6991 |
-- |
|
6992 |
-- Name: COLUMN analytical_stem_view."dateIdentified"; Type: COMMENT; Schema: public; Owner: - |
|
6993 |
-- |
|
6994 |
|
|
6995 |
COMMENT ON COLUMN analytical_stem_view."dateIdentified" IS 'from DwC'; |
|
6996 |
|
|
6997 |
|
|
6998 |
-- |
|
6999 |
-- Name: COLUMN analytical_stem_view."identificationRemarks"; Type: COMMENT; Schema: public; Owner: - |
|
7000 |
-- |
|
7001 |
|
|
7002 |
COMMENT ON COLUMN analytical_stem_view."identificationRemarks" IS 'from DwC'; |
|
7003 |
|
|
7004 |
|
|
7005 |
-- |
|
7006 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: - |
|
7007 |
-- |
|
7008 |
|
|
7009 |
COMMENT ON COLUMN analytical_stem_view.taxonomic_status IS 'from DwC, renamed'; |
|
7010 |
|
|
7011 |
|
|
7012 |
-- |
|
7013 |
-- Name: COLUMN analytical_stem_view."reproductiveCondition"; Type: COMMENT; Schema: public; Owner: - |
|
7014 |
-- |
|
7015 |
|
|
7016 |
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition" IS 'from DwC'; |
|
7017 |
|
|
7018 |
|
|
7019 |
-- |
|
7020 |
-- Name: COLUMN analytical_stem_view."occurrenceRemarks"; Type: COMMENT; Schema: public; Owner: - |
|
7021 |
-- |
|
7022 |
|
|
7023 |
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks" IS 'from DwC'; |
|
7024 |
|
|
7025 |
|
|
7026 |
-- |
|
6845 | 7027 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
6846 | 7028 |
-- |
6847 | 7029 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: flagged the DwC terms