Table tblTableChanges

GLHI Database HTML Dump

Table: tblTableChanges

Schema

public

Owner

wetlands

Tablespace

(default)

Descriptions

Placeholder table for table changes

Fields

Name	Data type	Default
SeqID	integer	nextval('"tblTableChanges_SeqID_seq"'::regclass)
TableName	varchar(50)
ProjID	integer
FieldName	varchar(50)
OldValue	varchar(100)
ChangeDate	timestamp
CreatedByID	integer

Foreign Keys

There are no foreign keys for table tblTableChanges

Checks

There are no check constraints for table tblTableChanges

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
tblTableChanges_pkey	btree		SeqID, TableName, ProjID

Triggers

There are no triggers for table tblTableChanges

Rules

There are no rules for table tblTableChanges

Referenced

There are no tables referenced by table tblTableChanges

Options

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

Definition


CREATE TABLE "public"."tblTableChanges" (
  "SeqID" SERIAL, 
  "TableName" VARCHAR(50) NOT NULL, 
  "ProjID" INTEGER NOT NULL, 
  "FieldName" VARCHAR(50), 
  "OldValue" VARCHAR(100), 
  "ChangeDate" TIMESTAMP WITHOUT TIME ZONE, 
  "CreatedByID" INTEGER, 
  CONSTRAINT "tblTableChanges_pkey" PRIMARY KEY("SeqID", "TableName", "ProjID")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."tblTableChanges"
IS 'Placeholder table for table changes';

Pete Giencke
pgiencke@glc.org