Table xxxtblLocation

GLHI Database HTML Dump

Table: xxxtblLocation

Schema

glhri

Owner

wetlands

Tablespace

(default)

Descriptions

There is no description for table xxxtblLocation

Fields

Name	Data type	Default
ProjID	integer
LocDescript	varchar(255)
LocationID	varchar(13)
LocMeasureID	integer
SpatialTypeID	integer
USGSQuad	varchar(50)
USGS_HUC	varchar(50)
CongDist	varchar(50)
County	varchar(50)
StateAbr	varchar(50)
Latitude	numeric	0
Longitude	numeric	0
ShpLoc	text
Comments	text
ExistLandCvrID	integer	0
CenterLatitude	numeric
CenterLongitude	numeric

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time
tblLocation_ExistLandCvrID_fkey	ExistLandCvrID	glhri.xxxtblExistLandCvrLU	LandCvrID	Cascade	Cascade	Immediate
tblLocation_LocMeasureID_fkey	LocMeasureID	glhri.xxxtblLocDataSourceLU	LocDataID	Cascade	Cascade	Immediate
tblLocation_SpatialTypeID_fkey	SpatialTypeID	public.tblSpatialTypeLU	SpatialTypeID	Cascade	Cascade	Immediate
tblLocation_StateAbr_fkey	StateAbr	public.tblStateLU	StateID	Cascade	Cascade	Immediate

Checks

There are no check constraints for table xxxtblLocation

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblLocation_StateID	btree		StateAbr
tblLocation_pkey	btree		ProjID

Triggers

There are no triggers for table xxxtblLocation

Rules

There are no rules for table xxxtblLocation

Referenced

There are no tables referenced by table xxxtblLocation

Options

Option	Value
Inherited From
Rows	0
Pages	0
System
Temporary
With OID

Definition


CREATE TABLE "glhri"."xxxtblLocation" (
  "ProjID" INTEGER NOT NULL, 
  "LocDescript" VARCHAR(255), 
  "LocationID" VARCHAR(13), 
  "LocMeasureID" INTEGER, 
  "SpatialTypeID" INTEGER, 
  "USGSQuad" VARCHAR(50), 
  "USGS_HUC" VARCHAR(50), 
  "CongDist" VARCHAR(50), 
  "County" VARCHAR(50), 
  "StateAbr" VARCHAR(50), 
  "Latitude" NUMERIC DEFAULT 0, 
  "Longitude" NUMERIC DEFAULT 0, 
  "ShpLoc" TEXT, 
  "Comments" TEXT, 
  "ExistLandCvrID" INTEGER DEFAULT 0, 
  "CenterLatitude" NUMERIC, 
  "CenterLongitude" NUMERIC, 
  CONSTRAINT "tblLocation_pkey" PRIMARY KEY("ProjID"), 
  CONSTRAINT "tblLocation_ExistLandCvrID_fkey" FOREIGN KEY ("ExistLandCvrID")
    REFERENCES "glhri"."xxxtblExistLandCvrLU"("LandCvrID")
    ON DELETE CASCADE
    ON UPDATE CASCADE
    NOT DEFERRABLE, 
  CONSTRAINT "tblLocation_LocMeasureID_fkey" FOREIGN KEY ("LocMeasureID")
    REFERENCES "glhri"."xxxtblLocDataSourceLU"("LocDataID")
    ON DELETE CASCADE
    ON UPDATE CASCADE
    NOT DEFERRABLE, 
  CONSTRAINT "tblLocation_SpatialTypeID_fkey" FOREIGN KEY ("SpatialTypeID")
    REFERENCES "public"."tblSpatialTypeLU"("SpatialTypeID")
    ON DELETE CASCADE
    ON UPDATE CASCADE
    NOT DEFERRABLE, 
  CONSTRAINT "tblLocation_StateAbr_fkey" FOREIGN KEY ("StateAbr")
    REFERENCES "public"."tblStateLU"("StateID")
    ON DELETE CASCADE
    ON UPDATE CASCADE
    NOT DEFERRABLE
) WITHOUT OIDS;

CREATE INDEX "tblLocation_StateID" ON "glhri"."xxxtblLocation"
  USING btree ("StateAbr");

Pete Giencke
pgiencke@glc.org