Table tblRestoreTreatment

GLHI Database HTML Dump

Table: tblRestoreTreatment

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Table containing mitigation techniques for the project, with keys back to the Project_ID and restoretreatment lookup table

FORM: "Mitigation Techniques and Measures"

Fields

Name	Data type	Default
RstrFctrID	integer	nextval('glhri."tblRestoreTreatment_RstrFctrID_seq"'::regclass)
PROJECT_ID	integer
LimitingFactorID	integer

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblRestoreTreatment_fk	LimitingFactorID	public.tblRestoreTreatLU	TreatmentLUID	No Action	No Action		Immediate

Checks

There are no check constraints for table tblRestoreTreatment

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblRestoreTreatment_pkey	btree		RstrFctrID

Triggers

There are no triggers for table tblRestoreTreatment

Rules

There are no rules for table tblRestoreTreatment

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblRestoration	public	tblRestoration_fk4	ProjLimitingFactorID	public.tblRestoreTreatment	RstrFctrID	No Action	No Action		Immediate

Options

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

Definition


CREATE TABLE "public"."tblRestoreTreatment" (
  "RstrFctrID" SERIAL, 
  "PROJECT_ID" INTEGER NOT NULL, 
  "LimitingFactorID" INTEGER, 
  CONSTRAINT "tblRestoreTreatment_pkey" PRIMARY KEY("RstrFctrID"), 
  CONSTRAINT "tblRestoreTreatment_fk" FOREIGN KEY ("LimitingFactorID")
    REFERENCES "public"."tblRestoreTreatLU"("TreatmentLUID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE
) WITH OIDS;

COMMENT ON TABLE "public"."tblRestoreTreatment"
IS 'Table containing mitigation techniques for the project, with keys back to the Project_ID and restoretreatment lookup table

FORM: "Mitigation Techniques and Measures"';

Pete Giencke
pgiencke@glc.org