Revision 5474
Added by Aaron Marcuse-Kubitza over 12 years ago
inputs/test_taxonomic_names/_scrub/public.sql | ||
---|---|---|
451 | 451 |
ALTER FUNCTION public.taxonconcept_1_matched_concept_min_fit() OWNER TO bien; |
452 | 452 |
|
453 | 453 |
-- |
454 |
-- Name: taxonconcept_2_propagate_accepted_concept_id(); Type: FUNCTION; Schema: public; Owner: bien |
|
455 |
-- |
|
456 |
|
|
457 |
CREATE FUNCTION taxonconcept_2_propagate_accepted_concept_id() RETURNS trigger |
|
458 |
LANGUAGE plpgsql |
|
459 |
AS $$ |
|
460 |
BEGIN |
|
461 |
IF new.matched_concept_id IS NOT NULL THEN |
|
462 |
IF new.matched_concept_id = new.taxonconcept_id THEN -- self-reference |
|
463 |
new.accepted_concept_id = new.taxonconcept_id;-- make self-reference |
|
464 |
ELSE -- propagate from matched concept |
|
465 |
new.accepted_concept_id = ( |
|
466 |
SELECT accepted_concept_id |
|
467 |
FROM taxonconcept |
|
468 |
WHERE taxonconcept_id = new.matched_concept_id |
|
469 |
); |
|
470 |
END IF; |
|
471 |
END IF; |
|
472 |
RETURN new; |
|
473 |
END; |
|
474 |
$$; |
|
475 |
|
|
476 |
|
|
477 |
ALTER FUNCTION public.taxonconcept_2_propagate_accepted_concept_id() OWNER TO bien; |
|
478 |
|
|
479 |
-- |
|
454 | 480 |
-- Name: taxonconcept_update_ancestors(); Type: FUNCTION; Schema: public; Owner: bien |
455 | 481 |
-- |
456 | 482 |
|
... | ... | |
1214 | 1240 |
CREATE TABLE taxonconcept ( |
1215 | 1241 |
taxonconcept_id integer NOT NULL, |
1216 | 1242 |
creator_id integer NOT NULL, |
1243 |
sourceaccessioncode text, |
|
1217 | 1244 |
creationdate timestamp with time zone, |
1218 | 1245 |
accepted_concept_id integer, |
1219 | 1246 |
matched_concept_id integer, |
... | ... | |
1232 | 1259 |
description text, |
1233 | 1260 |
accessioncode text, |
1234 | 1261 |
CONSTRAINT taxonconcept_matched_concept_fit_fraction_range CHECK (((matched_concept_fit_fraction >= (0)::double precision) AND (matched_concept_fit_fraction <= (1)::double precision))), |
1235 |
CONSTRAINT taxonconcept_required_key CHECK ((((((taxonname IS NOT NULL) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR ((parent_id IS NOT NULL) AND ((creationdate IS NOT NULL) OR (author IS NOT NULL)))))
|
|
1262 |
CONSTRAINT taxonconcept_required_key CHECK (((((((sourceaccessioncode IS NOT NULL) OR (taxonname IS NOT NULL)) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR ((parent_id IS NOT NULL) AND ((creationdate IS NOT NULL) OR (author IS NOT NULL)))))
|
|
1236 | 1263 |
); |
1237 | 1264 |
|
1238 | 1265 |
|
... | ... | |
1261 | 1288 |
|
1262 | 1289 |
|
1263 | 1290 |
-- |
1291 |
-- Name: COLUMN taxonconcept.sourceaccessioncode; Type: COMMENT; Schema: public; Owner: bien |
|
1292 |
-- |
|
1293 |
|
|
1294 |
COMMENT ON COLUMN taxonconcept.sourceaccessioncode IS 'The datasource''s identifier for the taxonconcept.'; |
|
1295 |
|
|
1296 |
|
|
1297 |
-- |
|
1264 | 1298 |
-- Name: COLUMN taxonconcept.creationdate; Type: COMMENT; Schema: public; Owner: bien |
1265 | 1299 |
-- |
1266 | 1300 |
|
... | ... | |
1268 | 1302 |
|
1269 | 1303 |
|
1270 | 1304 |
-- |
1305 |
-- Name: COLUMN taxonconcept.accepted_concept_id; Type: COMMENT; Schema: public; Owner: bien |
|
1306 |
-- |
|
1307 |
|
|
1308 |
COMMENT ON COLUMN taxonconcept.accepted_concept_id IS 'The accepted synonym of the taxonconcept.'; |
|
1309 |
|
|
1310 |
|
|
1311 |
-- |
|
1271 | 1312 |
-- Name: COLUMN taxonconcept.matched_concept_id; Type: COMMENT; Schema: public; Owner: bien |
1272 | 1313 |
-- |
1273 | 1314 |
|
... | ... | |
4773 | 4814 |
-- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public; Owner: bien |
4774 | 4815 |
-- |
4775 | 4816 |
|
4776 |
COPY taxonconcept (taxonconcept_id, creator_id, creationdate, accepted_concept_id, matched_concept_id, matched_concept_fit_fraction, parent_id, taxonname, rank, verbatimrank, identifyingtaxonomicname, taxonomicname, author, taxonomicnamewithauthor, family, genus, species, description, accessioncode) FROM stdin; |
|
4777 |
2 1 \N \N \N \N \N Poaceae family \N \N \N \N \N \N \N \N \N \N |
|
4778 |
4 1 \N \N \N \N 2 Poa genus \N \N \N \N \N \N \N \N \N \N |
|
4779 |
6 1 \N \N \N \N 4 annua species \N \N \N \N \N \N \N \N \N \N |
|
4780 |
18 1 \N \N 18 \N 6 \N species species Poa annua L. Poa annua L. \N Poaceae Poa annua \N \N |
|
4781 |
54 1 \N \N \N \N 6 annua variety variety \N \N \N \N \N \N \N \N \N |
|
4782 |
56 1 \N \N 56 \N 54 \N variety variety Poa annua var. annua Poa annua var. annua \N \N Poaceae Poa annua \N \N |
|
4783 |
82 1 \N \N \N \N 4 infirma species \N \N \N \N \N \N \N \N \N \N |
|
4784 |
94 1 \N \N 94 \N 82 \N species species Poa infirma Kunth Poa infirma Kunth \N Poaceae Poa infirma \N \N |
|
4785 |
132 1 \N \N 132 \N \N \N family family Asteraceae Asteraceae \N \N \N \N \N \N \N |
|
4786 |
152 1 \N \N 132 1 \N Bercht. & J. Presl \N \N Asteraceae Bercht. & J. Presl Asteraceae \N \N Asteraceae \N \N \N \N |
|
4787 |
154 1 \N \N \N \N \N Compositae family \N \N \N \N \N \N \N \N \N \N |
|
4788 |
172 1 \N \N \N \N \N Asteraceae family \N \N \N \N \N \N \N \N \N \N |
|
4789 |
170 1 \N \N 152 \N 154 \N family family Compositae Giseke Compositae Giseke \N Compositae \N \N \N \N |
|
4790 |
190 1 \N \N 170 1 \N indet. sp.1 \N \N Compositae indet. sp.1 Compositae \N \N Compositae \N \N \N \N |
|
4791 |
192 1 \N \N \N \N \N Fabaceae family \N \N \N \N \N \N \N \N \N \N |
|
4792 |
208 1 \N \N 208 \N 192 \N family family Fabaceae Lindl. Fabaceae Lindl. \N Fabaceae \N \N \N \N |
|
4793 |
228 1 \N \N 208 1 \N Boyle#6500 \N \N Fabaceae Boyle#6500 Fabaceae \N \N Fabaceae \N \N \N \N |
|
4794 |
232 1 \N \N \N \N 192 Inga genus \N \N \N \N \N \N \N \N \N \N |
|
4795 |
246 1 \N \N 246 \N 232 \N genus genus Inga Mill. Inga Mill. \N Fabaceae Inga \N \N \N |
|
4796 |
266 1 \N \N 246 1 \N "fuzzy leaf" \N \N Fabaceae Inga "fuzzy leaf" Inga \N \N Fabaceae Inga \N \N \N |
|
4797 |
304 1 \N \N 246 1 \N sp.3 \N \N Fabaceae Inga sp.3 Inga \N \N Fabaceae Inga \N \N \N |
|
4798 |
342 1 \N \N 208 1 \N unknown #2 \N \N Fabaceae unknown #2 Fabaceae \N \N Fabaceae \N \N \N \N |
|
4799 |
380 1 \N \N 18 1 \N \N \N \N Poa annua Poa annua \N \N \N Poa annua \N \N |
|
4800 |
396 1 \N \N \N \N 6 lanuginosa forma forma \N \N \N \N \N \N \N \N \N |
|
4801 |
398 1 \N \N 56 \N 396 \N forma forma Poa annua fo. lanuginosa Sennen Poa annua fo. lanuginosa Sennen \N Poaceae Poa annua \N \N |
|
4802 |
418 1 \N \N 398 1 \N \N \N fo. Poa annua fo. lanuginosa Poa annua fo. lanuginosa \N \N \N Poa annua \N \N |
|
4803 |
434 1 \N \N \N \N 6 exilis subspecies subspecies \N \N \N \N \N \N \N \N \N |
|
4804 |
436 1 \N \N 94 \N 434 \N subspecies subspecies Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn. Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn. \N Poaceae Poa annua \N \N |
|
4805 |
456 1 \N \N 436 1 \N \N \N subsp. Poa annua ssp. exilis Poa annua subsp. exilis \N \N \N Poa annua \N \N |
|
4806 |
494 1 \N \N 436 1 \N \N \N subsp. Poa annua subsp. exilis Poa annua subsp. exilis \N \N \N Poa annua \N \N |
|
4807 |
510 1 \N \N \N \N 6 minima subvariety subvariety \N \N \N \N \N \N \N \N \N |
|
4808 |
512 1 \N \N 512 \N 510 \N subvariety subvariety Poa annua subvar. minima (Schur) Asch. & Graebn. Poa annua subvar. minima (Schur) Asch. & Graebn. \N Poaceae Poa annua \N \N |
|
4809 |
532 1 \N \N 512 1 \N \N \N subvar. Poa annua subvar. minima Poa annua subvar. minima \N \N \N Poa annua \N \N |
|
4810 |
548 1 \N \N \N \N 6 eriolepis variety variety \N \N \N \N \N \N \N \N \N |
|
4811 |
550 1 \N \N 18 \N 548 \N variety variety Poa annua var. eriolepis E. Desv. Poa annua var. eriolepis E. Desv. \N Poaceae Poa annua \N \N |
|
4812 |
570 1 \N \N 550 1 \N \N \N var. Poa annua var. eriolepis Poa annua var. eriolepis \N \N \N Poa annua \N \N |
|
4813 |
572 1 \N \N \N \N \N Caryophyllaceae family \N \N \N \N \N \N \N \N \N \N |
|
4814 |
574 1 \N \N \N \N 572 Silene genus \N \N \N \N \N \N \N \N \N \N |
|
4815 |
576 1 \N \N \N \N 574 scouleri species \N \N \N \N \N \N \N \N \N \N |
|
4816 |
586 1 \N \N \N \N 576 pringlei subspecies subspecies \N \N \N \N \N \N \N \N \N |
|
4817 |
588 1 \N \N 588 \N 586 \N subspecies subspecies Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire \N Caryophyllaceae Silene scouleri \N \N |
|
4818 |
608 1 \N \N 588 1 \N var. grisea \N subsp. Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei \N \N \N Silene scouleri \N \N |
|
4819 |
646 1 \N \N 588 1 \N var. grisea \N subsp. Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei \N \N \N Silene scouleri \N \N |
|
4820 |
664 1 \N \N \N \N \N \N \N \N No suitable matches found. No suitable matches found. \N \N \N \N \N \N \N |
|
4821 |
684 1 \N \N \N \N \N \N \N \N Fam_indet. Boyle#6501 No suitable matches found. \N \N \N \N \N \N \N |
|
4822 |
725 2 \N \N 380 \N \N \N \N \N \N Poa annua \N \N \N \N \N \N \N |
|
4823 |
728 2 \N \N 18 \N \N \N \N \N \N Poa annua L. \N \N \N \N \N \N \N |
|
4824 |
731 2 \N \N 570 \N \N \N \N \N \N Poa annua var. eriolepis \N \N \N \N \N \N \N |
|
4825 |
734 2 \N \N 494 \N \N \N \N \N \N Poa annua subsp. exilis \N \N \N \N \N \N \N |
|
4826 |
737 2 \N \N 456 \N \N \N \N \N \N Poa annua ssp. exilis \N \N \N \N \N \N \N |
|
4827 |
740 2 \N \N 532 \N \N \N \N \N \N Poa annua subvar. minima \N \N \N \N \N \N \N |
|
4828 |
743 2 \N \N 418 \N \N \N \N \N \N Poa annua fo. lanuginosa \N \N \N \N \N \N \N |
|
4829 |
746 2 \N \N 646 \N \N \N \N \N \N Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire \N \N \N \N \N \N \N |
|
4830 |
749 2 \N \N 608 \N \N \N \N \N \N Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire \N \N \N \N \N \N \N |
|
4831 |
752 2 \N \N 304 \N \N \N \N \N \N Fabaceae Inga sp.3 \N \N \N \N \N \N \N |
|
4832 |
755 2 \N \N 266 \N \N \N \N \N \N Fabaceae Inga "fuzzy leaf" \N \N \N \N \N \N \N |
|
4833 |
758 2 \N \N 342 \N \N \N \N \N \N Fabaceae unknown #2 \N \N \N \N \N \N \N |
|
4834 |
761 2 \N \N 228 \N \N \N \N \N \N Fabaceae Boyle#6500 \N \N \N \N \N \N \N |
|
4835 |
764 2 \N \N 684 \N \N \N \N \N \N Fam_indet. Boyle#6501 \N \N \N \N \N \N \N |
|
4836 |
767 2 \N \N 190 \N \N \N \N \N \N Compositae indet. sp.1 \N \N \N \N \N \N \N |
|
4817 |
COPY taxonconcept (taxonconcept_id, creator_id, sourceaccessioncode, creationdate, accepted_concept_id, matched_concept_id, matched_concept_fit_fraction, parent_id, taxonname, rank, verbatimrank, identifyingtaxonomicname, taxonomicname, author, taxonomicnamewithauthor, family, genus, species, description, accessioncode) FROM stdin;
|
|
4818 |
2 1 \N \N \N \N \N \N Poaceae family \N \N \N \N \N \N \N \N \N \N
|
|
4819 |
4 1 \N \N \N \N \N 2 Poa genus \N \N \N \N \N \N \N \N \N \N
|
|
4820 |
6 1 \N \N \N \N \N 4 annua species \N \N \N \N \N \N \N \N \N \N
|
|
4821 |
18 1 \N \N 18 18 \N 6 \N species species Poa annua L. Poa annua L. \N Poaceae Poa annua \N \N
|
|
4822 |
54 1 \N \N \N \N \N 6 annua variety variety \N \N \N \N \N \N \N \N \N
|
|
4823 |
56 1 \N \N 56 56 \N 54 \N variety variety Poa annua var. annua Poa annua var. annua \N \N Poaceae Poa annua \N \N
|
|
4824 |
82 1 \N \N \N \N \N 4 infirma species \N \N \N \N \N \N \N \N \N \N
|
|
4825 |
94 1 \N \N 94 94 \N 82 \N species species Poa infirma Kunth Poa infirma Kunth \N Poaceae Poa infirma \N \N
|
|
4826 |
132 1 \N \N 132 132 \N \N \N family family Asteraceae Asteraceae \N \N \N \N \N \N \N
|
|
4827 |
152 1 \N \N 132 132 1 \N Bercht. & J. Presl \N \N Asteraceae Bercht. & J. Presl Asteraceae \N \N Asteraceae \N \N \N \N
|
|
4828 |
154 1 \N \N \N \N \N \N Compositae family \N \N \N \N \N \N \N \N \N \N
|
|
4829 |
172 1 \N \N \N \N \N \N Asteraceae family \N \N \N \N \N \N \N \N \N \N
|
|
4830 |
170 1 \N \N 132 152 \N 154 \N family family Compositae Giseke Compositae Giseke \N Compositae \N \N \N \N
|
|
4831 |
190 1 \N \N 132 170 1 \N indet. sp.1 \N \N Compositae indet. sp.1 Compositae \N \N Compositae \N \N \N \N
|
|
4832 |
192 1 \N \N \N \N \N \N Fabaceae family \N \N \N \N \N \N \N \N \N \N
|
|
4833 |
208 1 \N \N 208 208 \N 192 \N family family Fabaceae Lindl. Fabaceae Lindl. \N Fabaceae \N \N \N \N
|
|
4834 |
228 1 \N \N 208 208 1 \N Boyle#6500 \N \N Fabaceae Boyle#6500 Fabaceae \N \N Fabaceae \N \N \N \N
|
|
4835 |
232 1 \N \N \N \N \N 192 Inga genus \N \N \N \N \N \N \N \N \N \N
|
|
4836 |
246 1 \N \N 246 246 \N 232 \N genus genus Inga Mill. Inga Mill. \N Fabaceae Inga \N \N \N
|
|
4837 |
266 1 \N \N 246 246 1 \N "fuzzy leaf" \N \N Fabaceae Inga "fuzzy leaf" Inga \N \N Fabaceae Inga \N \N \N
|
|
4838 |
304 1 \N \N 246 246 1 \N sp.3 \N \N Fabaceae Inga sp.3 Inga \N \N Fabaceae Inga \N \N \N
|
|
4839 |
342 1 \N \N 208 208 1 \N unknown #2 \N \N Fabaceae unknown #2 Fabaceae \N \N Fabaceae \N \N \N \N
|
|
4840 |
380 1 \N \N 18 18 1 \N \N \N \N Poa annua Poa annua \N \N \N Poa annua \N \N
|
|
4841 |
396 1 \N \N \N \N \N 6 lanuginosa forma forma \N \N \N \N \N \N \N \N \N
|
|
4842 |
398 1 \N \N 56 56 \N 396 \N forma forma Poa annua fo. lanuginosa Sennen Poa annua fo. lanuginosa Sennen \N Poaceae Poa annua \N \N
|
|
4843 |
418 1 \N \N 56 398 1 \N \N \N fo. Poa annua fo. lanuginosa Poa annua fo. lanuginosa \N \N \N Poa annua \N \N
|
|
4844 |
434 1 \N \N \N \N \N 6 exilis subspecies subspecies \N \N \N \N \N \N \N \N \N
|
|
4845 |
436 1 \N \N 94 94 \N 434 \N subspecies subspecies Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn. Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn. \N Poaceae Poa annua \N \N
|
|
4846 |
456 1 \N \N 94 436 1 \N \N \N subsp. Poa annua ssp. exilis Poa annua subsp. exilis \N \N \N Poa annua \N \N
|
|
4847 |
494 1 \N \N 94 436 1 \N \N \N subsp. Poa annua subsp. exilis Poa annua subsp. exilis \N \N \N Poa annua \N \N
|
|
4848 |
510 1 \N \N \N \N \N 6 minima subvariety subvariety \N \N \N \N \N \N \N \N \N
|
|
4849 |
512 1 \N \N 512 512 \N 510 \N subvariety subvariety Poa annua subvar. minima (Schur) Asch. & Graebn. Poa annua subvar. minima (Schur) Asch. & Graebn. \N Poaceae Poa annua \N \N
|
|
4850 |
532 1 \N \N 512 512 1 \N \N \N subvar. Poa annua subvar. minima Poa annua subvar. minima \N \N \N Poa annua \N \N
|
|
4851 |
548 1 \N \N \N \N \N 6 eriolepis variety variety \N \N \N \N \N \N \N \N \N
|
|
4852 |
550 1 \N \N 18 18 \N 548 \N variety variety Poa annua var. eriolepis E. Desv. Poa annua var. eriolepis E. Desv. \N Poaceae Poa annua \N \N
|
|
4853 |
570 1 \N \N 18 550 1 \N \N \N var. Poa annua var. eriolepis Poa annua var. eriolepis \N \N \N Poa annua \N \N
|
|
4854 |
572 1 \N \N \N \N \N \N Caryophyllaceae family \N \N \N \N \N \N \N \N \N \N
|
|
4855 |
574 1 \N \N \N \N \N 572 Silene genus \N \N \N \N \N \N \N \N \N \N
|
|
4856 |
576 1 \N \N \N \N \N 574 scouleri species \N \N \N \N \N \N \N \N \N \N
|
|
4857 |
586 1 \N \N \N \N \N 576 pringlei subspecies subspecies \N \N \N \N \N \N \N \N \N
|
|
4858 |
588 1 \N \N 588 588 \N 586 \N subspecies subspecies Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire \N Caryophyllaceae Silene scouleri \N \N
|
|
4859 |
608 1 \N \N 588 588 1 \N var. grisea \N subsp. Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei \N \N \N Silene scouleri \N \N
|
|
4860 |
646 1 \N \N 588 588 1 \N var. grisea \N subsp. Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei \N \N \N Silene scouleri \N \N
|
|
4861 |
664 1 \N \N \N \N \N \N \N \N \N No suitable matches found. No suitable matches found. \N \N \N \N \N \N \N
|
|
4862 |
684 1 \N \N \N \N \N \N \N \N \N Fam_indet. Boyle#6501 No suitable matches found. \N \N \N \N \N \N \N
|
|
4863 |
725 2 \N \N 18 380 \N \N \N \N \N \N Poa annua \N \N \N \N \N \N \N
|
|
4864 |
728 2 \N \N 18 18 \N \N \N \N \N \N Poa annua L. \N \N \N \N \N \N \N
|
|
4865 |
731 2 \N \N 18 570 \N \N \N \N \N \N Poa annua var. eriolepis \N \N \N \N \N \N \N
|
|
4866 |
734 2 \N \N 94 494 \N \N \N \N \N \N Poa annua subsp. exilis \N \N \N \N \N \N \N
|
|
4867 |
737 2 \N \N 94 456 \N \N \N \N \N \N Poa annua ssp. exilis \N \N \N \N \N \N \N
|
|
4868 |
740 2 \N \N 512 532 \N \N \N \N \N \N Poa annua subvar. minima \N \N \N \N \N \N \N
|
|
4869 |
743 2 \N \N 56 418 \N \N \N \N \N \N Poa annua fo. lanuginosa \N \N \N \N \N \N \N
|
|
4870 |
746 2 \N \N 588 646 \N \N \N \N \N \N Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire \N \N \N \N \N \N \N
|
|
4871 |
749 2 \N \N 588 608 \N \N \N \N \N \N Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire \N \N \N \N \N \N \N
|
|
4872 |
752 2 \N \N 246 304 \N \N \N \N \N \N Fabaceae Inga sp.3 \N \N \N \N \N \N \N
|
|
4873 |
755 2 \N \N 246 266 \N \N \N \N \N \N Fabaceae Inga "fuzzy leaf" \N \N \N \N \N \N \N
|
|
4874 |
758 2 \N \N 208 342 \N \N \N \N \N \N Fabaceae unknown #2 \N \N \N \N \N \N \N
|
|
4875 |
761 2 \N \N 208 228 \N \N \N \N \N \N Fabaceae Boyle#6500 \N \N \N \N \N \N \N
|
|
4876 |
764 2 \N \N \N 684 \N \N \N \N \N \N Fam_indet. Boyle#6501 \N \N \N \N \N \N \N
|
|
4877 |
767 2 \N \N 132 190 \N \N \N \N \N \N Compositae indet. sp.1 \N \N \N \N \N \N \N
|
|
4837 | 4878 |
\. |
4838 | 4879 |
|
4839 | 4880 |
|
... | ... | |
6002 | 6043 |
|
6003 | 6044 |
|
6004 | 6045 |
-- |
6046 |
-- Name: taxonconcept_1_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: bien; Tablespace: |
|
6047 |
-- |
|
6048 |
|
|
6049 |
CREATE UNIQUE INDEX taxonconcept_1_unique_sourceaccessioncode ON taxonconcept USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); |
|
6050 |
|
|
6051 |
|
|
6052 |
-- |
|
6005 | 6053 |
-- Name: taxonconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: bien; Tablespace: |
6006 | 6054 |
-- |
6007 | 6055 |
|
... | ... | |
6012 | 6060 |
-- Name: taxonconcept_unique; Type: INDEX; Schema: public; Owner: bien; Tablespace: |
6013 | 6061 |
-- |
6014 | 6062 |
|
6015 |
CREATE UNIQUE INDEX taxonconcept_unique ON taxonconcept USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonname, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), creator_id, (COALESCE(creationdate, 'infinity'::timestamp with time zone)), (COALESCE(identifyingtaxonomicname, '\\N'::text)), (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text))); |
|
6063 |
CREATE UNIQUE INDEX taxonconcept_unique ON taxonconcept USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonname, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), creator_id, (COALESCE(sourceaccessioncode, '\\N'::text)), (COALESCE(creationdate, 'infinity'::timestamp with time zone)), (COALESCE(identifyingtaxonomicname, '\\N'::text)), (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)));
|
|
6016 | 6064 |
|
6017 | 6065 |
|
6018 | 6066 |
-- |
... | ... | |
6114 | 6162 |
|
6115 | 6163 |
|
6116 | 6164 |
-- |
6165 |
-- Name: taxonconcept_2_propagate_accepted_concept_id; Type: TRIGGER; Schema: public; Owner: bien |
|
6166 |
-- |
|
6167 |
|
|
6168 |
CREATE TRIGGER taxonconcept_2_propagate_accepted_concept_id BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_2_propagate_accepted_concept_id(); |
|
6169 |
|
|
6170 |
|
|
6171 |
-- |
|
6117 | 6172 |
-- Name: taxonconcept_update_ancestors; Type: TRIGGER; Schema: public; Owner: bien |
6118 | 6173 |
-- |
6119 | 6174 |
|
Also available in: Unified diff
inputs/test_taxonomic_names/_scrub/public.sql: Regenerated with schema changes