Table tblGoalLU

GLHI Database HTML Dump

Table: tblGoalLU

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Lookup table containing different ecological outcomes

Fields

Name	Data type	Default
GoalLUID	integer	nextval('"tblGoalLU_GoalID_seq"'::regclass)
Goal	varchar(60)
Comments	varchar(200)
SortKey	integer	0
GoalCategory	varchar(255)

Foreign Keys

There are no foreign keys for table tblGoalLU

Checks

There are no check constraints for table tblGoalLU

Indices

Name	Type	Fields
tblGoalLU_ProjGoalID	btree	GoalLUID
tblGoalLU_SortKey	btree	SortKey
tblGoalLU_pkey	btree	GoalLUID

Triggers

There are no triggers for table tblGoalLU

Rules

There are no rules for table tblGoalLU

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblProjGoal	public	tblProjGoal_GoalID_fkey	GoalID	public.tblGoalLU	GoalLUID	Cascade	Cascade		Immediate

Options

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

Definition


CREATE TABLE "public"."tblGoalLU" (
  "GoalLUID" SERIAL, 
  "Goal" VARCHAR(60), 
  "Comments" VARCHAR(200), 
  "SortKey" INTEGER DEFAULT 0, 
  "GoalCategory" VARCHAR(255), 
  CONSTRAINT "tblGoalLU_pkey" PRIMARY KEY("GoalLUID")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblGoalLU"
IS 'Lookup table containing different ecological outcomes';

CREATE INDEX "tblGoalLU_ProjGoalID" ON "public"."tblGoalLU"
  USING btree ("GoalLUID");

CREATE INDEX "tblGoalLU_SortKey" ON "public"."tblGoalLU"
  USING btree ("SortKey");

Pete Giencke
pgiencke@glc.org