Table tblOrgTypeLU

GLHI Database HTML Dump

Table: tblOrgTypeLU

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Lookup table describing the different organizational entities to be encountered in this project (ie federal, state, etc)

Fields

PK	FK	Name	Data type	Not null	Unique	Inherited	Default	Description
		OrgTypeID	integer				nextval('"tblOrgTypeLU_OrgTypeID_seq"'::regclass)
		OrgType	varchar(50)

Foreign Keys

There are no foreign keys for table tblOrgTypeLU

Checks

There are no check constraints for table tblOrgTypeLU

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblOrgTypeLU_number	btree		OrgTypeID
tblOrgTypeLU_pkey	btree		OrgTypeID

Triggers

There are no triggers for table tblOrgTypeLU

Rules

There are no rules for table tblOrgTypeLU

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblLandOwnership	public	tblLandOwnership_fk	LandOwnershipID	public.tblOrgTypeLU	OrgTypeID	No Action	No Action		Immediate
tblOrganizationLU	public	tblOrganizationLU_fk	OrgTypeID	public.tblOrgTypeLU	OrgTypeID	No Action	No Action		Immediate

Options

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

Definition


CREATE TABLE "public"."tblOrgTypeLU" (
  "OrgTypeID" SERIAL, 
  "OrgType" VARCHAR(50), 
  CONSTRAINT "tblOrgTypeLU_pkey" PRIMARY KEY("OrgTypeID")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblOrgTypeLU"
IS 'Lookup table describing the different organizational entities to be encountered in this project (ie federal, state, etc)';

CREATE INDEX "tblOrgTypeLU_number" ON "public"."tblOrgTypeLU"
  USING btree ("OrgTypeID");

Pete Giencke
pgiencke@glc.org