Table tblHabitat

GLHI Database HTML Dump

Table: tblHabitat

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Table to hold NERI (et al) derived habitat types for project areas. Table can be extended to support individual habitat tracking using acres/miles places.

FORM: "HABITAT TYPE"

Fields

Name	Data type	Default	Description
HabitatID	integer	nextval('"tblHabitat_HabitatID_seq"'::regclass)
PROJECT_ID	integer
GeographyID	integer
RestorationID	integer
HabitatType	integer
xAcresCreated	double precision		Placeholder to store individual habitat type activities in support of tracking gains/losses/etc
xAcresImproved	double precision		Placeholder to store individual habitat type activities in support of tracking gains/losses/etc
xAcresProtected	double precision		Placeholder to store individual habitat type activities in support of tracking gains/losses/etc
xAcresEnhanced	double precision		Placeholder to store individual habitat type activities in support of tracking gains/losses/etc
xRiverMilesImproved	double precision		Placeholder to store individual habitat type activities in support of tracking gains/losses/etc
xRiverMilesOpen	double precision		Placeholder to store individual habitat type activities in support of tracking gains/losses/etc
xRiverMilesProtected	double precision		Placeholder to store individual habitat type activities in support of tracking gains/losses/etc

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time
tblHabitat_fk	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate
tblHabitat_fk1	GeographyID	public.tblProjectGeography	GeographyID	No Action	No Action	Immediate
tblHabitat_fk2	HabitatType	public.tblHabTypeLU	HabitatLUID	No Action	No Action	Immediate

Checks

There are no check constraints for table tblHabitat

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblHabitat_pkey	btree		HabitatID

Triggers

There are no triggers for table tblHabitat

Rules

There are no rules for table tblHabitat

Referenced

There are no tables referenced by table tblHabitat

Options

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

Definition


CREATE TABLE "public"."tblHabitat" (
  "HabitatID" SERIAL, 
  "PROJECT_ID" INTEGER NOT NULL, 
  "GeographyID" INTEGER NOT NULL, 
  "RestorationID" INTEGER, 
  "HabitatType" INTEGER, 
  "xAcresCreated" DOUBLE PRECISION, 
  "xAcresImproved" DOUBLE PRECISION, 
  "xAcresProtected" DOUBLE PRECISION, 
  "xAcresEnhanced" DOUBLE PRECISION, 
  "xRiverMilesImproved" DOUBLE PRECISION, 
  "xRiverMilesOpen" DOUBLE PRECISION, 
  "xRiverMilesProtected" DOUBLE PRECISION, 
  CONSTRAINT "tblHabitat_pkey" PRIMARY KEY("HabitatID"), 
  CONSTRAINT "tblHabitat_fk" FOREIGN KEY ("PROJECT_ID")
    REFERENCES "public"."tblProject"("PROJECT_ID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "tblHabitat_fk1" FOREIGN KEY ("GeographyID")
    REFERENCES "public"."tblProjectGeography"("GeographyID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "tblHabitat_fk2" FOREIGN KEY ("HabitatType")
    REFERENCES "public"."tblHabTypeLU"("HabitatLUID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblHabitat"
IS 'Table to hold NERI (et al) derived habitat types for project areas. Table can be extended to support individual habitat tracking using acres/miles places.

FORM: "HABITAT TYPE"';

COMMENT ON COLUMN "public"."tblHabitat"."xAcresCreated"
IS 'Placeholder to store individual habitat type activities in support of tracking gains/losses/etc';

COMMENT ON COLUMN "public"."tblHabitat"."xAcresImproved"
IS 'Placeholder to store individual habitat type activities in support of tracking gains/losses/etc';

COMMENT ON COLUMN "public"."tblHabitat"."xAcresProtected"
IS 'Placeholder to store individual habitat type activities in support of tracking gains/losses/etc';

COMMENT ON COLUMN "public"."tblHabitat"."xAcresEnhanced"
IS 'Placeholder to store individual habitat type activities in support of tracking gains/losses/etc';

COMMENT ON COLUMN "public"."tblHabitat"."xRiverMilesImproved"
IS 'Placeholder to store individual habitat type activities in support of tracking gains/losses/etc';

COMMENT ON COLUMN "public"."tblHabitat"."xRiverMilesOpen"
IS 'Placeholder to store individual habitat type activities in support of tracking gains/losses/etc';

COMMENT ON COLUMN "public"."tblHabitat"."xRiverMilesProtected"
IS 'Placeholder to store individual habitat type activities in support of tracking gains/losses/etc';

Pete Giencke
pgiencke@glc.org