Revision 13684
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 '= country@DwC@vegpath.org; "The name of the country or major administrative unit in which the Location occurs"';
|
|
| 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 '= projectID@VegX@vegpath.org; "A reference to a specific ''project''"';
|
|
| 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 '= subplot@SALVIAS@vegpath.org; "Code for subplot, line, or any other subsample or subdivision of plot"';
|
|
| 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 |
-- |
| ... | ... | |
| 6971 | 6971 |
-- Name: COLUMN analytical_stem_view.locationevent__pkey; Type: COMMENT; Schema: public; Owner: - |
| 6972 | 6972 |
-- |
| 6973 | 6973 |
|
| 6974 |
COMMENT ON COLUMN analytical_stem_view.locationevent__pkey IS 'VegBIEN-internal';
|
|
| 6974 |
COMMENT ON COLUMN analytical_stem_view.locationevent__pkey IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org; autogenerated ID for locationevent';
|
|
| 6975 | 6975 |
|
| 6976 | 6976 |
|
| 6977 | 6977 |
-- |
| ... | ... | |
| 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 '= Family_matched@TNRS@vegpath.org; "The closest matching family in the TNRS database to the family submitted"';
|
|
| 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 '= speciesBinomialWithMorphospecies@VegCore@vegpath.org; "combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"';
|
|
| 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 '= 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."';
|
|
| 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 '= country@DwC@vegpath.org; "The name of the country or major administrative unit in which the Location occurs"';
|
|
| 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 '= projectID@VegX@vegpath.org; "A reference to a specific ''project''"';
|
|
| 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 '= subplot@SALVIAS@vegpath.org; "Code for subplot, line, or any other subsample or subdivision of plot"';
|
|
| 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 |
-- |
| ... | ... | |
| 6971 | 6971 |
-- Name: COLUMN analytical_stem_view.locationevent__pkey; Type: COMMENT; Schema: public; Owner: - |
| 6972 | 6972 |
-- |
| 6973 | 6973 |
|
| 6974 |
COMMENT ON COLUMN analytical_stem_view.locationevent__pkey IS 'VegBIEN-internal';
|
|
| 6974 |
COMMENT ON COLUMN analytical_stem_view.locationevent__pkey IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org; autogenerated ID for locationevent';
|
|
| 6975 | 6975 |
|
| 6976 | 6976 |
|
| 6977 | 6977 |
-- |
| ... | ... | |
| 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 '= Family_matched@TNRS@vegpath.org; "The closest matching family in the TNRS database to the family submitted"';
|
|
| 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 '= speciesBinomialWithMorphospecies@VegCore@vegpath.org; "combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"';
|
|
| 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 '= 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."';
|
|
| 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
fix: schemas/public_.sql: analytical_stem_view: links: removed = before them because the link is in fact one member in a list of definitions (the = would apply to all definitions, not just the link, and since it apply to all definitions, it's redundant because of course the comment is what the column equals)