Table tblHabTypeLU

GLHI Database HTML Dump

Table: tblHabTypeLU

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Lookup table to store NERI (et al) derived habitat types

Fields

PK	FK	Name	Data type	Not null	Unique	Inherited	Default	Description
		HabitatLUID	integer
		SOURCE	varchar(50)
		HABITAT_TYPE	varchar(100)
		HABITAT_CATEGORY	varchar(50)

Foreign Keys

There are no foreign keys for table tblHabTypeLU

Checks

There are no check constraints for table tblHabTypeLU

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblHabTypeLU2_pkey	btree		HabitatLUID

Triggers

There are no triggers for table tblHabTypeLU

Rules

There are no rules for table tblHabTypeLU

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblHabitat	public	tblHabitat_fk2	HabitatType	public.tblHabTypeLU	HabitatLUID	No Action	No Action		Immediate

Options

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

Definition


CREATE TABLE "public"."tblHabTypeLU" (
  "HabitatLUID" INTEGER NOT NULL, 
  "SOURCE" VARCHAR(50), 
  "HABITAT_TYPE" VARCHAR(100), 
  "HABITAT_CATEGORY" VARCHAR(50), 
  CONSTRAINT "tblHabTypeLU2_pkey" PRIMARY KEY("HabitatLUID")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblHabTypeLU"
IS 'Lookup table to store NERI (et al) derived habitat types';

Pete Giencke
pgiencke@glc.org