Dumped on 2009-02-06

Index of database - gnowsys

Schema auth_schema

Table: auth_schema.roles

auth_schema.roles Structure
F-Key Name Type Description
username character varying(20)
rolename character varying(20)

Index - Schema auth_schema

Table: auth_schema.users

auth_schema.users Structure
F-Key Name Type Description
username character varying(20) NOT NULL
password character varying(45)
fullname character varying(30)
email character varying(50)

Index - Schema auth_schema

Schema public

standard public schema

Table: public.datatypes_abstime

public.datatypes_abstime Structure
F-Key Name Type Description
subject_inid bigint
value abstime
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_aclitem

public.datatypes_aclitem Structure
F-Key Name Type Description
subject_inid bigint
value aclitem
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_bit

public.datatypes_bit Structure
F-Key Name Type Description
subject_inid bigint
value bit(1)
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_boolean

public.datatypes_boolean Structure
F-Key Name Type Description
subject_inid bigint
value boolean
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_box

public.datatypes_box Structure
F-Key Name Type Description
subject_inid bigint
value box
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_bpchar

public.datatypes_bpchar Structure
F-Key Name Type Description
subject_inid bigint
value bpchar
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_bytea

public.datatypes_bytea Structure
F-Key Name Type Description
subject_inid bigint
value bytea
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_char

public.datatypes_char Structure
F-Key Name Type Description
subject_inid bigint
value character(1)
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_cid

public.datatypes_cid Structure
F-Key Name Type Description
subject_inid bigint
value cid
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_cidr

public.datatypes_cidr Structure
F-Key Name Type Description
subject_inid bigint
value cidr
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_circle

public.datatypes_circle Structure
F-Key Name Type Description
subject_inid bigint
value circle
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_date

public.datatypes_date Structure
F-Key Name Type Description
subject_inid bigint
value date
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_float4

public.datatypes_float4 Structure
F-Key Name Type Description
subject_inid bigint
value real
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_float8

public.datatypes_float8 Structure
F-Key Name Type Description
subject_inid bigint
value double precision
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_inet

public.datatypes_inet Structure
F-Key Name Type Description
subject_inid bigint
value inet
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_int2

public.datatypes_int2 Structure
F-Key Name Type Description
subject_inid bigint
value smallint
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_int2vector

public.datatypes_int2vector Structure
F-Key Name Type Description
subject_inid bigint
value int2vector
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_int4

public.datatypes_int4 Structure
F-Key Name Type Description
subject_inid bigint
value integer
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_int8

public.datatypes_int8 Structure
F-Key Name Type Description
subject_inid bigint
value bigint
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_interval

public.datatypes_interval Structure
F-Key Name Type Description
subject_inid bigint
value interval
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_line

public.datatypes_line Structure
F-Key Name Type Description
subject_inid bigint
value line
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_lseg

public.datatypes_lseg Structure
F-Key Name Type Description
subject_inid bigint
value lseg
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_macaddr

public.datatypes_macaddr Structure
F-Key Name Type Description
subject_inid bigint
value macaddr
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_money

public.datatypes_money Structure
F-Key Name Type Description
subject_inid bigint
value money
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_name

public.datatypes_name Structure
F-Key Name Type Description
subject_inid bigint
value name
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_numeric

public.datatypes_numeric Structure
F-Key Name Type Description
subject_inid bigint
value numeric
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_oid

public.datatypes_oid Structure
F-Key Name Type Description
subject_inid bigint
value oid
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_oidvector

public.datatypes_oidvector Structure
F-Key Name Type Description
subject_inid bigint
value oidvector
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_path

public.datatypes_path Structure
F-Key Name Type Description
subject_inid bigint
value path
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_point

public.datatypes_point Structure
F-Key Name Type Description
subject_inid bigint
value point
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_polygon

public.datatypes_polygon Structure
F-Key Name Type Description
subject_inid bigint
value polygon
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_refcursor

public.datatypes_refcursor Structure
F-Key Name Type Description
subject_inid bigint
value refcursor
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_regclass

public.datatypes_regclass Structure
F-Key Name Type Description
subject_inid bigint
value regclass
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_regoper

public.datatypes_regoper Structure
F-Key Name Type Description
subject_inid bigint
value regoper
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_regoperator

public.datatypes_regoperator Structure
F-Key Name Type Description
subject_inid bigint
value regoperator
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_regproc

public.datatypes_regproc Structure
F-Key Name Type Description
subject_inid bigint
value regproc
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_regprocedure

public.datatypes_regprocedure Structure
F-Key Name Type Description
subject_inid bigint
value regprocedure
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_regtype

public.datatypes_regtype Structure
F-Key Name Type Description
subject_inid bigint
value regtype
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_reltime

public.datatypes_reltime Structure
F-Key Name Type Description
subject_inid bigint
value reltime
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_serial

public.datatypes_serial Structure
F-Key Name Type Description
subject_inid bigint
value integer NOT NULL
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_serial8

public.datatypes_serial8 Structure
F-Key Name Type Description
subject_inid bigint
value bigint NOT NULL
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_smgr

public.datatypes_smgr Structure
F-Key Name Type Description
subject_inid bigint
value smgr
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_text

public.datatypes_text Structure
F-Key Name Type Description
subject_inid bigint
value text
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying
value_text_vec tsvector

Index - Schema public

Table: public.datatypes_tid

public.datatypes_tid Structure
F-Key Name Type Description
subject_inid bigint
value tid
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_time

public.datatypes_time Structure
F-Key Name Type Description
subject_inid bigint
value time without time zone
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_timestamptz

public.datatypes_timestamptz Structure
F-Key Name Type Description
subject_inid bigint
value timestamp with time zone
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_timetz

public.datatypes_timetz Structure
F-Key Name Type Description
subject_inid bigint
value time with time zone
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_tinterval

public.datatypes_tinterval Structure
F-Key Name Type Description
subject_inid bigint
value tinterval
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_unknown

public.datatypes_unknown Structure
F-Key Name Type Description
subject_inid bigint
value unknown
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_varbit

public.datatypes_varbit Structure
F-Key Name Type Description
subject_inid bigint
value bit varying
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.datatypes_varchar

public.datatypes_varchar Structure
F-Key Name Type Description
subject_inid bigint
value character varying
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying
value_text_vec tsvector

Index - Schema public

Table: public.datatypes_xid

public.datatypes_xid Structure
F-Key Name Type Description
subject_inid bigint
value xid
public.gbattributes.ssid attribute_ssid bigint
public.gbattributetypes.ssid attributetype_ssid bigint
language character varying

Index - Schema public

Table: public.gbattributes

public.gbattributes Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL
inid bigint NOT NULL
uid bigint NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
datatype character varying
rendered_nbh text
nbh text

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.gbattributetypes

public.gbattributetypes Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL
inid bigint NOT NULL
uid bigint NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
restrictiontype integer
restrictionref bigint
rendered_nbh text
nbh text

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.gbcatalogpoststate

public.gbcatalogpoststate Structure
F-Key Name Type Description
public.gbprocess.ssid ssid bigint NOT NULL
poststate bigint NOT NULL

Index - Schema public

Table: public.gbcatalogpoststatedef

public.gbcatalogpoststatedef Structure
F-Key Name Type Description
public.gbprocesstypes.ssid ssid bigint NOT NULL
poststatedef bigint NOT NULL

Index - Schema public

Table: public.gbcatalogpriorstate

public.gbcatalogpriorstate Structure
F-Key Name Type Description
public.gbprocess.ssid ssid bigint NOT NULL
priorstate bigint NOT NULL

Index - Schema public

Table: public.gbcatalogpriorstatedef

public.gbcatalogpriorstatedef Structure
F-Key Name Type Description
public.gbprocesstypes.ssid ssid bigint NOT NULL
priorstatedef bigint NOT NULL

Index - Schema public

Table: public.gbcatalogrelationtypes

public.gbcatalogrelationtypes Structure
F-Key Name Type Description
public.gbrelationtypes.ssid relationtypeid bigint NOT NULL
roletypeid bigint NOT NULL

Index - Schema public

Table: public.gbcatalogsubjecttypes

public.gbcatalogsubjecttypes Structure
F-Key Name Type Description
public.gbattributetypes.ssid attributetypeid bigint NOT NULL
subjecttypeid bigint NOT NULL
applicablenodetypes character varying

Index - Schema public

Table: public.gbmandatoryprops

public.gbmandatoryprops Structure
F-Key Name Type Description
ssid bigint NOT NULL
mandatoryprops character varying NOT NULL

Index - Schema public

Table: public.gbmetatypes

public.gbmetatypes Structure
F-Key Name Type Description
ssid bigint UNIQUE NOT NULL
nid character varying NOT NULL
inid bigint NOT NULL
uid bigint NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
rendered_nbh text
nbh text

Index - Schema public

Table: public.gbnid_latestssid

public.gbnid_latestssid Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL

Index - Schema public

Table: public.gbnidssid

public.gbnidssid Structure
F-Key Name Type Description
ssid bigint NOT NULL
nid character varying NOT NULL
inid bigint NOT NULL
nodetype character varying NOT NULL

Index - Schema public

Table: public.gbobjects

public.gbobjects Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL
inid bigint NOT NULL
uid bigint NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
rendered_nbh text
nbh text

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.gbobjecttypes

public.gbobjecttypes Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL
inid bigint NOT NULL
uid bigint NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
rendered_nbh text
nbh text

Index - Schema public

Table: public.gbprocess

public.gbprocess Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL
inid bigint NOT NULL
uid bigint NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
rendered_nbh text
nbh text

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.gbprocesstypes

public.gbprocesstypes Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL
inid bigint NOT NULL
uid bigint NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
rendered_nbh text
nbh text

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.gbregularexpressions

public.gbregularexpressions Structure
F-Key Name Type Description
regexid serial UNIQUE NOT NULL
expression character varying
description text

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.gbrelations

public.gbrelations Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL
inid bigint NOT NULL
uid bigint NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
relationtype bigint
subject1 bigint
subject2 bigint
rendered_nbh text
nbh text

Index - Schema public

Table: public.gbrelationtypes

public.gbrelationtypes Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL
inid bigint NOT NULL
inversename character varying
uid bigint NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
istransitive boolean
isreflexive boolean
issymmetrical boolean
rendered_nbh text
nbh text

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: public.gbroletypes

public.gbroletypes Structure
F-Key Name Type Description
rtid serial NOT NULL
subjecttype1 bigint NOT NULL
subjecttype2 bigint NOT NULL
cardinality1 integer NOT NULL
cardinality2 integer NOT NULL
applicablenodetypes1 character varying
applicablenodetypes2 character varying

Index - Schema public

Table: public.gbselectionlist

public.gbselectionlist Structure
F-Key Name Type Description
selid serial UNIQUE NOT NULL
selectiontype boolean NOT NULL
datatype character varying NOT NULL
public.gbobjects.ssid listid bigint NOT NULL

Index - Schema public

Table: public.gbusers

public.gbusers Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL
inid bigint NOT NULL
uid serial NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
rendered_nbh text
nbh text

Index - Schema public

Table: public.gbusertypes

public.gbusertypes Structure
F-Key Name Type Description
ssid bigint PRIMARY KEY
nid character varying NOT NULL
inid bigint NOT NULL
uid bigint NOT NULL
status character varying
noofchanges integer NOT NULL
fieldschanged character varying[] NOT NULL
changetype bigint[] NOT NULL
noofcommits integer NOT NULL
noofchangesaftercommit integer NOT NULL
history bigint[] NOT NULL
gbtimestamp timestamp with time zone DEFAULT now()
rendered_nbh text
nbh text

Index - Schema public

Table: public.gbvaluerestrictions

public.gbvaluerestrictions Structure
F-Key Name Type Description
restrictionid serial UNIQUE NOT NULL
datatype character varying
description text
public.gbregularexpressions.regexid regexid bigint
length bigint
range character varying
precision integer

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict