Revision 1111
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 32 | 32 |
|
| 33 | 33 |
|
| 34 | 34 |
-- |
| 35 |
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: - |
|
| 36 |
-- |
|
| 37 |
|
|
| 38 |
CREATE TYPE taxonrank AS ENUM ( |
|
| 39 |
'Binomial', |
|
| 40 |
'Kingdom', |
|
| 41 |
'Subkingdom', |
|
| 42 |
'Superdivision', |
|
| 43 |
'Division', |
|
| 44 |
'Class', |
|
| 45 |
'Subclass', |
|
| 46 |
'Order', |
|
| 47 |
'Suborder', |
|
| 48 |
'Family', |
|
| 49 |
'Subfamily', |
|
| 50 |
'Tribe', |
|
| 51 |
'Subtribe', |
|
| 52 |
'Genus', |
|
| 53 |
'Subgenus', |
|
| 54 |
'Section', |
|
| 55 |
'Species Aggregate', |
|
| 56 |
'Species', |
|
| 57 |
'Subspecies', |
|
| 58 |
'Authority', |
|
| 59 |
'Variety', |
|
| 60 |
'Cultivar/Forma' |
|
| 61 |
); |
|
| 62 |
|
|
| 63 |
|
|
| 64 |
-- |
|
| 35 | 65 |
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: - |
| 36 | 66 |
-- |
| 37 | 67 |
|
| ... | ... | |
| 1756 | 1786 |
plantname_id integer NOT NULL, |
| 1757 | 1787 |
plantname text NOT NULL, |
| 1758 | 1788 |
reference_id integer, |
| 1759 |
dateentered timestamp with time zone DEFAULT now() |
|
| 1789 |
dateentered timestamp with time zone DEFAULT now(), |
|
| 1790 |
rank taxonrank NOT NULL |
|
| 1760 | 1791 |
); |
| 1761 | 1792 |
|
| 1762 | 1793 |
|
| ... | ... | |
| 1830 | 1861 |
plantstatus_id integer NOT NULL, |
| 1831 | 1862 |
plantconcept_id integer NOT NULL, |
| 1832 | 1863 |
party_id integer, |
| 1833 |
plantlevel text, |
|
| 1834 | 1864 |
plantparent_id integer, |
| 1835 | 1865 |
plantconceptstatus text DEFAULT 'undetermined'::text NOT NULL, |
| 1836 | 1866 |
reference_id integer, |
| ... | ... | |
| 4840 | 4870 |
|
| 4841 | 4871 |
|
| 4842 | 4872 |
-- |
| 4843 |
-- Name: plantstatus_plantlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4844 |
-- |
|
| 4845 |
|
|
| 4846 |
CREATE INDEX plantstatus_plantlevel_x ON plantstatus USING btree (plantlevel); |
|
| 4847 |
|
|
| 4848 |
|
|
| 4849 |
-- |
|
| 4850 | 4873 |
-- Name: plantstatus_plantparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4851 | 4874 |
-- |
| 4852 | 4875 |
|
Also available in: Unified diff
VegBIEN: Moved plantstatus.plantlevel to plantname.rank because the taxonomic rank is a property of the name itself