Table tblRestoreTreatLU

GLHI Database HTML Dump

Table: tblRestoreTreatLU

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Project area related mitigaiton techniques lookup table

Fields

Name	Data type	Default
TreatmentLUID	integer	nextval('"tblRestoreTreatLU_TreatmentID_seq"'::regclass)
Treatment	varchar(255)
SortKey	varchar(255)
SortKeyID	integer	0

Foreign Keys

There are no foreign keys for table tblRestoreTreatLU

Checks

There are no check constraints for table tblRestoreTreatLU

Indices

Name	Type	Fields
tblRestoreTreatLU_SortKeyCode	btree	SortKeyID
tblRestoreTreatLU_TreatmentID1	btree	TreatmentLUID
tblRestoreTreatLU_pkey	btree	TreatmentLUID

Triggers

There are no triggers for table tblRestoreTreatLU

Rules

There are no rules for table tblRestoreTreatLU

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblRestoreTreatment	public	tblRestoreTreatment_fk	LimitingFactorID	public.tblRestoreTreatLU	TreatmentLUID	No Action	No Action		Immediate
xxxtblProjXTreat	glhri	tblProjXTreat_TreatmentID_fkey	TreatmentID	public.tblRestoreTreatLU	TreatmentLUID	Cascade	Cascade		Immediate

Options

Option	Value
Inherited From
Rows	33
Pages	2
System
Temporary
With OID

Definition


CREATE TABLE "public"."tblRestoreTreatLU" (
  "TreatmentLUID" SERIAL, 
  "Treatment" VARCHAR(255), 
  "SortKey" VARCHAR(255), 
  "SortKeyID" INTEGER DEFAULT 0, 
  CONSTRAINT "tblRestoreTreatLU_pkey" PRIMARY KEY("TreatmentLUID")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblRestoreTreatLU"
IS 'Project area related mitigaiton techniques lookup table';

CREATE INDEX "tblRestoreTreatLU_SortKeyCode" ON "public"."tblRestoreTreatLU"
  USING btree ("SortKeyID");

CREATE INDEX "tblRestoreTreatLU_TreatmentID1" ON "public"."tblRestoreTreatLU"
  USING btree ("TreatmentLUID");

Pete Giencke
pgiencke@glc.org