Revision 4728
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 1125 | 1125 |
|
| 1126 | 1126 |
|
| 1127 | 1127 |
-- |
| 1128 |
-- Name: TABLE taxonpath; Type: COMMENT; Schema: public; Owner: - |
|
| 1129 |
-- |
|
| 1130 |
|
|
| 1131 |
COMMENT ON TABLE taxonpath IS 'To include a taxon name at a rank with no explicit column, create a taxon for it and point to it using taxon_id. To include multiple such names, chain the taxons together using parent_id, as a form of ordered linked list. Note that lower-level taxa should point to higher-level taxa.'; |
|
| 1132 |
|
|
| 1133 |
|
|
| 1134 |
-- |
|
| 1128 | 1135 |
-- Name: COLUMN taxonpath.scientificnamewithauthor; Type: COMMENT; Schema: public; Owner: - |
| 1129 | 1136 |
-- |
| 1130 | 1137 |
|
| ... | ... | |
| 2931 | 2938 |
-- Name: TABLE taxon; Type: COMMENT; Schema: public; Owner: - |
| 2932 | 2939 |
-- |
| 2933 | 2940 |
|
| 2934 |
COMMENT ON TABLE taxon IS 'VegBank''s plantConcept table. |
|
| 2941 |
COMMENT ON TABLE taxon IS 'VegBank''s plantConcept table.';
|
|
| 2935 | 2942 |
|
| 2936 |
To include a taxon name at a rank with no explicit column, create a taxon for it and point to it using taxon_id. To include multiple such names, chain the taxons together using parent_id, as a form of ordered linked list. Note that lower-level taxa should point to higher-level taxa.'; |
|
| 2937 | 2943 |
|
| 2938 |
|
|
| 2939 | 2944 |
-- |
| 2940 | 2945 |
-- Name: COLUMN taxon.rank; Type: COMMENT; Schema: public; Owner: - |
| 2941 | 2946 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: Moved steps to include a taxon name at a rank with no explicit column from taxon's comment to taxonpath's comment, because that is the table the steps apply to