Revision 13663
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.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 |
-- |
| trunk/schemas/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