Project

General

Profile

« Previous | Next » 

Revision 13663

schemas/public_.sql: analytical_stem_view: added links and definitions for half a dozen of the terms from various sources

View differences:

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
--

Also available in: Unified diff