Revision 4971
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 2970 | 2970 |
|
| 2971 | 2971 |
|
| 2972 | 2972 |
-- |
| 2973 |
-- Name: COLUMN taxon.parent_id; Type: COMMENT; Schema: public; Owner: - |
|
| 2974 |
-- |
|
| 2975 |
|
|
| 2976 |
COMMENT ON COLUMN taxon.parent_id IS 'The parent taxon.'; |
|
| 2977 |
|
|
| 2978 |
|
|
| 2979 |
-- |
|
| 2973 | 2980 |
-- Name: COLUMN taxon.rank; Type: COMMENT; Schema: public; Owner: - |
| 2974 | 2981 |
-- |
| 2975 | 2982 |
|
| 2976 |
COMMENT ON COLUMN taxon.rank IS 'Even if you specify a custom verbatimrank, you must also specify a closest-match rank from the taxonrank closed list.'; |
|
| 2983 |
COMMENT ON COLUMN taxon.rank IS 'The taxon''s level in the taxonomic hierarchy, standardized to a closed list. Even if you specify a custom verbatimrank, you must also specify a closest-match rank from the taxonrank closed list.';
|
|
| 2977 | 2984 |
|
| 2978 | 2985 |
|
| 2979 | 2986 |
-- |
| 2987 |
-- Name: COLUMN taxon.verbatimrank; Type: COMMENT; Schema: public; Owner: - |
|
| 2988 |
-- |
|
| 2989 |
|
|
| 2990 |
COMMENT ON COLUMN taxon.verbatimrank IS 'The taxon''s verbatim level in the taxonomic hierarchy. Does not need to be in the taxonrank closed list.'; |
|
| 2991 |
|
|
| 2992 |
|
|
| 2993 |
-- |
|
| 2994 |
-- Name: COLUMN taxon.taxonname; Type: COMMENT; Schema: public; Owner: - |
|
| 2995 |
-- |
|
| 2996 |
|
|
| 2997 |
COMMENT ON COLUMN taxon.taxonname IS 'The name of the taxon within its parent taxon. Contains only the lowest-rank portion of the taxonomic name. (The higher-level ranks are stored in the taxon''s chain of parent_id ancestors.)'; |
|
| 2998 |
|
|
| 2999 |
|
|
| 3000 |
-- |
|
| 2980 | 3001 |
-- Name: COLUMN taxon.author_id; Type: COMMENT; Schema: public; Owner: - |
| 2981 | 3002 |
-- |
| 2982 | 3003 |
|
| 2983 |
COMMENT ON COLUMN taxon.author_id IS 'The author of the taxon name'; |
|
| 3004 |
COMMENT ON COLUMN taxon.author_id IS 'The author of the taxon name.';
|
|
| 2984 | 3005 |
|
| 2985 | 3006 |
|
| 2986 | 3007 |
-- |
| 2987 | 3008 |
-- Name: COLUMN taxon.authority_id; Type: COMMENT; Schema: public; Owner: - |
| 2988 | 3009 |
-- |
| 2989 | 3010 |
|
| 2990 |
COMMENT ON COLUMN taxon.authority_id IS 'The authority which defines the taxon name'; |
|
| 3011 |
COMMENT ON COLUMN taxon.authority_id IS 'The authority which defines the taxon name.';
|
|
| 2991 | 3012 |
|
| 2992 | 3013 |
|
| 2993 | 3014 |
-- |
| 3015 |
-- Name: COLUMN taxon.description; Type: COMMENT; Schema: public; Owner: - |
|
| 3016 |
-- |
|
| 3017 |
|
|
| 3018 |
COMMENT ON COLUMN taxon.description IS 'The authority''s description of the taxon.'; |
|
| 3019 |
|
|
| 3020 |
|
|
| 3021 |
-- |
|
| 2994 | 3022 |
-- Name: taxon_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2995 | 3023 |
-- |
| 2996 | 3024 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxon columns: Added descriptive comments for data dictionary