Table xxxtblProjTypeLU

GLHI Database HTML Dump

Table: xxxtblProjTypeLU

Schema

glhri

Owner

wetlands

Tablespace

(default)

Descriptions

There is no description for table xxxtblProjTypeLU

Fields

Name	Data type	Default
ProjTypeID	integer	nextval('"xxxtblProjTypeLU_ProjTypeID_seq"'::regclass)
ProjCategory	varchar(50)
ProjType	varchar(50)
TypeDescript	text
SortKey	integer	0

Foreign Keys

There are no foreign keys for table xxxtblProjTypeLU

Checks

There are no check constraints for table xxxtblProjTypeLU

Indices

Name	Type	Fields
tblProjTypeLU_ProjTypeID1	btree	ProjTypeID
tblProjTypeLU_SortKey	btree	SortKey
tblProjTypeLU_pkey	btree	ProjTypeID

Triggers

There are no triggers for table xxxtblProjTypeLU

Rules

There are no rules for table xxxtblProjTypeLU

Referenced

There are no tables referenced by table xxxtblProjTypeLU

Options

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

Definition


CREATE TABLE "glhri"."xxxtblProjTypeLU" (
  "ProjTypeID" SERIAL, 
  "ProjCategory" VARCHAR(50), 
  "ProjType" VARCHAR(50), 
  "TypeDescript" TEXT, 
  "SortKey" INTEGER DEFAULT 0, 
  CONSTRAINT "tblProjTypeLU_pkey" PRIMARY KEY("ProjTypeID")
) WITHOUT OIDS;

CREATE INDEX "tblProjTypeLU_ProjTypeID1" ON "glhri"."xxxtblProjTypeLU"
  USING btree ("ProjTypeID");

CREATE INDEX "tblProjTypeLU_SortKey" ON "glhri"."xxxtblProjTypeLU"
  USING btree ("SortKey");

Pete Giencke
pgiencke@glc.org