Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
associa_fkey01	plotobservations	associa	id	plotobservationid
associa_fkey02	lookupdata	associa	id	lookupdataid
covercodes_fkey01	lookupdata	covercodes	id	lookupdataid
datasets_fkey01	datasetgroups	datasets	id	datasetgroupid
datasets_fkey02	taxonlists	datasets	id	taxonlistid
datasets_fkey03	profiles	datasets	id	profileid
datasets_fkey04	custodians	datasets	id	custodianid
datasets_fkey05	custodians	datasets	id	deputycustodianid
fields_fkey01	units	fields	id	unitid
fields_fkey02	lookuptables	fields	id	lookuptableid
fields_fkey03	fieldgroups	fields	id	fieldgroupid
fields_fkey04	datatypes	fields	id	datatypeid
fields_fkey05	fielddomains	fields	id	fielddomainid
lookupcaptions_fkey	lookuptables	lookupcaptions	id	lookuptableid
lookuptablesdata_fkey01	lookuptables	lookupdata	id	lookuptableid
pictures_fkey01	plotobservations	pictures	id	plotobservationid
plotobservationheaderdata_fkey01	plotobservations	plotobservationheaderdata	id	plotobservationid
plotobservationheaderdata_fkey02	fields	plotobservationheaderdata	id	fieldid
plotobservationheaderdata_fkey03	lookupdata	plotobservationheaderdata	id	lookupdataid
plotobservations_fkey01	plots	plotobservations	id	plotid
plots_fkey01	datasets	plots	id	datasetid
plots_fkey02	locations	plots	id	locationid
profiledata_fkey01	profiles	profiledata	id	profileid
profiledata_fkey02	fields	profiledata	id	fieldid
projectdatasets_fkey01	projects	projectdatasets	id	projectid
projectdatasets_fkey02	datasets	projectdatasets	id	datasetid
observationsspeciesdata_fkey01	speciesobservations	speciesobservationdata	id	speciesobservationid
observationsspeciesdata_fkey02	fields	speciesobservationdata	id	fieldid
speciesdata_fkey01	plotobservations	speciesobservations	id	plotobservationid
speciesdata_fkey02	taxa	speciesobservations	id	taxonid
speciesdata_fkey03	vegetationlayers	speciesobservations	id	vegetationlayerid
speciesdata_fkey04	covercodes	speciesobservations	id	covercodeid
species_fkey01	taxonlists	taxa	id	taxonlistid
species_fkey02	taxongroups	taxa	id	taxongroupid
species_fkey03	taxonranks	taxa	id	taxonrankid
traitdata_fkey01	taxa	traitdata	id	taxonid
traitdata_fkey02	fields	traitdata	id	fieldid