Revision 4971
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2417 | 2417 |
|
| 2418 | 2418 |
|
| 2419 | 2419 |
-- |
| 2420 |
-- Name: COLUMN taxon.parent_id; Type: COMMENT; Schema: public; Owner: - |
|
| 2421 |
-- |
|
| 2422 |
|
|
| 2423 |
|
|
| 2424 |
|
|
| 2425 |
|
|
| 2426 |
-- |
|
| 2420 | 2427 |
-- Name: COLUMN taxon.rank; Type: COMMENT; Schema: public; Owner: - |
| 2421 | 2428 |
-- |
| 2422 | 2429 |
|
| ... | ... | |
| 2424 | 2431 |
|
| 2425 | 2432 |
|
| 2426 | 2433 |
-- |
| 2434 |
-- Name: COLUMN taxon.verbatimrank; Type: COMMENT; Schema: public; Owner: - |
|
| 2435 |
-- |
|
| 2436 |
|
|
| 2437 |
|
|
| 2438 |
|
|
| 2439 |
|
|
| 2440 |
-- |
|
| 2441 |
-- Name: COLUMN taxon.taxonname; Type: COMMENT; Schema: public; Owner: - |
|
| 2442 |
-- |
|
| 2443 |
|
|
| 2444 |
|
|
| 2445 |
|
|
| 2446 |
|
|
| 2447 |
-- |
|
| 2427 | 2448 |
-- Name: COLUMN taxon.author_id; Type: COMMENT; Schema: public; Owner: - |
| 2428 | 2449 |
-- |
| 2429 | 2450 |
|
| ... | ... | |
| 2438 | 2459 |
|
| 2439 | 2460 |
|
| 2440 | 2461 |
-- |
| 2462 |
-- Name: COLUMN taxon.description; Type: COMMENT; Schema: public; Owner: - |
|
| 2463 |
-- |
|
| 2464 |
|
|
| 2465 |
|
|
| 2466 |
|
|
| 2467 |
|
|
| 2468 |
-- |
|
| 2441 | 2469 |
-- Name: taxon_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2442 | 2470 |
-- |
| 2443 | 2471 |
|
| schemas/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