Table tblHucs

GLHI Database HTML Dump

Table: tblHucs

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Table to hold automatically populated hydrologic unit code (HUC) data for project area. Table uses standard USGS naming conventions for field names.

FORM: AUTOMATICALLY POPULATED

Fields

Name	Data type	Default
tblHucsID	integer	nextval('"tblHucs_tblHucsID_seq"'::regclass)
PROJECT_ID	integer
GeographyID	integer
huc_code	integer
huc_name	varchar(255)
reg	integer
sub	integer

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
tblHucs_fk	PROJECT_ID	public.tblProject	PROJECT_ID	No Action	No Action		Immediate
tblHucs_fk1	GeographyID	public.tblProjectGeography	GeographyID	No Action	No Action		Immediate

Checks

There are no check constraints for table tblHucs

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblHucs_pkey	btree		tblHucsID

Triggers

There are no triggers for table tblHucs

Rules

There are no rules for table tblHucs

Referenced

There are no tables referenced by table tblHucs

Options

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

Definition


CREATE TABLE "public"."tblHucs" (
  "tblHucsID" SERIAL, 
  "PROJECT_ID" INTEGER, 
  "GeographyID" INTEGER, 
  "huc_code" INTEGER, 
  "huc_name" VARCHAR(255), 
  "reg" INTEGER, 
  "sub" INTEGER, 
  CONSTRAINT "tblHucs_pkey" PRIMARY KEY("tblHucsID"), 
  CONSTRAINT "tblHucs_fk" FOREIGN KEY ("PROJECT_ID")
    REFERENCES "public"."tblProject"("PROJECT_ID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "tblHucs_fk1" FOREIGN KEY ("GeographyID")
    REFERENCES "public"."tblProjectGeography"("GeographyID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblHucs"
IS 'Table to hold automatically populated hydrologic unit code (HUC) data for project area. Table uses standard USGS naming conventions for field names.

FORM: AUTOMATICALLY POPULATED';

Pete Giencke
pgiencke@glc.org