GLHI Database HTML Dump

Table: tblProjectSignificance

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

A table describing the project's significance to the Great Lakes Regional Collaboration Strategy

FORM: "Relevancy to Great Lakes Regional Collaboration Strategy"

Fields

Foreign Keys

Checks

There are no check constraints for table tblProjectSignificance

Indices

Triggers

There are no triggers for table tblProjectSignificance

Rules

There are no rules for table tblProjectSignificance

Referenced

Options

Definition

CREATE TABLE "public"."tblProjectSignificance" (
  "ProjectSignificanceID" SERIAL, 
  "ProjectID" INTEGER NOT NULL, 
  "SignificanceID" INTEGER NOT NULL, 
  CONSTRAINT "ProjectSignificance_pkey" PRIMARY KEY("ProjectSignificanceID"), 
  CONSTRAINT "ProjectSignificance_fk" FOREIGN KEY ("SignificanceID")
    REFERENCES "public"."tblProjectSignificanceLU"("ProjectSignificanceLUID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "tblProjectSignificance_fk" FOREIGN KEY ("ProjectID")
    REFERENCES "public"."tblProject"("PROJECT_ID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblProjectSignificance"
IS 'A table describing the project''s significance to the Great Lakes Regional Collaboration Strategy

FORM: "Relevancy to Great Lakes Regional Collaboration Strategy"';

Pete Giencke pgiencke@glc.org