Project

General

Profile

« Previous | Next » 

Revision 4933

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.

View differences:

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