Project

General

Profile

« Previous | Next » 

Revision 5468

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/test_taxonomic_names/_scrub/public.sql: Regenerated with schema changes

View differences:

inputs/test_taxonomic_names/_scrub/public.sql
268 268 

  		




  269
  269
  
    

  		




  270
  270
  
    
--


  		




  271
  
  
    
-- Name: _set_canon_taxonconcept(integer, integer, double precision); Type: FUNCTION; Schema: public; Owner: bien


  		




  
  271
  
    
-- Name: _set_matched_taxonconcept(integer, integer, double precision); Type: FUNCTION; Schema: public; Owner: bien


  		




  272
  272
  
    
--


  		




  273
  273
  
    

  		




  274
  
  
    
CREATE FUNCTION _set_canon_taxonconcept(taxonconcept_id integer, canon_concept_id integer, canon_concept_fit_fraction double precision DEFAULT NULL::double precision) RETURNS integer


  		




  
  274
  
    
CREATE FUNCTION _set_matched_taxonconcept(taxonconcept_id integer, matched_concept_id integer, matched_concept_fit_fraction double precision DEFAULT NULL::double precision) RETURNS integer


  		




  275
  275
  
    
    LANGUAGE sql


  		




  276
  276
  
    
    AS $_$


  		




  277
  277
  
    
UPDATE taxonconcept SET


  		




  278
  
  
    
  canon_concept_id = $2


  		




  279
  
  
    
, canon_concept_fit_fraction = $3


  		




  
  278
  
    
  matched_concept_id = $2


  		




  
  279
  
    
, matched_concept_fit_fraction = $3


  		




  280
  280
  
    
WHERE taxonconcept_id = $1


  		




  281
  281
  
    
RETURNING taxonconcept_id


  		




  282
  282
  
    
$_$;


  		




  283
  283
  
    

  		




  284
  284
  
    

  		




  285
  
  
    
ALTER FUNCTION public._set_canon_taxonconcept(taxonconcept_id integer, canon_concept_id integer, canon_concept_fit_fraction double precision) OWNER TO bien;


  		




  
  285
  
    
ALTER FUNCTION public._set_matched_taxonconcept(taxonconcept_id integer, matched_concept_id integer, matched_concept_fit_fraction double precision) OWNER TO bien;


  		




  286
  286
  
    

  		




  287
  287
  
    
--


  		




  288
  288
  
    
-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: bien


  		




  ......




  370
  370
  
    
ALTER FUNCTION public.place_update_ancestors() OWNER TO bien;


  		




  371
  371
  
    

  		




  372
  372
  
    
--


  		




  373
  
  
    
-- Name: placepath_canon_placepath_id_self_ref(); Type: FUNCTION; Schema: public; Owner: bien


  		




  
  373
  
    
-- Name: placepath_matched_placepath_id_self_ref(); Type: FUNCTION; Schema: public; Owner: bien


  		




  374
  374
  
    
--


  		




  375
  375
  
    

  		




  376
  
  
    
CREATE FUNCTION placepath_canon_placepath_id_self_ref() RETURNS trigger


  		




  
  376
  
    
CREATE FUNCTION placepath_matched_placepath_id_self_ref() RETURNS trigger


  		




  377
  377
  
    
    LANGUAGE plpgsql


  		




  378
  378
  
    
    AS $$


  		




  379
  379
  
    
BEGIN


  		




  380
  380
  
    
    IF new.placepath_id IS NULL THEN -- prepopulate placepath_id


  		




  381
  381
  
    
        new.placepath_id = nextval('placepath_placepath_id_seq'::regclass);


  		




  382
  382
  
    
    END IF;


  		




  383
  
  
    
    IF new.canon_placepath_id = 0 THEN -- make self-reference


  		




  384
  
  
    
        new.canon_placepath_id = new.placepath_id;


  		




  
  383
  
    
    IF new.matched_placepath_id = 0 THEN -- make self-reference


  		




  
  384
  
    
        new.matched_placepath_id = new.placepath_id;


  		




  385
  385
  
    
    END IF;


  		




  386
  386
  
    
    RETURN new;


  		




  387
  387
  
    
END;


  		




  388
  388
  
    
$$;


  		




  389
  389
  
    

  		




  390
  390
  
    

  		




  391
  
  
    
ALTER FUNCTION public.placepath_canon_placepath_id_self_ref() OWNER TO bien;


  		




  
  391
  
    
ALTER FUNCTION public.placepath_matched_placepath_id_self_ref() OWNER TO bien;


  		




  392
  392
  
    

  		




  393
  393
  
    
--


  		




  394
  394
  
    
-- Name: plantobservation_aggregateoccurrence_count_1(); Type: FUNCTION; Schema: public; Owner: bien


  		




  ......




  410
  410
  
    
ALTER FUNCTION public.plantobservation_aggregateoccurrence_count_1() OWNER TO bien;


  		




  411
  411
  
    

  		




  412
  412
  
    
--


  		




  413
  
  
    
-- Name: taxonconcept_canon_concept_id_self_ref(); Type: FUNCTION; Schema: public; Owner: bien


  		




  
  413
  
    
-- Name: taxonconcept_0_matched_concept_id_self_ref(); Type: FUNCTION; Schema: public; Owner: bien


  		




  414
  414
  
    
--


  		




  415
  415
  
    

  		




  416
  
  
    
CREATE FUNCTION taxonconcept_canon_concept_id_self_ref() RETURNS trigger


  		




  
  416
  
    
CREATE FUNCTION taxonconcept_0_matched_concept_id_self_ref() RETURNS trigger


  		




  417
  417
  
    
    LANGUAGE plpgsql


  		




  418
  418
  
    
    AS $$


  		




  419
  419
  
    
BEGIN


  		




  420
  420
  
    
    IF new.taxonconcept_id IS NULL THEN -- prepopulate taxonconcept_id


  		




  421
  421
  
    
        new.taxonconcept_id = nextval('taxonconcept_taxonconcept_id_seq'::regclass);


  		




  422
  422
  
    
    END IF;


  		




  423
  
  
    
    IF new.canon_concept_id = 0 THEN -- make self-reference


  		




  424
  
  
    
        new.canon_concept_id = new.taxonconcept_id;


  		




  
  423
  
    
    IF new.matched_concept_id = 0 THEN -- make self-reference


  		




  
  424
  
    
        new.matched_concept_id = new.taxonconcept_id;


  		




  425
  425
  
    
    END IF;


  		




  426
  426
  
    
    RETURN new;


  		




  427
  427
  
    
END;


  		




  428
  428
  
    
$$;


  		




  429
  429
  
    

  		




  430
  430
  
    

  		




  431
  
  
    
ALTER FUNCTION public.taxonconcept_canon_concept_id_self_ref() OWNER TO bien;


  		




  
  431
  
    
ALTER FUNCTION public.taxonconcept_0_matched_concept_id_self_ref() OWNER TO bien;


  		




  432
  432
  
    

  		




  433
  433
  
    
--


  		




  434
  
  
    
-- Name: taxonconcept_canon_concept_min_fit(); Type: FUNCTION; Schema: public; Owner: bien


  		




  
  434
  
    
-- Name: taxonconcept_1_matched_concept_min_fit(); Type: FUNCTION; Schema: public; Owner: bien


  		




  435
  435
  
    
--


  		




  436
  436
  
    

  		




  437
  
  
    
CREATE FUNCTION taxonconcept_canon_concept_min_fit() RETURNS trigger


  		




  
  437
  
    
CREATE FUNCTION taxonconcept_1_matched_concept_min_fit() RETURNS trigger


  		




  438
  438
  
    
    LANGUAGE plpgsql


  		




  439
  439
  
    
    AS $$


  		




  440
  440
  
    
BEGIN


  		




  441
  
  
    
    IF new.canon_concept_id IS NOT NULL


  		




  442
  
  
    
        AND new.canon_concept_fit_fraction < 0.8 THEN -- insufficient match


  		




  443
  
  
    
        new.canon_concept_id = NULL;


  		




  444
  
  
    
        new.canon_concept_fit_fraction = NULL;


  		




  
  441
  
    
    IF new.matched_concept_id IS NOT NULL


  		




  
  442
  
    
        AND new.matched_concept_fit_fraction < 0.8 THEN -- insufficient match


  		




  
  443
  
    
        new.matched_concept_id = NULL;


  		




  
  444
  
    
        new.matched_concept_fit_fraction = NULL;


  		




  445
  445
  
    
    END IF;


  		




  446
  446
  
    
    RETURN new;


  		




  447
  447
  
    
END;


  		




  448
  448
  
    
$$;


  		




  449
  449
  
    

  		




  450
  450
  
    

  		




  451
  
  
    
ALTER FUNCTION public.taxonconcept_canon_concept_min_fit() OWNER TO bien;


  		




  
  451
  
    
ALTER FUNCTION public.taxonconcept_1_matched_concept_min_fit() OWNER TO bien;


  		




  452
  452
  
    

  		




  453
  453
  
    
--


  		




  454
  454
  
    
-- Name: taxonconcept_update_ancestors(); Type: FUNCTION; Schema: public; Owner: bien


  		




  ......




  1091
  1091
  
    
    placepath_id integer NOT NULL,


  		




  1092
  1092
  
    
    creator_id integer NOT NULL,


  		




  1093
  1093
  
    
    placecode text,


  		




  1094
  
  
    
    canon_placepath_id integer,


  		




  
  1094
  
    
    matched_placepath_id integer,


  		




  1095
  1095
  
    
    place_id integer,


  		




  1096
  1096
  
    
    continent text,


  		




  1097
  1097
  
    
    country text,


  		




  ......




  1116
  1116
  
    

  		




  1117
  1117
  
    

  		




  1118
  1118
  
    
--


  		




  1119
  
  
    
-- Name: COLUMN placepath.canon_placepath_id; Type: COMMENT; Schema: public; Owner: bien


  		




  
  1119
  
    
-- Name: COLUMN placepath.matched_placepath_id; Type: COMMENT; Schema: public; Owner: bien


  		




  1120
  1120
  
    
--


  		




  1121
  1121
  
    

  		




  1122
  
  
    
COMMENT ON COLUMN placepath.canon_placepath_id IS 'The placepath containing the accepted name of this verbatim place path.  placepaths should be linked in a two-level hierarchy of datasource name -> accepted name.


  		




  
  1122
  
    
COMMENT ON COLUMN placepath.matched_placepath_id IS 'The placepath containing the accepted name of this verbatim place path.  placepaths should be linked in a two-level hierarchy of datasource name -> accepted name.


  		




  1123
  1123
  
    

  		




  1124
  1124
  
    
A accepted name should point to itself in this field. This will happen automatically by setting it to the special value 0.';


  		




  1125
  1125
  
    

  		




  ......




  1215
  1215
  
    
    taxonconcept_id integer NOT NULL,


  		




  1216
  1216
  
    
    creator_id integer NOT NULL,


  		




  1217
  1217
  
    
    creationdate timestamp with time zone,


  		




  1218
  
  
    
    canon_concept_id integer,


  		




  1219
  
  
    
    canon_concept_fit_fraction double precision,


  		




  
  1218
  
    
    accepted_concept_id integer,


  		




  
  1219
  
    
    matched_concept_id integer,


  		




  
  1220
  
    
    matched_concept_fit_fraction double precision,


  		




  1220
  1221
  
    
    parent_id integer,


  		




  1221
  1222
  
    
    taxonname text,


  		




  1222
  1223
  
    
    rank taxonrank,


  		




  ......




  1230
  1231
  
    
    species text,


  		




  1231
  1232
  
    
    description text,


  		




  1232
  1233
  
    
    accessioncode text,


  		




  1233
  
  
    
    CONSTRAINT taxonconcept_canon_concept_fit_fraction_range CHECK (((canon_concept_fit_fraction >= (0)::double precision) AND (canon_concept_fit_fraction <= (1)::double precision))),


  		




  
  1234
  
    
    CONSTRAINT taxonconcept_matched_concept_fit_fraction_range CHECK (((matched_concept_fit_fraction >= (0)::double precision) AND (matched_concept_fit_fraction <= (1)::double precision))),


  		




  1234
  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)))))


  		




  1235
  1236
  
    
);


  		




  1236
  1237
  
    

  		




  ......




  1267
  1268
  
    

  		




  1268
  1269
  
    

  		




  1269
  1270
  
    
--


  		




  1270
  
  
    
-- Name: COLUMN taxonconcept.canon_concept_id; Type: COMMENT; Schema: public; Owner: bien


  		




  
  1271
  
    
-- Name: COLUMN taxonconcept.matched_concept_id; Type: COMMENT; Schema: public; Owner: bien


  		




  1271
  1272
  
    
--


  		




  1272
  1273
  
    

  		




  1273
  
  
    
COMMENT ON COLUMN taxonconcept.canon_concept_id IS 'The taxonconcept containing the accepted synonym of this taxonconcept. taxonconcepts should be linked in a four-level hierarchy of datasource concept -> parsed concept -> matched concept -> accepted concept. A previously-accepted name''s concept should be further linked to the synonym that has replaced it.


  		




  
  1274
  
    
COMMENT ON COLUMN taxonconcept.matched_concept_id IS 'The taxonconcept containing the closest match to this taxonconcept. taxonconcepts should be linked in a four-level hierarchy of datasource concept -> parsed concept -> matched concept -> accepted concept. A previously-accepted name''s concept should be further linked to the synonym that has replaced it.


  		




  1274
  1275
  
    

  		




  1275
  1276
  
    
To indicate a synonym between taxonconcepts of different sources, choose one taxonconcept to be authoritative and point the other taxonconcept to it using this field.


  		




  1276
  1277
  
    

  		




  ......




  1278
  1279
  
    

  		




  1279
  1280
  
    

  		




  1280
  1281
  
    
--


  		




  1281
  
  
    
-- Name: COLUMN taxonconcept.canon_concept_fit_fraction; Type: COMMENT; Schema: public; Owner: bien


  		




  
  1282
  
    
-- Name: COLUMN taxonconcept.matched_concept_fit_fraction; Type: COMMENT; Schema: public; Owner: bien


  		




  1282
  1283
  
    
--


  		




  1283
  1284
  
    

  		




  1284
  
  
    
COMMENT ON COLUMN taxonconcept.canon_concept_fit_fraction IS 'The closeness of fit of the canon_concept.';


  		




  
  1285
  
    
COMMENT ON COLUMN taxonconcept.matched_concept_fit_fraction IS 'The closeness of fit of the matched_concept.';


  		




  1285
  1286
  
    

  		




  1286
  1287
  
    

  		




  1287
  1288
  
    
--


  		




  ......




  2609
  2610
  
    
ALTER TABLE public.place_ancestor OWNER TO bien;


  		




  2610
  2611
  
    

  		




  2611
  2612
  
    
--


  		




  
  2613
  
    
-- Name: TABLE place_ancestor; Type: COMMENT; Schema: public; Owner: bien


  		




  
  2614
  
    
--


  		




  
  2615
  
    

  		




  
  2616
  
    
COMMENT ON TABLE place_ancestor IS 'place''s ancestor cross link table.';


  		




  
  2617
  
    

  		




  
  2618
  
    

  		




  
  2619
  
    
--


  		




  2612
  2620
  
    
-- Name: place_place_id_seq; Type: SEQUENCE; Schema: public; Owner: bien


  		




  2613
  2621
  
    
--


  		




  2614
  2622
  
    

  		




  ......




  3514
  3522
  
    
ALTER TABLE public.taxonconcept_ancestor OWNER TO bien;


  		




  3515
  3523
  
    

  		




  3516
  3524
  
    
--


  		




  
  3525
  
    
-- Name: TABLE taxonconcept_ancestor; Type: COMMENT; Schema: public; Owner: bien


  		




  
  3526
  
    
--


  		




  
  3527
  
    

  		




  
  3528
  
    
COMMENT ON TABLE taxonconcept_ancestor IS 'taxonconcept''s ancestor cross link table.';


  		




  
  3529
  
    

  		




  
  3530
  
    

  		




  
  3531
  
    
--


  		




  3517
  3532
  
    
-- Name: taxonconcept_taxonconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: bien


  		




  3518
  3533
  
    
--


  		




  3519
  3534
  
    

  		




  ......




  4614
  4629
  
    
-- Data for Name: placepath; Type: TABLE DATA; Schema: public; Owner: bien


  		




  4615
  4630
  
    
--


  		




  4616
  4631
  
    

  		




  4617
  
  
    
COPY placepath (placepath_id, creator_id, placecode, canon_placepath_id, place_id, continent, country, stateprovince, county, municipality, site, otherranks) FROM stdin;


  		




  
  4632
  
    
COPY placepath (placepath_id, creator_id, placecode, matched_placepath_id, place_id, continent, country, stateprovince, county, municipality, site, otherranks) FROM stdin;


  		




  4618
  4633
  
    
\.


  		




  4619
  4634
  
    

  		




  4620
  4635
  
    

  		




  ......




  4758
  4773
  
    
-- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public; Owner: bien


  		




  4759
  4774
  
    
--


  		




  4760
  4775
  
    

  		




  4761
  
  
    
COPY taxonconcept (taxonconcept_id, creator_id, creationdate, canon_concept_id, canon_concept_fit_fraction, parent_id, taxonname, rank, verbatimrank, identifyingtaxonomicname, taxonomicname, author, taxonomicnamewithauthor, family, genus, species, description, accessioncode) FROM stdin;


  		




  4762
  
  
    
2	1	\N	\N	\N	\N	Poaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4763
  
  
    
4	1	\N	\N	\N	2	Poa	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4764
  
  
    
6	1	\N	\N	\N	4	annua	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4765
  
  
    
18	1	\N	18	\N	6	\N	species	species	Poa annua L.	Poa annua	L.	\N	Poaceae	Poa	annua	\N	\N


  		




  4766
  
  
    
54	1	\N	\N	\N	6	annua	variety	variety	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4767
  
  
    
56	1	\N	56	\N	54	\N	variety	variety	Poa annua var. annua	Poa annua var. annua	\N	\N	Poaceae	Poa	annua	\N	\N


  		




  4768
  
  
    
82	1	\N	\N	\N	4	infirma	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4769
  
  
    
94	1	\N	94	\N	82	\N	species	species	Poa infirma Kunth	Poa infirma	Kunth	\N	Poaceae	Poa	infirma	\N	\N


  		




  4770
  
  
    
132	1	\N	132	\N	\N	\N	family	family	Asteraceae	Asteraceae	\N	\N	\N	\N	\N	\N	\N


  		




  4771
  
  
    
152	1	\N	132	1	\N	Bercht. & J. Presl	\N	\N	Asteraceae Bercht. & J. Presl	Asteraceae	\N	\N	Asteraceae	\N	\N	\N	\N


  		




  4772
  
  
    
154	1	\N	\N	\N	\N	Compositae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4773
  
  
    
172	1	\N	\N	\N	\N	Asteraceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4774
  
  
    
170	1	\N	152	\N	154	\N	family	family	Compositae Giseke	Compositae	Giseke	\N	Compositae	\N	\N	\N	\N


  		




  4775
  
  
    
190	1	\N	170	1	\N	indet. sp.1	\N	\N	Compositae indet. sp.1	Compositae	\N	\N	Compositae	\N	\N	\N	\N


  		




  4776
  
  
    
192	1	\N	\N	\N	\N	Fabaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4777
  
  
    
208	1	\N	208	\N	192	\N	family	family	Fabaceae Lindl.	Fabaceae	Lindl.	\N	Fabaceae	\N	\N	\N	\N


  		




  4778
  
  
    
228	1	\N	208	1	\N	Boyle#6500	\N	\N	Fabaceae Boyle#6500	Fabaceae	\N	\N	Fabaceae	\N	\N	\N	\N


  		




  4779
  
  
    
232	1	\N	\N	\N	192	Inga	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4780
  
  
    
246	1	\N	246	\N	232	\N	genus	genus	Inga Mill.	Inga	Mill.	\N	Fabaceae	Inga	\N	\N	\N


  		




  4781
  
  
    
266	1	\N	246	1	\N	"fuzzy leaf"	\N	\N	Fabaceae Inga "fuzzy leaf"	Inga	\N	\N	Fabaceae	Inga	\N	\N	\N


  		




  4782
  
  
    
304	1	\N	246	1	\N	sp.3	\N	\N	Fabaceae Inga sp.3	Inga	\N	\N	Fabaceae	Inga	\N	\N	\N


  		




  4783
  
  
    
342	1	\N	208	1	\N	unknown #2	\N	\N	Fabaceae unknown #2	Fabaceae	\N	\N	Fabaceae	\N	\N	\N	\N


  		




  4784
  
  
    
380	1	\N	18	1	\N	\N	\N	\N	Poa annua	Poa annua	\N	\N	\N	Poa	annua	\N	\N


  		




  4785
  
  
    
396	1	\N	\N	\N	6	lanuginosa	forma	forma	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4786
  
  
    
398	1	\N	56	\N	396	\N	forma	forma	Poa annua fo. lanuginosa Sennen	Poa annua fo. lanuginosa	Sennen	\N	Poaceae	Poa	annua	\N	\N


  		




  4787
  
  
    
418	1	\N	398	1	\N	\N	\N	fo.	Poa annua fo. lanuginosa	Poa annua fo. lanuginosa	\N	\N	\N	Poa	annua	\N	\N


  		




  4788
  
  
    
434	1	\N	\N	\N	6	exilis	subspecies	subspecies	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4789
  
  
    
436	1	\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


  		




  4790
  
  
    
456	1	\N	436	1	\N	\N	\N	subsp.	Poa annua ssp. exilis	Poa annua subsp. exilis	\N	\N	\N	Poa	annua	\N	\N


  		




  4791
  
  
    
494	1	\N	436	1	\N	\N	\N	subsp.	Poa annua subsp. exilis	Poa annua subsp. exilis	\N	\N	\N	Poa	annua	\N	\N


  		




  4792
  
  
    
510	1	\N	\N	\N	6	minima	subvariety	subvariety	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4793
  
  
    
512	1	\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


  		




  4794
  
  
    
532	1	\N	512	1	\N	\N	\N	subvar.	Poa annua subvar. minima	Poa annua subvar. minima	\N	\N	\N	Poa	annua	\N	\N


  		




  4795
  
  
    
548	1	\N	\N	\N	6	eriolepis	variety	variety	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4796
  
  
    
550	1	\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


  		




  4797
  
  
    
570	1	\N	550	1	\N	\N	\N	var.	Poa annua var. eriolepis	Poa annua var. eriolepis	\N	\N	\N	Poa	annua	\N	\N


  		




  4798
  
  
    
572	1	\N	\N	\N	\N	Caryophyllaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4799
  
  
    
574	1	\N	\N	\N	572	Silene	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4800
  
  
    
576	1	\N	\N	\N	574	scouleri	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4801
  
  
    
586	1	\N	\N	\N	576	pringlei	subspecies	subspecies	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  4802
  
  
    
588	1	\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


  		




  4803
  
  
    
608	1	\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


  		




  4804
  
  
    
646	1	\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


  		




  4805
  
  
    
664	1	\N	\N	\N	\N	\N	\N	\N	No suitable matches found.	No suitable matches found.	\N	\N	\N	\N	\N	\N	\N


  		




  4806
  
  
    
684	1	\N	\N	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	No suitable matches found.	\N	\N	\N	\N	\N	\N	\N


  		




  4807
  
  
    
725	2	\N	380	\N	\N	\N	\N	\N	\N	Poa annua	\N	\N	\N	\N	\N	\N	\N


  		




  4808
  
  
    
728	2	\N	18	\N	\N	\N	\N	\N	\N	Poa annua L.	\N	\N	\N	\N	\N	\N	\N


  		




  4809
  
  
    
731	2	\N	570	\N	\N	\N	\N	\N	\N	Poa annua var. eriolepis	\N	\N	\N	\N	\N	\N	\N


  		




  4810
  
  
    
734	2	\N	494	\N	\N	\N	\N	\N	\N	Poa annua subsp. exilis	\N	\N	\N	\N	\N	\N	\N


  		




  4811
  
  
    
737	2	\N	456	\N	\N	\N	\N	\N	\N	Poa annua ssp. exilis	\N	\N	\N	\N	\N	\N	\N


  		




  4812
  
  
    
740	2	\N	532	\N	\N	\N	\N	\N	\N	Poa annua subvar. minima	\N	\N	\N	\N	\N	\N	\N


  		




  4813
  
  
    
743	2	\N	418	\N	\N	\N	\N	\N	\N	Poa annua fo. lanuginosa	\N	\N	\N	\N	\N	\N	\N


  		




  4814
  
  
    
746	2	\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


  		




  4815
  
  
    
749	2	\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


  		




  4816
  
  
    
752	2	\N	304	\N	\N	\N	\N	\N	\N	Fabaceae Inga sp.3	\N	\N	\N	\N	\N	\N	\N


  		




  4817
  
  
    
755	2	\N	266	\N	\N	\N	\N	\N	\N	Fabaceae Inga "fuzzy leaf"	\N	\N	\N	\N	\N	\N	\N


  		




  4818
  
  
    
758	2	\N	342	\N	\N	\N	\N	\N	\N	Fabaceae unknown #2	\N	\N	\N	\N	\N	\N	\N


  		




  4819
  
  
    
761	2	\N	228	\N	\N	\N	\N	\N	\N	Fabaceae Boyle#6500	\N	\N	\N	\N	\N	\N	\N


  		




  4820
  
  
    
764	2	\N	684	\N	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N	\N	\N	\N	\N	\N	\N


  		




  4821
  
  
    
767	2	\N	190	\N	\N	\N	\N	\N	\N	Compositae indet. sp.1	\N	\N	\N	\N	\N	\N	\N


  		




  
  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


  		




  4822
  4837
  
    
\.


  		




  4823
  4838
  
    

  		




  4824
  4839
  
    

  		




  ......




  6071
  6086
  
    

  		




  6072
  6087
  
    

  		




  6073
  6088
  
    
--


  		




  6074
  
  
    
-- Name: placepath_canon_placepath_id_self_ref; Type: TRIGGER; Schema: public; Owner: bien


  		




  
  6089
  
    
-- Name: placepath_matched_placepath_id_self_ref; Type: TRIGGER; Schema: public; Owner: bien


  		




  6075
  6090
  
    
--


  		




  6076
  6091
  
    

  		




  6077
  
  
    
CREATE TRIGGER placepath_canon_placepath_id_self_ref BEFORE INSERT OR UPDATE ON placepath FOR EACH ROW EXECUTE PROCEDURE placepath_canon_placepath_id_self_ref();


  		




  
  6092
  
    
CREATE TRIGGER placepath_matched_placepath_id_self_ref BEFORE INSERT OR UPDATE ON placepath FOR EACH ROW EXECUTE PROCEDURE placepath_matched_placepath_id_self_ref();


  		




  6078
  6093
  
    

  		




  6079
  6094
  
    

  		




  6080
  6095
  
    
--


  		




  ......




  6085
  6100
  
    

  		




  6086
  6101
  
    

  		




  6087
  6102
  
    
--


  		




  6088
  
  
    
-- Name: taxonconcept_canon_concept_id_self_ref; Type: TRIGGER; Schema: public; Owner: bien


  		




  
  6103
  
    
-- Name: taxonconcept_0_matched_concept_id_self_ref; Type: TRIGGER; Schema: public; Owner: bien


  		




  6089
  6104
  
    
--


  		




  6090
  6105
  
    

  		




  6091
  
  
    
CREATE TRIGGER taxonconcept_canon_concept_id_self_ref BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_canon_concept_id_self_ref();


  		




  
  6106
  
    
CREATE TRIGGER taxonconcept_0_matched_concept_id_self_ref BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_0_matched_concept_id_self_ref();


  		




  6092
  6107
  
    

  		




  6093
  6108
  
    

  		




  6094
  6109
  
    
--


  		




  6095
  
  
    
-- Name: taxonconcept_canon_concept_min_fit; Type: TRIGGER; Schema: public; Owner: bien


  		




  
  6110
  
    
-- Name: taxonconcept_1_matched_concept_min_fit; Type: TRIGGER; Schema: public; Owner: bien


  		




  6096
  6111
  
    
--


  		




  6097
  6112
  
    

  		




  6098
  
  
    
CREATE TRIGGER taxonconcept_canon_concept_min_fit BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_canon_concept_min_fit();


  		




  
  6113
  
    
CREATE TRIGGER taxonconcept_1_matched_concept_min_fit BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_1_matched_concept_min_fit();


  		




  6099
  6114
  
    

  		




  6100
  6115
  
    

  		




  6101
  6116
  
    
--


  		




  ......




  6666
  6681
  
    

  		




  6667
  6682
  
    

  		




  6668
  6683
  
    
--


  		




  6669
  
  
    
-- Name: placepath_canon_placepath_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: bien


  		




  
  6684
  
    
-- Name: placepath_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: bien


  		




  6670
  6685
  
    
--


  		




  6671
  6686
  
    

  		




  6672
  6687
  
    
ALTER TABLE ONLY placepath


  		




  6673
  
  
    
    ADD CONSTRAINT placepath_canon_placepath_id_fkey FOREIGN KEY (canon_placepath_id) REFERENCES placepath(placepath_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  6688
  
    
    ADD CONSTRAINT placepath_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  6674
  6689
  
    

  		




  6675
  6690
  
    

  		




  6676
  6691
  
    
--


  		




  6677
  
  
    
-- Name: placepath_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: bien


  		




  
  6692
  
    
-- Name: placepath_matched_placepath_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: bien


  		




  6678
  6693
  
    
--


  		




  6679
  6694
  
    

  		




  6680
  6695
  
    
ALTER TABLE ONLY placepath


  		




  6681
  
  
    
    ADD CONSTRAINT placepath_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  6696
  
    
    ADD CONSTRAINT placepath_matched_placepath_id_fkey FOREIGN KEY (matched_placepath_id) REFERENCES placepath(placepath_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  6682
  6697
  
    

  		




  6683
  6698
  
    

  		




  6684
  6699
  
    
--


  		




  ......




  6882
  6897
  
    

  		




  6883
  6898
  
    

  		




  6884
  6899
  
    
--


  		




  
  6900
  
    
-- Name: taxonconcept_accepted_concept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: bien


  		




  
  6901
  
    
--


  		




  
  6902
  
    

  		




  
  6903
  
    
ALTER TABLE ONLY taxonconcept


  		




  
  6904
  
    
    ADD CONSTRAINT taxonconcept_accepted_concept_id_fkey FOREIGN KEY (accepted_concept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  6905
  
    

  		




  
  6906
  
    

  		




  
  6907
  
    
--


  		




  6885
  6908
  
    
-- Name: taxonconcept_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: bien


  		




  6886
  6909
  
    
--


  		




  6887
  6910
  
    

  		




  ......




  6898
  6921
  
    

  		




  6899
  6922
  
    

  		




  6900
  6923
  
    
--


  		




  6901
  
  
    
-- Name: taxonconcept_canon_concept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: bien


  		




  
  6924
  
    
-- Name: taxonconcept_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: bien


  		




  6902
  6925
  
    
--


  		




  6903
  6926
  
    

  		




  6904
  6927
  
    
ALTER TABLE ONLY taxonconcept


  		




  6905
  
  
    
    ADD CONSTRAINT taxonconcept_canon_concept_id_fkey FOREIGN KEY (canon_concept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  6928
  
    
    ADD CONSTRAINT taxonconcept_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  6906
  6929
  
    

  		




  6907
  6930
  
    

  		




  6908
  6931
  
    
--


  		




  6909
  
  
    
-- Name: taxonconcept_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: bien


  		




  
  6932
  
    
-- Name: taxonconcept_matched_concept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: bien


  		




  6910
  6933
  
    
--


  		




  6911
  6934
  
    

  		




  6912
  6935
  
    
ALTER TABLE ONLY taxonconcept


  		




  6913
  
  
    
    ADD CONSTRAINT taxonconcept_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  6936
  
    
    ADD CONSTRAINT taxonconcept_matched_concept_id_fkey FOREIGN KEY (matched_concept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  6914
  6937
  
    

  		




  6915
  6938
  
    

  		




  6916
  6939
  
    
--


  		












Also available in:  Unified diff