Table tblLimitingFactorLU

GLHI Database HTML Dump

Table: tblLimitingFactorLU

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Project area stressors lookup table

Fields

Name	Data type	Default
LimitingFactorLUID	integer	nextval('"tblLimitingFactorLU2_LmtFctrID_seq"'::regclass)
LimitingFactor	varchar(75)
LimitingCategory	varchar(75)

Foreign Keys

There are no foreign keys for table tblLimitingFactorLU

Checks

There are no check constraints for table tblLimitingFactorLU

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblLimitingFactorLU2_LmtFctID	btree		LimitingFactorLUID
tblLimitingFactorLU2_pkey	btree		LimitingFactorLUID

Triggers

There are no triggers for table tblLimitingFactorLU

Rules

There are no rules for table tblLimitingFactorLU

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblLimitingFactor	public	tblLimitingFactor_fk1	LimitingFactor	public.tblLimitingFactorLU	LimitingFactorLUID	No Action	No Action		Immediate

Options

Option	Value
Inherited From
Rows	22
Pages	1
System
Temporary
With OID

Definition


CREATE TABLE "public"."tblLimitingFactorLU" (
  "LimitingFactorLUID" SERIAL, 
  "LimitingFactor" VARCHAR(75), 
  "LimitingCategory" VARCHAR(75), 
  CONSTRAINT "tblLimitingFactorLU2_pkey" PRIMARY KEY("LimitingFactorLUID")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblLimitingFactorLU"
IS 'Project area stressors lookup table';

CREATE INDEX "tblLimitingFactorLU2_LmtFctID" ON "public"."tblLimitingFactorLU"
  USING btree ("LimitingFactorLUID");

Pete Giencke
pgiencke@glc.org