GLHI Database HTML Dump
Previous topic Chapter index Next topic

Foreign Keys

 

Foreign Key

Table

Schema

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

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
Previous topic Chapter index Next topic