Table tblContactsLU

GLHI Database HTML Dump

Table: tblContactsLU

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

A pretty basic table used to store user information for point of contact information, user administration, etc

Fields

Name	Data type	Default	Description
ContactID	integer	nextval('"tblContactsLU_ContactID_seq"'::regclass)
LastName	varchar(50)
FirstName	varchar(50)
Title	varchar(50)
OrgID	integer	0
WorkPhone	varchar(50)
WorkExt	varchar(50)
Phone2	varchar(50)
Cell	varchar(50)
Fax	varchar(50)
Email	varchar(50)
Address1	varchar(50)
Address2	varchar(50)
City	varchar(50)
Zipcode	integer	0
OrgTypeID	integer	0	Specifies a users group which allows other users of the same group to edit a project
Website	text
CurrentInfo	boolean
UpdateDate	timestamp
Comments	text
Confidential	boolean	false
StateID	integer		key to state FIPS
activated	boolean	false
confirmhash	varchar(100)

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time
tblContactsLU_fk	StateID	public.tblStateLU	StateID	No Action	No Action	Immediate
tblContactsLU_fk1	StateID	public.tblStateLU	StateID	No Action	No Action	Immediate
tblContactsLU_fk2	OrgID	public.tblOrganizationLU	OrgID	No Action	No Action	Immediate

Checks

There are no check constraints for table tblContactsLU

Indices

Name	Type	Fields
tblContactsLU_ContactID	btree	ContactID
tblContactsLU_OrgCategoryID	btree	OrgTypeID
tblContactsLU_OrgID	btree	OrgID
tblContactsLU_Zipcode	btree	Zipcode
tblContactsLU_pkey	btree	ContactID

Triggers

There are no triggers for table tblContactsLU

Rules

There are no rules for table tblContactsLU

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time
tblContactsAdmin	public	tblContactsAdmin_fk	ContactID	public.tblContactsLU	ContactID	No Action	No Action	Immediate
tblProject	public	test	CreatedByID	public.tblContactsLU	ContactID	No Action	No Action	Immediate
xxxtblProjXContact	glhri	tblProjXContact_ContactID_fkey	ContactID	public.tblContactsLU	ContactID	Cascade	Cascade	Immediate

Options

Option	Value
Inherited From
Rows	103
Pages	5
System
Temporary
With OID

Definition


CREATE TABLE "public"."tblContactsLU" (
  "ContactID" SERIAL, 
  "LastName" VARCHAR(50) NOT NULL, 
  "FirstName" VARCHAR(50) NOT NULL, 
  "Title" VARCHAR(50), 
  "OrgID" INTEGER DEFAULT 0 NOT NULL, 
  "WorkPhone" VARCHAR(50) NOT NULL, 
  "WorkExt" VARCHAR(50), 
  "Phone2" VARCHAR(50), 
  "Cell" VARCHAR(50), 
  "Fax" VARCHAR(50), 
  "Email" VARCHAR(50) NOT NULL, 
  "Address1" VARCHAR(50), 
  "Address2" VARCHAR(50), 
  "City" VARCHAR(50), 
  "Zipcode" INTEGER DEFAULT 0, 
  "OrgTypeID" INTEGER DEFAULT 0, 
  "Website" TEXT, 
  "CurrentInfo" BOOLEAN, 
  "UpdateDate" TIMESTAMP WITHOUT TIME ZONE, 
  "Comments" TEXT, 
  "Confidential" BOOLEAN DEFAULT false, 
  "StateID" INTEGER, 
  "activated" BOOLEAN DEFAULT false NOT NULL, 
  "confirmhash" VARCHAR(100), 
  CONSTRAINT "tblContactsLU_pkey" PRIMARY KEY("ContactID"), 
  CONSTRAINT "tblContactsLU_fk" FOREIGN KEY ("StateID")
    REFERENCES "public"."tblStateLU"("StateID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "tblContactsLU_fk1" FOREIGN KEY ("StateID")
    REFERENCES "public"."tblStateLU"("StateID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE, 
  CONSTRAINT "tblContactsLU_fk2" FOREIGN KEY ("OrgID")
    REFERENCES "public"."tblOrganizationLU"("OrgID")
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    NOT DEFERRABLE
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblContactsLU"
IS 'A pretty basic table used to store user information for point of contact information, user administration, etc';

COMMENT ON COLUMN "public"."tblContactsLU"."OrgTypeID"
IS 'Specifies a users group which allows other users of the same group to edit a project';

COMMENT ON COLUMN "public"."tblContactsLU"."StateID"
IS 'key to state FIPS';

CREATE INDEX "tblContactsLU_ContactID" ON "public"."tblContactsLU"
  USING btree ("ContactID");

CREATE INDEX "tblContactsLU_OrgCategoryID" ON "public"."tblContactsLU"
  USING btree ("OrgTypeID");

CREATE INDEX "tblContactsLU_OrgID" ON "public"."tblContactsLU"
  USING btree ("OrgID");

CREATE INDEX "tblContactsLU_Zipcode" ON "public"."tblContactsLU"
  USING btree ("Zipcode");

Pete Giencke
pgiencke@glc.org