Foreign Keys

GLHI Database HTML Dump

Foreign Keys

Foreign Key	Table	Schema	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time
PhotoUpload_fk	PhotoUpload	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblCongressionalDistrict_fk	tblCongressionalDistrict	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblCongressionalDistrict_fk1	tblCongressionalDistrict	public	GeographyID	public.tblProjectGeography	GeographyID	No Action	No Action	Immediate
tblContactsAdmin_fk	tblContactsAdmin	public	ContactID	public.tblContactsLU	ContactID	No Action	No Action	Immediate
tblContactsLU_fk	tblContactsLU	public	StateID	public.tblStateLU	StateID	No Action	No Action	Immediate
tblContactsLU_fk1	tblContactsLU	public	StateID	public.tblStateLU	StateID	No Action	No Action	Immediate
tblContactsLU_fk2	tblContactsLU	public	OrgID	public.tblOrganizationLU	OrgID	No Action	No Action	Immediate
tblFunding_fk	tblFunding	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblHabitat_fk	tblHabitat	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblHabitat_fk1	tblHabitat	public	GeographyID	public.tblProjectGeography	GeographyID	No Action	No Action	Immediate
tblHabitat_fk2	tblHabitat	public	HabitatType	public.tblHabTypeLU	HabitatLUID	No Action	No Action	Immediate
tblHucs_fk	tblHucs	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblHucs_fk1	tblHucs	public	GeographyID	public.tblProjectGeography	GeographyID	No Action	No Action	Immediate
tblLandOwnership_fk	tblLandOwnership	public	LandOwnershipID	public.tblOrgTypeLU	OrgTypeID	No Action	No Action	Immediate
tblLimitingFactor_fk1	tblLimitingFactor	public	LimitingFactor	public.tblLimitingFactorLU	LimitingFactorLUID	No Action	No Action	Immediate
Monitoring_fkey	tblMonitoring	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblMonitoringActivities_fk	tblMonitoringActivities	public	MonitoringID	public.tblMonitoring	MonitoringID	No Action	No Action	Immediate
tblMonitoringActivities_fk1	tblMonitoringActivities	public	MonitoringCategory	public.tblMonitoringLU	MonitoringLUID	No Action	No Action	Immediate
tblOrganizationLU_fk	tblOrganizationLU	public	OrgTypeID	public.tblOrgTypeLU	OrgTypeID	No Action	No Action	Immediate
tblProjGoal_GoalID_fkey	tblProjGoal	public	GoalID	public.tblGoalLU	GoalLUID	Cascade	Cascade	Immediate
tblProject_fk	tblProject	public	GeographyID	public.tblProjectGeography	GeographyID	No Action	No Action	Immediate
tblProject_fk1	tblProject	public	RestorationID	public.tblRestoration	RestorationID	No Action	No Action	Immediate
tblProject_fk3	tblProject	public	ProjSignificanceID	public.tblProjectSignificance	ProjectSignificanceID	No Action	No Action	Immediate
tblProject_fk4	tblProject	public	StatusID	public.tblStatusLU	StatusLUID	No Action	No Action	Immediate
tblProject_fk5	tblProject	public	ProjCompletenessID	public.tblProjectCompletenessLU	ProjCompletenessID	No Action	No Action	Immediate
tblProject_fk6	tblProject	public	AccessConstraintID	public.tblAccessConstraintsLU	AccessConstraintLUID	No Action	No Action	Immediate
test	tblProject	public	CreatedByID	public.tblContactsLU	ContactID	No Action	No Action	Immediate
ProjectFundingSources_fk1	tblProjectFundingSources	public	OrgID	public.tblOrganizationLU	OrgID	No Action	No Action	Immediate
tblProjectFundingSources_fk	tblProjectFundingSources	public	FundingID	public.tblFunding	FundingID	No Action	No Action	Immediate
ProjectGeography_fk2	tblProjectGeography	public	ProjectFragmentationID	public.tblFragmentationLU	FragLUID	No Action	No Action	Immediate
ProjectGeography_fk6	tblProjectGeography	public	xSpatialTypeID	public.tblSpatialTypeLU	SpatialTypeID	No Action	No Action	Immediate
tblProjectGeography_fk1	tblProjectGeography	public	ProjectLandUseID	public.tblCurrentLandUse	LandUseID	No Action	No Action	Immediate
ProjectSignificance_fk	tblProjectSignificance	public	SignificanceID	public.tblProjectSignificanceLU	ProjectSignificanceLUID	No Action	No Action	Immediate
tblProjectSignificance_fk	tblProjectSignificance	public	ProjectID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblRealEstate_fk	tblRealEstate	public	GeographyID	public.tblProjectGeography	GeographyID	No Action	No Action	Immediate
tblRealEstate_fk1	tblRealEstate	public	RealEstateInterest	public.tblOrganizationLU	OrgID	No Action	No Action	Immediate
tblRealEstate_fk2	tblRealEstate	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblRestoration_fk	tblRestoration	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblRestoration_fk1	tblRestoration	public	ProjTypeID	public.tblProjectTypeLU	ProjectTypeLUID	No Action	No Action	Immediate
tblRestoration_fk2	tblRestoration	public	ProjGoalID	public.tblProjGoal	ProjGoalID	No Action	No Action	Immediate
tblRestoration_fk3	tblRestoration	public	ProjLimitingFactorID	public.tblLimitingFactor	LimitingFactorID	No Action	No Action	Immediate
tblRestoration_fk4	tblRestoration	public	ProjLimitingFactorID	public.tblRestoreTreatment	RstrFctrID	No Action	No Action	Immediate
tblRestoration_fk5	tblRestoration	public	ThreatsID	public.tblThreats	ThreatID	No Action	No Action	Immediate
tblRestoreTreatment_fk	tblRestoreTreatment	public	LimitingFactorID	public.tblRestoreTreatLU	TreatmentLUID	No Action	No Action	Immediate
tblSoils_fk	tblSoils	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblStateCounty_fk	tblStateCounty	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblStateCounty_fk1	tblStateCounty	public	GeographyID	public.tblProjectGeography	GeographyID	No Action	No Action	Immediate
tblThreats_fk	tblThreats	public	ThreatTypeID	public.tblThreatsLU	ThreatLUID	No Action	No Action	Immediate
tblThreats_fk1	tblThreats	public	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblEvalPermitLU_OrgID_fkey	xxxtblEvalPermitLU	glhri	OrgID	public.tblOrganizationLU	OrgID	Cascade	Cascade	Immediate
tblLocation_ExistLandCvrID_fkey	xxxtblLocation	glhri	ExistLandCvrID	glhri.xxxtblExistLandCvrLU	LandCvrID	Cascade	Cascade	Immediate
tblLocation_LocMeasureID_fkey	xxxtblLocation	glhri	LocMeasureID	glhri.xxxtblLocDataSourceLU	LocDataID	Cascade	Cascade	Immediate
tblLocation_SpatialTypeID_fkey	xxxtblLocation	glhri	SpatialTypeID	public.tblSpatialTypeLU	SpatialTypeID	Cascade	Cascade	Immediate
tblLocation_StateAbr_fkey	xxxtblLocation	glhri	StateAbr	public.tblStateLU	StateID	Cascade	Cascade	Immediate
tblProjTargetSpp_SppID_fkey	xxxtblProjTargetSpp	glhri	SppID	glhri.xxxtblspeciesLU	SPPID	Cascade	Cascade	Immediate
tblProjXContact_ContactID_fkey	xxxtblProjXContact	glhri	ContactID	public.tblContactsLU	ContactID	Cascade	Cascade	Immediate
tblProjXContact_OrgID_fkey	xxxtblProjXContact	glhri	OrgID	public.tblOrganizationLU	OrgID	Cascade	Cascade	Immediate
tblProjXContact_RoleID_fkey	xxxtblProjXContact	glhri	RoleID	glhri.xxxtblRoleLU	RoleID	Cascade	Cascade	Immediate
tblProjXPermit_EvalPermitID_fkey	xxxtblProjXPermit	glhri	EvalPermitID	glhri.xxxtblEvalPermitLU	EvalPermitID	Cascade	Cascade	Immediate
tblProjXTreat_TreatmentID_fkey	xxxtblProjXTreat	glhri	TreatmentID	public.tblRestoreTreatLU	TreatmentLUID	Cascade	Cascade	Immediate

Pete Giencke
pgiencke@glc.org