Revision 4933
Added by Aaron Marcuse-Kubitza about 12 years ago
vegbien.my.sql | ||
---|---|---|
54 | 54 |
|
55 | 55 |
|
56 | 56 |
-- |
57 |
-- Name: role; Type: TYPE; Schema: public; Owner: -
|
|
57 |
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: -
|
|
58 | 58 |
-- |
59 | 59 |
|
60 | 60 |
|
61 | 61 |
|
62 | 62 |
|
63 | 63 |
-- |
64 |
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: -
|
|
64 |
-- Name: TYPE taxonrank; Type: COMMENT; Schema: public; Owner: -
|
|
65 | 65 |
-- |
66 | 66 |
|
67 | 67 |
|
68 | 68 |
|
69 | 69 |
|
70 | 70 |
-- |
71 |
-- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: -
|
|
71 |
-- Name: rankedtaxonname; Type: TYPE; Schema: public; Owner: -
|
|
72 | 72 |
-- |
73 | 73 |
|
74 | 74 |
|
75 | 75 |
|
76 | 76 |
|
77 | 77 |
-- |
78 |
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: -
|
|
78 |
-- Name: role; Type: TYPE; Schema: public; Owner: -
|
|
79 | 79 |
-- |
80 | 80 |
|
81 | 81 |
|
82 | 82 |
|
83 | 83 |
|
84 | 84 |
-- |
85 |
-- Name: TYPE taxonrank; Type: COMMENT; Schema: public; Owner: -
|
|
85 |
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: -
|
|
86 | 86 |
-- |
87 | 87 |
|
88 | 88 |
|
89 | 89 |
|
90 | 90 |
|
91 | 91 |
-- |
92 |
-- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: - |
|
93 |
-- |
|
94 |
|
|
95 |
|
|
96 |
|
|
97 |
|
|
98 |
-- |
|
92 | 99 |
-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: - |
93 | 100 |
-- |
94 | 101 |
|
... | ... | |
840 | 847 |
variety text, |
841 | 848 |
forma text, |
842 | 849 |
cultivar text, |
850 |
otherranks text, |
|
843 | 851 |
accessioncode text |
844 | 852 |
); |
845 | 853 |
|
... | ... | |
859 | 867 |
|
860 | 868 |
|
861 | 869 |
-- |
870 |
-- Name: COLUMN taxonpath.otherranks; Type: COMMENT; Schema: public; Owner: - |
|
871 |
-- |
|
872 |
|
|
873 |
|
|
874 |
|
|
875 |
|
|
876 |
-- |
|
862 | 877 |
-- Name: analytical_db_view; Type: VIEW; Schema: public; Owner: - |
863 | 878 |
-- |
864 | 879 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonpath: Added otherranks array column to store ranked names without a named column. Documented that ranks with no named column should be stored in this new field instead of in a chain of taxons pointed to by taxon_id. This ensures that only the tree of life uses the taxon table.