Revision 13693
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 6852 | 6852 |
-- Name: COLUMN analytical_stem_view."country@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 6853 | 6853 |
-- |
| 6854 | 6854 |
|
| 6855 |
COMMENT ON COLUMN analytical_stem_view."country@DwC@vegpath.org" IS '"The name of the country or major administrative unit in which the Location occurs"'; |
|
| 6855 |
COMMENT ON COLUMN analytical_stem_view."country@DwC@vegpath.org" IS 'geoscrub.geoscrub_output.acceptedCountry@VegBIEN@vegpath.org; |
|
| 6856 |
"The name of the country or major administrative unit in which the Location occurs"'; |
|
| 6856 | 6857 |
|
| 6857 | 6858 |
|
| 6858 | 6859 |
-- |
| ... | ... | |
| 6929 | 6930 |
-- Name: COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 6930 | 6931 |
-- |
| 6931 | 6932 |
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org" IS '"A reference to a specific ''project''"'; |
|
| 6933 |
COMMENT ON COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org" IS 'project.sourceaccessioncode@VegBIEN.public@vegpath.org; |
|
| 6934 |
"A reference to a specific ''project''"'; |
|
| 6933 | 6935 |
|
| 6934 | 6936 |
|
| 6935 | 6937 |
-- |
| ... | ... | |
| 6957 | 6959 |
-- Name: COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 6958 | 6960 |
-- |
| 6959 | 6961 |
|
| 6960 |
COMMENT ON COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org" IS '"Code for subplot, line, or any other subsample or subdivision of plot"'; |
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org; |
|
| 6963 |
"Code for subplot, line, or any other subsample or subdivision of plot"'; |
|
| 6961 | 6964 |
|
| 6962 | 6965 |
|
| 6963 | 6966 |
-- |
| ... | ... | |
| 6971 | 6974 |
-- Name: COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 6972 | 6975 |
-- |
| 6973 | 6976 |
|
| 6974 |
COMMENT ON COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org" IS 'autogenerated ID for locationevent'; |
|
| 6977 |
COMMENT ON COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org" IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org; |
|
| 6978 |
autogenerated ID for locationevent'; |
|
| 6975 | 6979 |
|
| 6976 | 6980 |
|
| 6977 | 6981 |
-- |
| ... | ... | |
| 7139 | 7143 |
-- Name: COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 7140 | 7144 |
-- |
| 7141 | 7145 |
|
| 7142 |
COMMENT ON COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org" IS '"The closest matching family in the TNRS database to the family submitted"'; |
|
| 7146 |
COMMENT ON COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org" IS 'TNRS.taxon_scrub.matchedFamily@VegBIEN.public@vegpath.org; |
|
| 7147 |
"The closest matching family in the TNRS database to the family submitted"'; |
|
| 7143 | 7148 |
|
| 7144 | 7149 |
|
| 7145 | 7150 |
-- |
| ... | ... | |
| 7223 | 7228 |
-- Name: COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 7224 | 7229 |
-- |
| 7225 | 7230 |
|
| 7226 |
COMMENT ON COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org" IS '"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"'; |
|
| 7231 |
COMMENT ON COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org" IS 'TNRS.taxon_scrub.scrubbed_morphospecies_binomial@VegBIEN.public@vegpath.org; |
|
| 7232 |
"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"'; |
|
| 7227 | 7233 |
|
| 7228 | 7234 |
|
| 7229 | 7235 |
-- |
| ... | ... | |
| 7356 | 7362 |
-- Name: COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 7357 | 7363 |
-- |
| 7358 | 7364 |
|
| 7359 |
COMMENT ON COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org" IS '"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."'; |
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org; |
|
| 7366 |
"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 | 7367 |
|
| 7361 | 7368 |
|
| 7362 | 7369 |
-- |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 6852 | 6852 |
-- Name: COLUMN analytical_stem_view."country@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 6853 | 6853 |
-- |
| 6854 | 6854 |
|
| 6855 |
COMMENT ON COLUMN analytical_stem_view."country@DwC@vegpath.org" IS '"The name of the country or major administrative unit in which the Location occurs"'; |
|
| 6855 |
COMMENT ON COLUMN analytical_stem_view."country@DwC@vegpath.org" IS 'geoscrub.geoscrub_output.acceptedCountry@VegBIEN@vegpath.org; |
|
| 6856 |
"The name of the country or major administrative unit in which the Location occurs"'; |
|
| 6856 | 6857 |
|
| 6857 | 6858 |
|
| 6858 | 6859 |
-- |
| ... | ... | |
| 6929 | 6930 |
-- Name: COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 6930 | 6931 |
-- |
| 6931 | 6932 |
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org" IS '"A reference to a specific ''project''"'; |
|
| 6933 |
COMMENT ON COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org" IS 'project.sourceaccessioncode@VegBIEN.public@vegpath.org; |
|
| 6934 |
"A reference to a specific ''project''"'; |
|
| 6933 | 6935 |
|
| 6934 | 6936 |
|
| 6935 | 6937 |
-- |
| ... | ... | |
| 6957 | 6959 |
-- Name: COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 6958 | 6960 |
-- |
| 6959 | 6961 |
|
| 6960 |
COMMENT ON COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org" IS '"Code for subplot, line, or any other subsample or subdivision of plot"'; |
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org; |
|
| 6963 |
"Code for subplot, line, or any other subsample or subdivision of plot"'; |
|
| 6961 | 6964 |
|
| 6962 | 6965 |
|
| 6963 | 6966 |
-- |
| ... | ... | |
| 6971 | 6974 |
-- Name: COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 6972 | 6975 |
-- |
| 6973 | 6976 |
|
| 6974 |
COMMENT ON COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org" IS 'autogenerated ID for locationevent'; |
|
| 6977 |
COMMENT ON COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org" IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org; |
|
| 6978 |
autogenerated ID for locationevent'; |
|
| 6975 | 6979 |
|
| 6976 | 6980 |
|
| 6977 | 6981 |
-- |
| ... | ... | |
| 7139 | 7143 |
-- Name: COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 7140 | 7144 |
-- |
| 7141 | 7145 |
|
| 7142 |
COMMENT ON COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org" IS '"The closest matching family in the TNRS database to the family submitted"'; |
|
| 7146 |
COMMENT ON COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org" IS 'TNRS.taxon_scrub.matchedFamily@VegBIEN.public@vegpath.org; |
|
| 7147 |
"The closest matching family in the TNRS database to the family submitted"'; |
|
| 7143 | 7148 |
|
| 7144 | 7149 |
|
| 7145 | 7150 |
-- |
| ... | ... | |
| 7223 | 7228 |
-- Name: COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 7224 | 7229 |
-- |
| 7225 | 7230 |
|
| 7226 |
COMMENT ON COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org" IS '"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"'; |
|
| 7231 |
COMMENT ON COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org" IS 'TNRS.taxon_scrub.scrubbed_morphospecies_binomial@VegBIEN.public@vegpath.org; |
|
| 7232 |
"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"'; |
|
| 7227 | 7233 |
|
| 7228 | 7234 |
|
| 7229 | 7235 |
-- |
| ... | ... | |
| 7356 | 7362 |
-- Name: COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 7357 | 7363 |
-- |
| 7358 | 7364 |
|
| 7359 |
COMMENT ON COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org" IS '"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."'; |
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org; |
|
| 7366 |
"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 | 7367 |
|
| 7361 | 7368 |
|
| 7362 | 7369 |
-- |
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: example terms from each source: added location in the VegBIEN core DB