Table xxxtblRoleLU

GLHI Database HTML Dump

Table: xxxtblRoleLU

Schema

glhri

Owner

wetlands

Tablespace

(default)

Descriptions

There is no description for table xxxtblRoleLU

Fields

PK	FK	Name	Data type	Not null	Unique	Inherited	Default	Description
		RoleID	integer				0
		Role	varchar(75)

Foreign Keys

There are no foreign keys for table xxxtblRoleLU

Checks

There are no check constraints for table xxxtblRoleLU

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblRoleLU_RoleID	btree		RoleID
tblRoleLU_pkey	btree		RoleID

Triggers

There are no triggers for table xxxtblRoleLU

Rules

There are no rules for table xxxtblRoleLU

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
xxxtblProjXContact	glhri	tblProjXContact_RoleID_fkey	RoleID	glhri.xxxtblRoleLU	RoleID	Cascade	Cascade		Immediate

Options

Option	Value
Inherited From
Rows	11
Pages	1
System
Temporary
With OID

Definition


CREATE TABLE "glhri"."xxxtblRoleLU" (
  "RoleID" INTEGER DEFAULT 0 NOT NULL, 
  "Role" VARCHAR(75), 
  CONSTRAINT "tblRoleLU_pkey" PRIMARY KEY("RoleID")
) WITHOUT OIDS;

CREATE INDEX "tblRoleLU_RoleID" ON "glhri"."xxxtblRoleLU"
  USING btree ("RoleID");

Pete Giencke
pgiencke@glc.org