Table tblRealEstate

GLHI Database HTML Dump

Table: tblRealEstate

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Table to capture real estate interests within project area.

Fields

Name	Data type	Default	Description
RealEstateID	integer	nextval('"tblRealEstate_RealEstateID_seq"'::regclass)
PROJECT_ID	integer	nextval('"tblRealEstate_PROJECT_ID_seq"'::regclass)
GeographyID	integer
RealEstateInterest	integer		Field to capture real estate interests within project area. FORM: "Real estate interest"

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time
tblRealEstate_fk	GeographyID	public.tblProjectGeography	GeographyID	No Action	No Action	Immediate
tblRealEstate_fk1	RealEstateInterest	public.tblOrganizationLU	OrgID	No Action	No Action	Immediate
tblRealEstate_fk2	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action	Immediate

Checks

There are no check constraints for table tblRealEstate

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblRealEstate_pkey	btree		RealEstateID

Triggers

There are no triggers for table tblRealEstate

Rules

There are no rules for table tblRealEstate

Referenced

There are no tables referenced by table tblRealEstate

Options

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

Definition


CREATE TABLE "public"."tblRealEstate" (
  "RealEstateID" SERIAL, 
  "PROJECT_ID" SERIAL, 
  "GeographyID" INTEGER, 
  "RealEstateInterest" INTEGER, 
  CONSTRAINT "tblRealEstate_pkey" PRIMARY KEY("RealEstateID"), 
  CONSTRAINT "tblRealEstate_fk" FOREIGN KEY ("GeographyID")
    REFERENCES "public"."tblProjectGeography"("GeographyID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "tblRealEstate_fk1" FOREIGN KEY ("RealEstateInterest")
    REFERENCES "public"."tblOrganizationLU"("OrgID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "tblRealEstate_fk2" 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"."tblRealEstate"
IS 'Table to capture real estate interests within project area.';

COMMENT ON COLUMN "public"."tblRealEstate"."RealEstateInterest"
IS 'Field to capture real estate interests within project area.

FORM: "Real estate interest"';

Pete Giencke
pgiencke@glc.org