Table tblSpatialTypeLU

GLHI Database HTML Dump

Table: tblSpatialTypeLU

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

For now, a field to describe the project geography type. Will likely get superceded by a PostGIS description.

Fields

PK	FK	Name	Data type	Not null	Unique	Inherited	Default	Description
		SpatialTypeID	integer				nextval('"tblSpatialTypeLU_SpatialTypeID_seq"'::regclass)
		SpatialType	varchar(80)

Foreign Keys

There are no foreign keys for table tblSpatialTypeLU

Checks

There are no check constraints for table tblSpatialTypeLU

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblSpatialTypeLU_SpatialTypeID	btree		SpatialTypeID
tblSpatialTypeLU_pkey	btree		SpatialTypeID

Triggers

There are no triggers for table tblSpatialTypeLU

Rules

There are no rules for table tblSpatialTypeLU

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblProjectGeography	public	ProjectGeography_fk6	xSpatialTypeID	public.tblSpatialTypeLU	SpatialTypeID	No Action	No Action		Immediate
xxxtblLocation	glhri	tblLocation_SpatialTypeID_fkey	SpatialTypeID	public.tblSpatialTypeLU	SpatialTypeID	Cascade	Cascade		Immediate

Options

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

Definition


CREATE TABLE "public"."tblSpatialTypeLU" (
  "SpatialTypeID" SERIAL, 
  "SpatialType" VARCHAR(80), 
  CONSTRAINT "tblSpatialTypeLU_pkey" PRIMARY KEY("SpatialTypeID")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblSpatialTypeLU"
IS 'For now, a field to describe the project geography type. Will likely get superceded by a PostGIS description.';

CREATE INDEX "tblSpatialTypeLU_SpatialTypeID" ON "public"."tblSpatialTypeLU"
  USING btree ("SpatialTypeID");

Pete Giencke
pgiencke@glc.org