Table tblFunding

GLHI Database HTML Dump

Table: tblFunding

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

NERI-like table containing those fields relating particularly to project's funding sources.

FORM: "Funding Breakdown"

Fields

Name	Data type	Default	Description
PROJECT_ID	integer	0
EstimatedTotalCost	double precision	0	FORM: "Estimated Total Costs"
FED_CASH	double precision
NON_FED_CASH	double precision
FED_IN_KIND	double precision
NON_FED_IN_KIND	double precision
FED_LAND	double precision
NON_FED_LAND	double precision
FED_MONITORING	double precision
NON_FED_MONITORING	double precision
FED_MONITORING_IN_KIND	double precision
NON_FED_MONITORING_IN_KIND	double precision
FundingID	integer	nextval('"tblFunding_FundingID_seq"'::regclass)
FED_MAINTENANCE_CASH	double precision
NON_FED_MAINTENANCE_CASH	double precision
xOrgID	integer		Placeholder to store monetary information related to individual project sponsors.

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblFunding_fk	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action		Immediate

Checks

There are no check constraints for table tblFunding

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblFunding_ProjID	btree		PROJECT_ID
tblFunding_pkey	btree		FundingID

Triggers

There are no triggers for table tblFunding

Rules

There are no rules for table tblFunding

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblProjectFundingSources	public	tblProjectFundingSources_fk	FundingID	public.tblFunding	FundingID	No Action	No Action		Immediate

Options

Option	Value
Inherited From
Rows	0
Pages	0
System
Temporary
With OID

Definition


CREATE TABLE "public"."tblFunding" (
  "PROJECT_ID" INTEGER DEFAULT 0 NOT NULL, 
  "EstimatedTotalCost" DOUBLE PRECISION DEFAULT 0, 
  "FED_CASH" DOUBLE PRECISION, 
  "NON_FED_CASH" DOUBLE PRECISION, 
  "FED_IN_KIND" DOUBLE PRECISION, 
  "NON_FED_IN_KIND" DOUBLE PRECISION, 
  "FED_LAND" DOUBLE PRECISION, 
  "NON_FED_LAND" DOUBLE PRECISION, 
  "FED_MONITORING" DOUBLE PRECISION, 
  "NON_FED_MONITORING" DOUBLE PRECISION, 
  "FED_MONITORING_IN_KIND" DOUBLE PRECISION, 
  "NON_FED_MONITORING_IN_KIND" DOUBLE PRECISION, 
  "FundingID" SERIAL, 
  "FED_MAINTENANCE_CASH" DOUBLE PRECISION, 
  "NON_FED_MAINTENANCE_CASH" DOUBLE PRECISION, 
  "xOrgID" INTEGER, 
  CONSTRAINT "tblFunding_pkey" PRIMARY KEY("FundingID"), 
  CONSTRAINT "tblFunding_fk" FOREIGN KEY ("PROJECT_ID")
    REFERENCES "public"."tblProject"("PROJECT_ID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblFunding"
IS 'NERI-like table containing those fields relating particularly to project''s funding sources.

FORM: "Funding Breakdown"';

COMMENT ON COLUMN "public"."tblFunding"."EstimatedTotalCost"
IS 'FORM: "Estimated Total Costs"';

COMMENT ON COLUMN "public"."tblFunding"."xOrgID"
IS 'Placeholder to store monetary information related to individual project sponsors.';

CREATE INDEX "tblFunding_ProjID" ON "public"."tblFunding"
  USING btree ("PROJECT_ID");

Pete Giencke
pgiencke@glc.org