Project

General

Profile

« Previous | Next » 

Revision 13654

schemas/public_.sql: analytical_stem_view: flagged the DwC terms

View differences:

vegbien.sql
6842 6842

  
6843 6843

  
6844 6844
--
6845
-- Name: COLUMN analytical_stem_view.datasource; Type: COMMENT; Schema: public; Owner: -
6846
--
6847

  
6848
COMMENT ON COLUMN analytical_stem_view.datasource IS 'where this database got the data; the proximate data provider';
6849

  
6850

  
6851
--
6852
-- Name: COLUMN analytical_stem_view.country; Type: COMMENT; Schema: public; Owner: -
6853
--
6854

  
6855
COMMENT ON COLUMN analytical_stem_view.country IS 'from DwC';
6856

  
6857

  
6858
--
6859
-- Name: COLUMN analytical_stem_view."stateProvince"; Type: COMMENT; Schema: public; Owner: -
6860
--
6861

  
6862
COMMENT ON COLUMN analytical_stem_view."stateProvince" IS 'from DwC';
6863

  
6864

  
6865
--
6866
-- Name: COLUMN analytical_stem_view.county; Type: COMMENT; Schema: public; Owner: -
6867
--
6868

  
6869
COMMENT ON COLUMN analytical_stem_view.county IS 'from DwC';
6870

  
6871

  
6872
--
6873
-- Name: COLUMN analytical_stem_view.locality; Type: COMMENT; Schema: public; Owner: -
6874
--
6875

  
6876
COMMENT ON COLUMN analytical_stem_view.locality IS 'from DwC';
6877

  
6878

  
6879
--
6880
-- Name: COLUMN analytical_stem_view."decimalLatitude"; Type: COMMENT; Schema: public; Owner: -
6881
--
6882

  
6883
COMMENT ON COLUMN analytical_stem_view."decimalLatitude" IS 'from DwC';
6884

  
6885

  
6886
--
6887
-- Name: COLUMN analytical_stem_view."decimalLongitude"; Type: COMMENT; Schema: public; Owner: -
6888
--
6889

  
6890
COMMENT ON COLUMN analytical_stem_view."decimalLongitude" IS 'from DwC';
6891

  
6892

  
6893
--
6894
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters"; Type: COMMENT; Schema: public; Owner: -
6895
--
6896

  
6897
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters" IS 'from DwC';
6898

  
6899

  
6900
--
6901
-- Name: COLUMN analytical_stem_view."locationID"; Type: COMMENT; Schema: public; Owner: -
6902
--
6903

  
6904
COMMENT ON COLUMN analytical_stem_view."locationID" IS 'from DwC';
6905

  
6906

  
6907
--
6908
-- Name: COLUMN analytical_stem_view."locationName"; Type: COMMENT; Schema: public; Owner: -
6909
--
6910

  
6911
COMMENT ON COLUMN analytical_stem_view."locationName" IS 'from DwC';
6912

  
6913

  
6914
--
6915
-- Name: COLUMN analytical_stem_view."eventDate"; Type: COMMENT; Schema: public; Owner: -
6916
--
6917

  
6918
COMMENT ON COLUMN analytical_stem_view."eventDate" IS 'from DwC';
6919

  
6920

  
6921
--
6922
-- Name: COLUMN analytical_stem_view."elevationInMeters"; Type: COMMENT; Schema: public; Owner: -
6923
--
6924

  
6925
COMMENT ON COLUMN analytical_stem_view."elevationInMeters" IS 'variant of DwC term';
6926

  
6927

  
6928
--
6929
-- Name: COLUMN analytical_stem_view."samplingProtocol"; Type: COMMENT; Schema: public; Owner: -
6930
--
6931

  
6932
COMMENT ON COLUMN analytical_stem_view."samplingProtocol" IS 'from DwC';
6933

  
6934

  
6935
--
6936
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: -
6937
--
6938

  
6939
COMMENT ON COLUMN analytical_stem_view.collection IS 'from DwC, renamed';
6940

  
6941

  
6942
--
6943
-- Name: COLUMN analytical_stem_view."occurrenceID"; Type: COMMENT; Schema: public; Owner: -
6944
--
6945

  
6946
COMMENT ON COLUMN analytical_stem_view."occurrenceID" IS 'from DwC';
6947

  
6948

  
6949
--
6950
-- Name: COLUMN analytical_stem_view."recordedBy"; Type: COMMENT; Schema: public; Owner: -
6951
--
6952

  
6953
COMMENT ON COLUMN analytical_stem_view."recordedBy" IS 'from DwC';
6954

  
6955

  
6956
--
6957
-- Name: COLUMN analytical_stem_view."recordNumber"; Type: COMMENT; Schema: public; Owner: -
6958
--
6959

  
6960
COMMENT ON COLUMN analytical_stem_view."recordNumber" IS 'from DwC';
6961

  
6962

  
6963
--
6964
-- Name: COLUMN analytical_stem_view."dateCollected"; Type: COMMENT; Schema: public; Owner: -
6965
--
6966

  
6967
COMMENT ON COLUMN analytical_stem_view."dateCollected" IS 'variant of DwC term';
6968

  
6969

  
6970
--
6971
-- Name: COLUMN analytical_stem_view.family_verbatim; Type: COMMENT; Schema: public; Owner: -
6972
--
6973

  
6974
COMMENT ON COLUMN analytical_stem_view.family_verbatim IS 'variant of DwC term';
6975

  
6976

  
6977
--
6978
-- Name: COLUMN analytical_stem_view."scientificName_verbatim"; Type: COMMENT; Schema: public; Owner: -
6979
--
6980

  
6981
COMMENT ON COLUMN analytical_stem_view."scientificName_verbatim" IS 'variant of DwC term';
6982

  
6983

  
6984
--
6985
-- Name: COLUMN analytical_stem_view."identifiedBy"; Type: COMMENT; Schema: public; Owner: -
6986
--
6987

  
6988
COMMENT ON COLUMN analytical_stem_view."identifiedBy" IS 'from DwC';
6989

  
6990

  
6991
--
6992
-- Name: COLUMN analytical_stem_view."dateIdentified"; Type: COMMENT; Schema: public; Owner: -
6993
--
6994

  
6995
COMMENT ON COLUMN analytical_stem_view."dateIdentified" IS 'from DwC';
6996

  
6997

  
6998
--
6999
-- Name: COLUMN analytical_stem_view."identificationRemarks"; Type: COMMENT; Schema: public; Owner: -
7000
--
7001

  
7002
COMMENT ON COLUMN analytical_stem_view."identificationRemarks" IS 'from DwC';
7003

  
7004

  
7005
--
7006
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: -
7007
--
7008

  
7009
COMMENT ON COLUMN analytical_stem_view.taxonomic_status IS 'from DwC, renamed';
7010

  
7011

  
7012
--
7013
-- Name: COLUMN analytical_stem_view."reproductiveCondition"; Type: COMMENT; Schema: public; Owner: -
7014
--
7015

  
7016
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition" IS 'from DwC';
7017

  
7018

  
7019
--
7020
-- Name: COLUMN analytical_stem_view."occurrenceRemarks"; Type: COMMENT; Schema: public; Owner: -
7021
--
7022

  
7023
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks" IS 'from DwC';
7024

  
7025

  
7026
--
6845 7027
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
6846 7028
--
6847 7029

  

Also available in: Unified diff