Revision 4969
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 935 | 935 |
-- Name: TABLE placepath; Type: COMMENT; Schema: public; Owner: - |
| 936 | 936 |
-- |
| 937 | 937 |
|
| 938 |
COMMENT ON TABLE placepath IS 'To include a placename at a rank with no explicit column, add it to the otherranks array.';
|
|
| 938 |
COMMENT ON TABLE placepath IS 'The full path to a place. Can be either verbatim or scrubbed. For scrubbed names, points to the identified place.
|
|
| 939 | 939 |
|
| 940 |
To include a placename at a rank with no explicit column, add it to the otherranks array.'; |
|
| 940 | 941 |
|
| 942 |
|
|
| 941 | 943 |
-- |
| 942 | 944 |
-- Name: COLUMN placepath.otherranks; Type: COMMENT; Schema: public; Owner: - |
| 943 | 945 |
-- |
| ... | ... | |
| 2132 | 2134 |
-- Name: TABLE place; Type: COMMENT; Schema: public; Owner: - |
| 2133 | 2135 |
-- |
| 2134 | 2136 |
|
| 2135 |
COMMENT ON TABLE place IS 'Equivalent to VegBank''s namedPlace table.';
|
|
| 2137 |
COMMENT ON TABLE place IS 'An official, named place. Can be at any level in the geographic hierarchy. Note that the placename stores only one rank (e.g. country) of the full path to the place. The higher-level ranks are stored in the place''s chain of parent_id ancestors.
|
|
| 2136 | 2138 |
|
| 2139 |
Equivalent to VegBank''s namedPlace table.'; |
|
| 2137 | 2140 |
|
| 2141 |
|
|
| 2138 | 2142 |
-- |
| 2139 | 2143 |
-- Name: place_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2140 | 2144 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: place, placepath descriptive comments: Added analogous text from taxon/taxonpath