Table tblThreats

GLHI Database HTML Dump

Table: tblThreats

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Table containing threats related to project area. Types derived from IUCN - CMP Threat Definitions.

FORM: "Ecological Stressors/Threats Affecting Area"

Fields

Name	Data type	Default
ThreatID	integer	nextval('glhri."tblThreats_ThreatID_seq"'::regclass)
ThreatTypeID	integer
PROJECT_ID	integer

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblThreats_fk	ThreatTypeID	public.tblThreatsLU	ThreatLUID	No Action	No Action		Immediate
tblThreats_fk1	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action		Immediate

Checks

There are no check constraints for table tblThreats

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblThreats_ThreatTypeID_key	btree		ThreatTypeID
tblThreats_pkey1	btree		ThreatID

Triggers

There are no triggers for table tblThreats

Rules

There are no rules for table tblThreats

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblRestoration	public	tblRestoration_fk5	ThreatsID	public.tblThreats	ThreatID	No Action	No Action		Immediate

Options

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

Definition


CREATE TABLE "public"."tblThreats" (
  "ThreatID" SERIAL, 
  "ThreatTypeID" INTEGER, 
  "PROJECT_ID" INTEGER NOT NULL, 
  CONSTRAINT "tblThreats_pkey1" PRIMARY KEY("ThreatID"), 
  CONSTRAINT "tblThreats_fk" FOREIGN KEY ("ThreatTypeID")
    REFERENCES "public"."tblThreatsLU"("ThreatLUID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "tblThreats_fk1" FOREIGN KEY ("PROJECT_ID")
    REFERENCES "public"."tblProject"("PROJECT_ID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblThreats"
IS 'Table containing threats related to project area. Types derived from IUCN - CMP Threat Definitions.

FORM: "Ecological Stressors/Threats Affecting Area"';

CREATE UNIQUE INDEX "tblThreats_ThreatTypeID_key" ON "public"."tblThreats"
  USING btree ("ThreatTypeID");

Pete Giencke
pgiencke@glc.org