Project

General

Profile

« Previous | Next » 

Revision 4956

schemas/vegbien.sql: VegBank-equivalent tables comments: Prepended "Equivalent to" before VegBank, so the equivalent tables statement can fit grammatically after a description of the table instead of having to be the first phrase in the descriptive table comment

View differences:

vegbien.sql
459 459
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
460 460
--
461 461

  
462
COMMENT ON TABLE aggregateoccurrence IS 'VegBank''s taxonimportance table.';
462
COMMENT ON TABLE aggregateoccurrence IS 'Equivalent to VegBank''s taxonimportance table.';
463 463

  
464 464

  
465 465
--
......
551 551
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
552 552
--
553 553

  
554
COMMENT ON TABLE location IS 'VegBank''s plot table.';
554
COMMENT ON TABLE location IS 'Equivalent to VegBank''s plot table.';
555 555

  
556 556

  
557 557
--
......
679 679
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
680 680
--
681 681

  
682
COMMENT ON TABLE locationevent IS 'VegBank''s observation table.';
682
COMMENT ON TABLE locationevent IS 'Equivalent to VegBank''s observation table.';
683 683

  
684 684

  
685 685
--
......
698 698
-- Name: TABLE locationplace; Type: COMMENT; Schema: public; Owner: -
699 699
--
700 700

  
701
COMMENT ON TABLE locationplace IS 'VegBank''s place table.';
701
COMMENT ON TABLE locationplace IS 'Equivalent to VegBank''s place table.';
702 702

  
703 703

  
704 704
--
......
997 997
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
998 998
--
999 999

  
1000
COMMENT ON TABLE plantobservation IS 'VegBank''s stemcount table.';
1000
COMMENT ON TABLE plantobservation IS 'Equivalent to VegBank''s stemcount table.';
1001 1001

  
1002 1002

  
1003 1003
--
......
1077 1077
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
1078 1078
--
1079 1079

  
1080
COMMENT ON TABLE taxondetermination IS 'VegBank''s taxoninterpretation table.';
1080
COMMENT ON TABLE taxondetermination IS 'Equivalent to VegBank''s taxoninterpretation table.';
1081 1081

  
1082 1082

  
1083 1083
--
......
1103 1103
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
1104 1104
--
1105 1105

  
1106
COMMENT ON TABLE taxonoccurrence IS 'VegBank''s taxonobservation table.';
1106
COMMENT ON TABLE taxonoccurrence IS 'Equivalent to VegBank''s taxonobservation table.';
1107 1107

  
1108 1108

  
1109 1109
--
......
2045 2045
-- Name: TABLE place; Type: COMMENT; Schema: public; Owner: -
2046 2046
--
2047 2047

  
2048
COMMENT ON TABLE place IS 'VegBank''s namedPlace table.';
2048
COMMENT ON TABLE place IS 'Equivalent to VegBank''s namedPlace table.';
2049 2049

  
2050 2050

  
2051 2051
--
......
2878 2878
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
2879 2879
--
2880 2880

  
2881
COMMENT ON TABLE stemobservation IS 'VegBank''s stemlocation table.';
2881
COMMENT ON TABLE stemobservation IS 'Equivalent to VegBank''s stemlocation table.';
2882 2882

  
2883 2883

  
2884 2884
--
......
2962 2962
-- Name: TABLE taxon; Type: COMMENT; Schema: public; Owner: -
2963 2963
--
2964 2964

  
2965
COMMENT ON TABLE taxon IS 'VegBank''s plantConcept and plantName tables, plus plantParent_ID and
2965
COMMENT ON TABLE taxon IS 'Equivalent to VegBank''s plantConcept and plantName tables, plus plantParent_ID and
2966 2966
plantLevel from plantStatus.';
2967 2967

  
2968 2968

  

Also available in: Unified diff