Table xxxtblProjTargetSpp

GLHI Database HTML Dump

Table: xxxtblProjTargetSpp

Schema

glhri

Owner

wetlands

Tablespace

(default)

Descriptions

There is no description for table xxxtblProjTargetSpp

Fields

PK	FK	Name	Data type	Not null	Unique	Inherited	Default	Description
		ProjID	integer
		SppID	integer				0

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblProjTargetSpp_SppID_fkey	SppID	glhri.xxxtblspeciesLU	SPPID	Cascade	Cascade		Immediate

Checks

There are no check constraints for table xxxtblProjTargetSpp

Indices

There are no indices for table xxxtblProjTargetSpp

Triggers

There are no triggers for table xxxtblProjTargetSpp

Rules

There are no rules for table xxxtblProjTargetSpp

Referenced

There are no tables referenced by table xxxtblProjTargetSpp

Options

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

Definition


CREATE TABLE "glhri"."xxxtblProjTargetSpp" (
  "ProjID" INTEGER, 
  "SppID" INTEGER DEFAULT 0, 
  CONSTRAINT "tblProjTargetSpp_SppID_fkey" FOREIGN KEY ("SppID")
    REFERENCES "glhri"."xxxtblspeciesLU"("SPPID")
    ON DELETE CASCADE
    ON UPDATE CASCADE
    NOT DEFERRABLE
) WITHOUT OIDS;

Pete Giencke
pgiencke@glc.org