Revision 13663
Added by Aaron Marcuse-Kubitza over 10 years ago
vegbien.sql | ||
---|---|---|
6852 | 6852 |
-- Name: COLUMN analytical_stem_view.country; Type: COMMENT; Schema: public; Owner: - |
6853 | 6853 |
-- |
6854 | 6854 |
|
6855 |
COMMENT ON COLUMN analytical_stem_view.country IS 'from DwC';
|
|
6855 |
COMMENT ON COLUMN analytical_stem_view.country IS '= country@DwC@vegpath.org// : "The name of the country or major administrative unit in which the Location occurs"';
|
|
6856 | 6856 |
|
6857 | 6857 |
|
6858 | 6858 |
-- |
... | ... | |
6929 | 6929 |
-- Name: COLUMN analytical_stem_view."projectID"; Type: COMMENT; Schema: public; Owner: - |
6930 | 6930 |
-- |
6931 | 6931 |
|
6932 |
COMMENT ON COLUMN analytical_stem_view."projectID" IS 'from VegX';
|
|
6932 |
COMMENT ON COLUMN analytical_stem_view."projectID" IS '= projectID@VegX@vegpath.org// : "A reference to a specific ''project''"';
|
|
6933 | 6933 |
|
6934 | 6934 |
|
6935 | 6935 |
-- |
... | ... | |
6957 | 6957 |
-- Name: COLUMN analytical_stem_view.subplot; Type: COMMENT; Schema: public; Owner: - |
6958 | 6958 |
-- |
6959 | 6959 |
|
6960 |
COMMENT ON COLUMN analytical_stem_view.subplot IS 'from SALVIAS';
|
|
6960 |
COMMENT ON COLUMN analytical_stem_view.subplot IS '= subplot@SALVIAS@vegpath.org// : "Code for subplot, line, or any other subsample or subdivision of plot"';
|
|
6961 | 6961 |
|
6962 | 6962 |
|
6963 | 6963 |
-- |
... | ... | |
7139 | 7139 |
-- Name: COLUMN analytical_stem_view.family_matched; Type: COMMENT; Schema: public; Owner: - |
7140 | 7140 |
-- |
7141 | 7141 |
|
7142 |
COMMENT ON COLUMN analytical_stem_view.family_matched IS 'from TNRS, renamed';
|
|
7142 |
COMMENT ON COLUMN analytical_stem_view.family_matched IS '= Family_matched@TNRS@vegpath.org// : "The closest matching family in the TNRS database to the family submitted"';
|
|
7143 | 7143 |
|
7144 | 7144 |
|
7145 | 7145 |
-- |
... | ... | |
7223 | 7223 |
-- Name: COLUMN analytical_stem_view.scrubbed_morphospecies_binomial; Type: COMMENT; Schema: public; Owner: - |
7224 | 7224 |
-- |
7225 | 7225 |
|
7226 |
COMMENT ON COLUMN analytical_stem_view.scrubbed_morphospecies_binomial IS 'derived column';
|
|
7226 |
COMMENT ON COLUMN analytical_stem_view.scrubbed_morphospecies_binomial IS '= speciesBinomialWithMorphospecies@VegCore@vegpath.org// : "combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"';
|
|
7227 | 7227 |
|
7228 | 7228 |
|
7229 | 7229 |
-- |
... | ... | |
7356 | 7356 |
-- Name: COLUMN analytical_stem_view."authorStemCode"; Type: COMMENT; Schema: public; Owner: - |
7357 | 7357 |
-- |
7358 | 7358 |
|
7359 |
COMMENT ON COLUMN analytical_stem_view."authorStemCode" IS 'from VegBank, renamed';
|
|
7359 |
COMMENT ON COLUMN analytical_stem_view."authorStemCode" IS '= stemCode@stemlocation@VegBank@vegpath.org// : "Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a field data entry with a stem in the database."';
|
|
7360 | 7360 |
|
7361 | 7361 |
|
7362 | 7362 |
-- |
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: added links and definitions for half a dozen of the terms from various sources