Revision 5275
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 1198 | 1198 |
-- Name: TABLE taxonconcept; Type: COMMENT; Schema: public; Owner: - |
| 1199 | 1199 |
-- |
| 1200 | 1200 |
|
| 1201 |
COMMENT ON TABLE taxonconcept IS 'A taxon concept defined by an entity. Can be either verbatim or accepted. For accepted names, also points to the identified taxon in the tree of life. |
|
| 1201 |
COMMENT ON TABLE taxonconcept IS 'A taxon concept defined by an entity. Can be at any level in the taxonomic hierarchy. Can be either verbatim or accepted. For accepted names, also points to the identified taxon in the tree of life.
|
|
| 1202 | 1202 |
|
| 1203 |
Note that taxonname stores only one rank (e.g. family) of the full taxonomic name. The higher-level ranks are stored in the taxon concept''s chain of parent_id ancestors. |
|
| 1204 |
|
|
| 1203 | 1205 |
To include a taxon name at a rank with no explicit column, create a parent taxonconcept for it and point to it using parent_id. To include multiple such names, chain the taxonconcepts together using parent_id. Note that lower-level taxa should point to higher-level taxa. |
| 1204 | 1206 |
|
| 1205 |
Equivalent to VegBank''s plantConcept table.';
|
|
| 1207 |
Equivalent to VegBank''s plantConcept and plantName tables, plus plantParent_ID and plantLevel from plantStatus.';
|
|
| 1206 | 1208 |
|
| 1207 | 1209 |
|
| 1208 | 1210 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: comment: Added info from taxon that also applies to taxonconcept