Autogenerated on Mon, 17 Dec 2007 09:19:36 +0000

gbnidinid
Field name	Field Type	Constraint
nid	varchar	UNIQUE ( nid, nodetype )
inid	serial8	PRIMARY KEY
nodetype	varchar	UNIQUE ( nid, nodetype )

gbinidssid
Field name	Field Type	Constraint
inid	int8	REFERENCES gbnidinid ( inid )
ssid	serial8	PRIMARY KEY
nodetype	varchar

gbmetatypes_status
Field name	Field Type	Constraint
status_fid	serial8	PRIMARY KEY
status_value	varchar	UNIQUE

gbmetatypes_uri
Field name	Field Type	Constraint
uri_fid	serial8	PRIMARY KEY
uri_value	varchar	UNIQUE

gbmetatypes_title
Field name	Field Type	Constraint
title_fid	serial8	PRIMARY KEY
title_value	varchar[]	UNIQUE

gbmetatypes_description
Field name	Field Type	Constraint
description_fid	serial8	PRIMARY KEY
description_value	text	UNIQUE

gbmetatypes_attributetypes
Field name	Field Type	Constraint
attributetypes_fid	serial8	PRIMARY KEY
attributetypes_value	int8[]	UNIQUE

gbmetatypes_attributes
Field name	Field Type	Constraint
attributes_fid	serial8	PRIMARY KEY
attributes_value	int8[]	UNIQUE

gbmetatypes_relationtypes
Field name	Field Type	Constraint
relationtypes_fid	serial8	PRIMARY KEY
relationtypes_value	int8[]	UNIQUE

gbmetatypes_relations
Field name	Field Type	Constraint
relations_fid	serial8	PRIMARY KEY
relations_value	int8[]	UNIQUE

gbmetatypes_subtypeof
Field name	Field Type	Constraint
subtypeof_fid	serial8	PRIMARY KEY
subtypeof_value	int8[]	UNIQUE

gbmetatypes_subtypes
Field name	Field Type	Constraint
subtypes_fid	serial8	PRIMARY KEY
subtypes_value	int8[]	UNIQUE

gbmetatypes_instances
Field name	Field Type	Constraint
instances_fid	serial8	PRIMARY KEY
instances_value	int8[]	UNIQUE

gbmetatypes_content
Field name	Field Type	Constraint
content_fid	serial8	PRIMARY KEY
content_value	text	UNIQUE

gbmetatypes
Field name	Field Type	Constraint
ssid	int8	NOT NULL UNIQUE
inid	int8	REFERENCES gbnidinid ( inid )
uid	int8
status_fid	int8	REFERENCES gbmetatypes_status ( status_fid )
gbtimestamp	timestamptz	DEFAULT now()
uri_fid	int8	REFERENCES gbmetatypes_uri ( uri_fid )
noofmodifiedfields	int
fieldschanged	varchar[]
changetype	int[]
noofcommits	int
noofmodifications	int
history	int8[]
title_fid	int8	REFERENCES gbmetatypes_title ( title_fid )
description_fid	int8	REFERENCES gbmetatypes_description ( description_fid )
attributetypes_fid	int8	REFERENCES gbmetatypes_attributetypes ( attributetypes_fid )
attributes_fid	int8	REFERENCES gbmetatypes_attributes ( attributes_fid )
relationtypes_fid	int8	REFERENCES gbmetatypes_relationtypes ( relationtypes_fid )
relations_fid	int8	REFERENCES gbmetatypes_relations ( relations_fid )
subtypeof_fid	int8	REFERENCES gbmetatypes_subtypeof ( subtypeof_fid )
subtypes_fid	int8	REFERENCES gbmetatypes_subtypes ( subtypes_fid )
instances_fid	int8	REFERENCES gbmetatypes_instances ( instances_fid )
content_fid	int8	REFERENCES gbmetatypes_content ( content_fid )

gbobjecttypes_status
Field name	Field Type	Constraint
status_fid	serial8	PRIMARY KEY
status_value	varchar	UNIQUE

gbobjecttypes_uri
Field name	Field Type	Constraint
uri_fid	serial8	PRIMARY KEY
uri_value	varchar	UNIQUE

gbobjecttypes_title
Field name	Field Type	Constraint
title_fid	serial8	PRIMARY KEY
title_value	varchar[]	UNIQUE

gbobjecttypes_description
Field name	Field Type	Constraint
description_fid	serial8	PRIMARY KEY
description_value	text	UNIQUE

gbobjecttypes_attributetypes
Field name	Field Type	Constraint
attributetypes_fid	serial8	PRIMARY KEY
attributetypes_value	int8[]	UNIQUE

gbobjecttypes_attributes
Field name	Field Type	Constraint
attributes_fid	serial8	PRIMARY KEY
attributes_value	int8[]	UNIQUE

gbobjecttypes_relationtypes
Field name	Field Type	Constraint
relationtypes_fid	serial8	PRIMARY KEY
relationtypes_value	int8[]	UNIQUE

gbobjecttypes_relations
Field name	Field Type	Constraint
relations_fid	serial8	PRIMARY KEY
relations_value	int8[]	UNIQUE

gbobjecttypes_subtypeof
Field name	Field Type	Constraint
subtypeof_fid	serial8	PRIMARY KEY
subtypeof_value	int8[]	UNIQUE

gbobjecttypes_subtypes
Field name	Field Type	Constraint
subtypes_fid	serial8	PRIMARY KEY
subtypes_value	int8[]	UNIQUE

gbobjecttypes_instanceof
Field name	Field Type	Constraint
instanceof_fid	serial8	PRIMARY KEY
instanceof_value	int8[]	UNIQUE

gbobjecttypes_instances
Field name	Field Type	Constraint
instances_fid	serial8	PRIMARY KEY
instances_value	int8[]	UNIQUE

gbobjecttypes_structure
Field name	Field Type	Constraint
structure_fid	serial8	PRIMARY KEY
structure_value	int8[]	UNIQUE

gbobjecttypes_mandatoryprops
Field name	Field Type	Constraint
mandatoryprops_fid	serial8	PRIMARY KEY
mandatoryprops_value	int8[]	UNIQUE

gbobjecttypes_content
Field name	Field Type	Constraint
content_fid	serial8	PRIMARY KEY
content_value	text	UNIQUE

gbobjecttypes
Field name	Field Type	Constraint
ssid	int8	NOT NULL UNIQUE
inid	int8	REFERENCES gbnidinid ( inid )
uid	int8
status_fid	int8	REFERENCES gbobjecttypes_status ( status_fid )
gbtimestamp	timestamptz	DEFAULT now()
uri_fid	int8	REFERENCES gbobjecttypes_uri ( uri_fid )
noofmodifiedfields	int
fieldschanged	varchar[]
changetype	int[]
noofcommits	int
noofmodifications	int
history	int8[]
title_fid	int8	REFERENCES gbobjecttypes_title ( title_fid )
description_fid	int8	REFERENCES gbobjecttypes_description ( description_fid )
attributetypes_fid	int8	REFERENCES gbobjecttypes_attributetypes ( attributetypes_fid )
attributes_fid	int8	REFERENCES gbobjecttypes_attributes ( attributes_fid )
relationtypes_fid	int8	REFERENCES gbobjecttypes_relationtypes ( relationtypes_fid )
relations_fid	int8	REFERENCES gbobjecttypes_relations ( relations_fid )
subtypeof_fid	int8	REFERENCES gbobjecttypes_subtypeof ( subtypeof_fid )
subtypes_fid	int8	REFERENCES gbobjecttypes_subtypes ( subtypes_fid )
instanceof_fid	int8	REFERENCES gbobjecttypes_instanceof ( instanceof_fid )
instances_fid	int8	REFERENCES gbobjecttypes_instances ( instances_fid )
structure_fid	int8	REFERENCES gbobjecttypes_structure ( structure_fid )
mandatoryprops_fid	int8	REFERENCES gbobjecttypes_mandatoryprops ( mandatoryprops_fid )
content_fid	int8	REFERENCES gbobjecttypes_content ( content_fid )

gbobjects_status
Field name	Field Type	Constraint
status_fid	serial8	PRIMARY KEY
status_value	varchar	UNIQUE

gbobjects_uri
Field name	Field Type	Constraint
uri_fid	serial8	PRIMARY KEY
uri_value	varchar	UNIQUE

gbobjects_title
Field name	Field Type	Constraint
title_fid	serial8	PRIMARY KEY
title_value	varchar[]	UNIQUE

gbobjects_description
Field name	Field Type	Constraint
description_fid	serial8	PRIMARY KEY
description_value	text	UNIQUE

gbobjects_attributetypes
Field name	Field Type	Constraint
attributetypes_fid	serial8	PRIMARY KEY
attributetypes_value	int8[]	UNIQUE

gbobjects_attributes
Field name	Field Type	Constraint
attributes_fid	serial8	PRIMARY KEY
attributes_value	int8[]	UNIQUE

gbobjects_relationtypes
Field name	Field Type	Constraint
relationtypes_fid	serial8	PRIMARY KEY
relationtypes_value	int8[]	UNIQUE

gbobjects_relations
Field name	Field Type	Constraint
relations_fid	serial8	PRIMARY KEY
relations_value	int8[]	UNIQUE

gbobjects_instanceof
Field name	Field Type	Constraint
instanceof_fid	serial8	PRIMARY KEY
instanceof_value	int8[]	UNIQUE

gbobjects_content
Field name	Field Type	Constraint
content_fid	serial8	PRIMARY KEY
content_value	varchar	UNIQUE

gbobjects
Field name	Field Type	Constraint
ssid	int8	NOT NULL UNIQUE
inid	int8	REFERENCES gbnidinid ( inid )
uid	int8
status_fid	int8	REFERENCES gbobjects_status ( status_fid )
uri_fid	int8	REFERENCES gbobjects_uri ( uri_fid )
gbtimestamp	timestamptz	DEFAULT now()
noofmodifiedfields	int
fieldschanged	varchar[]
changetype	int[]
noofcommits	int
noofmodifications	int
history	int8[]
title_fid	int8	REFERENCES gbobjects_title ( title_fid )
description_fid	int8	REFERENCES gbobjects_description ( description_fid )
attributetypes_fid	int8	REFERENCES gbobjects_attributetypes ( attributetypes_fid )
attributes_fid	int8	REFERENCES gbobjects_attributes ( attributes_fid )
relationtypes_fid	int8	REFERENCES gbobjects_relationtypes ( relationtypes_fid )
relations_fid	int8	REFERENCES gbobjects_relations ( relations_fid )
instanceof_fid	int8	REFERENCES gbobjects_instanceof ( instanceof_fid )
content_fid	int8	REFERENCES gbobjects_content ( content_fid )

gbattributetypes_status
Field name	Field Type	Constraint
status_fid	serial8	PRIMARY KEY
status_value	varchar	UNIQUE

gbattributetypes_uri
Field name	Field Type	Constraint
uri_fid	serial8	PRIMARY KEY
uri_value	varchar	UNIQUE

gbattributetypes_title
Field name	Field Type	Constraint
title_fid	serial8	PRIMARY KEY
title_value	varchar[]	UNIQUE

gbattributetypes_description
Field name	Field Type	Constraint
description_fid	serial8	PRIMARY KEY
description_value	text	UNIQUE

gbattributetypes_attributetypes
Field name	Field Type	Constraint
attributetypes_fid	serial8	PRIMARY KEY
attributetypes_value	int8[]	UNIQUE

gbattributetypes_attributes
Field name	Field Type	Constraint
attributes_fid	serial8	PRIMARY KEY
attributes_value	int8[]	UNIQUE

gbattributetypes_relationtypes
Field name	Field Type	Constraint
relationtypes_fid	serial8	PRIMARY KEY
relationtypes_value	int8[]	UNIQUE

gbattributetypes_relations
Field name	Field Type	Constraint
relations_fid	serial8	PRIMARY KEY
relations_value	int8[]	UNIQUE

gbattributetypes_subtypeof
Field name	Field Type	Constraint
subtypeof_fid	serial8	PRIMARY KEY
subtypeof_value	int8[]	UNIQUE

gbattributetypes_subtypes
Field name	Field Type	Constraint
subtypes_fid	serial8	PRIMARY KEY
subtypes_value	int8[]	UNIQUE

gbattributetypes_instanceof
Field name	Field Type	Constraint
instanceof_fid	serial8	PRIMARY KEY
instanceof_value	int8[]	UNIQUE

gbattributetypes_instances
Field name	Field Type	Constraint
instances_fid	serial8	PRIMARY KEY
instances_value	int8[]	UNIQUE

gbattributetypes_restrictiontype
Field name	Field Type	Constraint
restrictiontype_fid	serial8	PRIMARY KEY
restrictiontype_value	int8	UNIQUE

gbattributetypes_restrictionref
Field name	Field Type	Constraint
restrictionref_fid	serial8	PRIMARY KEY
restrictionref_value	int8	UNIQUE

gbattributetypes_subjecttypes
Field name	Field Type	Constraint
subjecttypes_fid	serial8	PRIMARY KEY
subjecttypes_value	int8[]	UNIQUE

gbattributetypes
Field name	Field Type	Constraint
ssid	int8	NOT NULL UNIQUE
inid	int8	REFERENCES gbnidinid ( inid )
uid	int8
status_fid	int8	REFERENCES gbattributetypes_status ( status_fid )
gbtimestamp	timestamptz	DEFAULT now()
uri_fid	int8	REFERENCES gbattributetypes_uri ( uri_fid )
noofmodifiedfields	int
fieldschanged	varchar[]
changetype	int[]
noofcommits	int
noofmodifications	int
history	int8[]
title_fid	int8	REFERENCES gbattributetypes_title ( title_fid )
description_fid	int8	REFERENCES gbattributetypes_description ( description_fid )
attributetypes_fid	int8	REFERENCES gbattributetypes_attributetypes ( attributetypes_fid )
attributes_fid	int8	REFERENCES gbattributetypes_attributes ( attributes_fid )
relationtypes_fid	int8	REFERENCES gbattributetypes_relationtypes ( relationtypes_fid )
relations_fid	int8	REFERENCES gbattributetypes_relations ( relations_fid )
subtypeof_fid	int8	REFERENCES gbattributetypes_subtypeof ( subtypeof_fid )
subtypes_fid	int8	REFERENCES gbattributetypes_subtypes ( subtypes_fid )
instanceof_fid	int8	REFERENCES gbattributetypes_instanceof ( instanceof_fid )
instances_fid	int8	REFERENCES gbattributetypes_instances ( instances_fid )
restrictiontype_fid	int8	REFERENCES gbattributetypes_restrictiontype ( restrictiontype_fid )
restrictionref_fid	int8	REFERENCES gbattributetypes_restrictionref ( restrictionref_fid )
subjecttypes_fid	int8	REFERENCES gbattributetypes_subjecttypes ( subjecttypes_fid )

gbattributes_status
Field name	Field Type	Constraint
status_fid	serial8	PRIMARY KEY
status_value	varchar	UNIQUE

gbattributes_attributetypes
Field name	Field Type	Constraint
attributetypes_fid	serial8	PRIMARY KEY
attributetypes_value	int8[]	UNIQUE

gbattributes_attributes
Field name	Field Type	Constraint
attributes_fid	serial8	PRIMARY KEY
attributes_value	int8[]	UNIQUE

gbattributes_relationtypes
Field name	Field Type	Constraint
relationtypes_fid	serial8	PRIMARY KEY
relationtypes_value	int8[]	UNIQUE

gbattributes_relations
Field name	Field Type	Constraint
relations_fid	serial8	PRIMARY KEY
relations_value	int8[]	UNIQUE

gbattributes_instanceof
Field name	Field Type	Constraint
instanceof_fid	serial8	PRIMARY KEY
instanceof_value	int8[]	UNIQUE

gbattributes_uri
Field name	Field Type	Constraint
uri_fid	serial8	PRIMARY KEY
uri_value	varchar	UNIQUE

gbattributes_subject
Field name	Field Type	Constraint
subject_fid	serial8	PRIMARY KEY
subject_value	int8	UNIQUE

gbattributes_valueid
Field name	Field Type	Constraint
valueid_fid	serial8	PRIMARY KEY
valueid_value	int8	UNIQUE

gbattributes
Field name	Field Type	Constraint
ssid	int8	NOT NULL UNIQUE
inid	int8	REFERENCES gbnidinid ( inid )
uid	int8
gbtimestamp	timestamptz	DEFAULT now()
status_fid	int8	REFERENCES gbattributes_status ( status_fid )
sentence	varchar
attributetypes_fid	int8	REFERENCES gbattributes_attributetypes ( attributetypes_fid )
attributes_fid	int8	REFERENCES gbattributes_attributes ( attributes_fid )
relationtypes_fid	int8	REFERENCES gbattributes_relationtypes ( relationtypes_fid )
relations_fid	int8	REFERENCES gbattributes_relations ( relations_fid )
instanceof_fid	int8	REFERENCES gbattributes_instanceof ( instanceof_fid )
uri_fid	int8	REFERENCES gbattributes_uri ( uri_fid )
subject_fid	int8	REFERENCES gbattributes_subject ( subject_fid )
valueid_fid	int8	REFERENCES gbattributes_valueid ( valueid_fid )

gbrelationtypes_status
Field name	Field Type	Constraint
status_fid	serial8	PRIMARY KEY
status_value	varchar	UNIQUE

gbrelationtypes_uri
Field name	Field Type	Constraint
uri_fid	serial8	PRIMARY KEY
uri_value	varchar	UNIQUE

gbrelationtypes_title
Field name	Field Type	Constraint
title_fid	serial8	PRIMARY KEY
title_value	varchar[]	UNIQUE

gbrelationtypes_description
Field name	Field Type	Constraint
description_fid	serial8	PRIMARY KEY
description_value	text	UNIQUE

gbrelationtypes_attributetypes
Field name	Field Type	Constraint
attributetypes_fid	serial8	PRIMARY KEY
attributetypes_value	int8[]	UNIQUE

gbrelationtypes_attributes
Field name	Field Type	Constraint
attributes_fid	serial8	PRIMARY KEY
attributes_value	int8[]	UNIQUE

gbrelationtypes_relationtypes
Field name	Field Type	Constraint
relationtypes_fid	serial8	PRIMARY KEY
relationtypes_value	int8[]	UNIQUE

gbrelationtypes_relations
Field name	Field Type	Constraint
relations_fid	serial8	PRIMARY KEY
relations_value	int8[]	UNIQUE

gbrelationtypes_subtypeof
Field name	Field Type	Constraint
subtypeof_fid	serial8	PRIMARY KEY
subtypeof_value	int8[]	UNIQUE

gbrelationtypes_subtypes
Field name	Field Type	Constraint
subtypes_fid	serial8	PRIMARY KEY
subtypes_value	int8[]	UNIQUE

gbrelationtypes_instanceof
Field name	Field Type	Constraint
instanceof_fid	serial8	PRIMARY KEY
instanceof_value	int8[]	UNIQUE

gbrelationtypes_instances
Field name	Field Type	Constraint
instances_fid	serial8	PRIMARY KEY
instances_value	int8[]	UNIQUE

gbrelationtypes_roletypes
Field name	Field Type	Constraint
roletypes_fid	serial8	PRIMARY KEY
roletypes_value	int8[]	UNIQUE

gbrelationtypes_mandatoryprops
Field name	Field Type	Constraint
mandatoryprops_fid	serial8	PRIMARY KEY
mandatoryprops_value	int8[]	UNIQUE

gbrelationtypes
Field name	Field Type	Constraint
ssid	int8	NOT NULL UNIQUE
inid	int8	REFERENCES gbnidinid ( inid )
uid	int8
status_fid	int8	REFERENCES gbrelationtypes_status ( status_fid )
uri_fid	int8	REFERENCES gbrelationtypes_uri ( uri_fid )
gbtimestamp	timestamptz	DEFAULT now()
noofmodifiedfields	int
fieldschanged	varchar[]
changetype	int[]
noofcommits	int
noofmodifications	int
title_fid	int8	REFERENCES gbrelationtypes_title ( title_fid )
description_fid	int8	REFERENCES gbrelationtypes_description ( description_fid )
attributetypes_fid	int8	REFERENCES gbrelationtypes_attributetypes ( attributetypes_fid )
attributes_fid	int8	REFERENCES gbrelationtypes_attributes ( attributes_fid )
relationtypes_fid	int8	REFERENCES gbrelationtypes_relationtypes ( relationtypes_fid )
relations_fid	int8	REFERENCES gbrelationtypes_relations ( relations_fid )
subtypeof_fid	int8	REFERENCES gbrelationtypes_subtypeof ( subtypeof_fid )
subtypes_fid	int8	REFERENCES gbrelationtypes_subtypes ( subtypes_fid )
instanceof_fid	int8	REFERENCES gbrelationtypes_instanceof ( instanceof_fid )
instances_fid	int8	REFERENCES gbrelationtypes_instances ( instances_fid )
roletypes_fid	int8	REFERENCES gbrelationtypes_roletypes ( roletypes_fid )
istransitive	boolean
isreflexive	boolean
issymmetrical	boolean
mandatoryprops_fid	int8	REFERENCES gbrelationtypes_mandatoryprops ( mandatoryprops_fid )

gbrelations_status
Field name	Field Type	Constraint
status_fid	serial8	PRIMARY KEY
status_value	varchar	UNIQUE

gbrelations_attributetypes
Field name	Field Type	Constraint
attributetypes_fid	serial8	PRIMARY KEY
attributetypes_value	int8[]	UNIQUE

gbrelations_attributes
Field name	Field Type	Constraint
attributes_fid	serial8	PRIMARY KEY
attributes_value	int8[]	UNIQUE

gbrelations_relationtypes
Field name	Field Type	Constraint
relationtypes_fid	serial8	PRIMARY KEY
relationtypes_value	int8[]	UNIQUE

gbrelations_relations
Field name	Field Type	Constraint
relations_fid	serial8	PRIMARY KEY
relations_value	int8[]	UNIQUE

gbrelations_subtypeof
Field name	Field Type	Constraint
subtypeof_fid	serial8	PRIMARY KEY
subtypeof_value	int8[]	UNIQUE

gbrelations_subtypes
Field name	Field Type	Constraint
subtypes_fid	serial8	PRIMARY KEY
subtypes_value	int8[]	UNIQUE

gbrelations_instanceof
Field name	Field Type	Constraint
instanceof_fid	serial8	PRIMARY KEY
instanceof_value	int8[]	UNIQUE

gbrelations_instances
Field name	Field Type	Constraint
instances_fid	serial8	PRIMARY KEY
instances_value	int8[]	UNIQUE

gbrelations
Field name	Field Type	Constraint
ssid	int8	NOT NULL UNIQUE
inid	int8	REFERENCES gbnidinid ( inid )
uid	int8
status_fid	int8	REFERENCES gbrelations_status ( status_fid )
sentence	varchar
gbtimestamp	timestamptz	DEFAULT now()
attributetypes_fid	int8	REFERENCES gbrelations_attributetypes ( attributetypes_fid )
attributes_fid	int8	REFERENCES gbrelations_attributes ( attributes_fid )
relationtypes_fid	int8	REFERENCES gbrelations_relationtypes ( relationtypes_fid )
relations_fid	int8	REFERENCES gbrelations_relations ( relations_fid )
subtypeof_fid	int8	REFERENCES gbrelations_subtypeof ( subtypeof_fid )
subtypes_fid	int8	REFERENCES gbrelations_subtypes ( subtypes_fid )
instanceof_fid	int8	REFERENCES gbrelations_instanceof ( instanceof_fid )
instances_fid	int8	REFERENCES gbrelations_instances ( instances_fid )
subject1	int8
subject2	int8

gbusertypes_status
Field name	Field Type	Constraint
status_fid	serial8	PRIMARY KEY
status_value	varchar	UNIQUE

gbusertypes_uri
Field name	Field Type	Constraint
uri_fid	serial8	PRIMARY KEY
uri_value	varchar	UNIQUE

gbusertypes_title
Field name	Field Type	Constraint
title_fid	serial8	PRIMARY KEY
title_value	varchar[]	UNIQUE

gbusertypes_description
Field name	Field Type	Constraint
description_fid	serial8	PRIMARY KEY
description_value	text	UNIQUE

gbusertypes_attributetypes
Field name	Field Type	Constraint
attributetypes_fid	serial8	PRIMARY KEY
attributetypes_value	int8[]	UNIQUE

gbusertypes_attributes
Field name	Field Type	Constraint
attributes_fid	serial8	PRIMARY KEY
attributes_value	int8[]	UNIQUE

gbusertypes_relationtypes
Field name	Field Type	Constraint
relationtypes_fid	serial8	PRIMARY KEY
relationtypes_value	int8[]	UNIQUE

gbusertypes_relations
Field name	Field Type	Constraint
relations_fid	serial8	PRIMARY KEY
relations_value	int8[]	UNIQUE

gbusertypes_subtypeof
Field name	Field Type	Constraint
subtypeof_fid	serial8	PRIMARY KEY
subtypeof_value	int8[]	UNIQUE

gbusertypes_subtypes
Field name	Field Type	Constraint
subtypes_fid	serial8	PRIMARY KEY
subtypes_value	int8[]	UNIQUE

gbusertypes_instanceof
Field name	Field Type	Constraint
instanceof_fid	serial8	PRIMARY KEY
instanceof_value	int8[]	UNIQUE

gbusertypes_instances
Field name	Field Type	Constraint
instances_fid	serial8	PRIMARY KEY
instances_value	int8[]	UNIQUE

gbusertypes
Field name	Field Type	Constraint
ssid	int8	NOT NULL UNIQUE
inid	int8	REFERENCES gbnidinid ( inid )
uid	int8
status_fid	int8	REFERENCES gbusertypes_status ( status_fid )
gbtimestamp	timestamptz	DEFAULT now()
uri_fid	int8	REFERENCES gbusertypes_uri ( uri_fid )
noofmodifiedfields	int
fieldschanged	varchar[]
changetype	int[]
noofcommits	int
noofmodifications	int
history	int8[]
title_fid	int8	REFERENCES gbusertypes_title ( title_fid )
description_fid	int8	REFERENCES gbusertypes_description ( description_fid )
attributetypes_fid	int8	REFERENCES gbusertypes_attributetypes ( attributetypes_fid )
attributes_fid	int8	REFERENCES gbusertypes_attributes ( attributes_fid )
relationtypes_fid	int8	REFERENCES gbusertypes_relationtypes ( relationtypes_fid )
relations_fid	int8	REFERENCES gbusertypes_relations ( relations_fid )
subtypeof_fid	int8	REFERENCES gbusertypes_subtypeof ( subtypeof_fid )
subtypes_fid	int8	REFERENCES gbusertypes_subtypes ( subtypes_fid )
instanceof_fid	int8	REFERENCES gbusertypes_instanceof ( instanceof_fid )
instances_fid	int8	REFERENCES gbusertypes_instances ( instances_fid )

gbusers_status
Field name	Field Type	Constraint
status_fid	serial8	PRIMARY KEY
status_value	varchar	UNIQUE

gbusers_uri
Field name	Field Type	Constraint
uri_fid	serial8	PRIMARY KEY
uri_value	varchar	UNIQUE

gbusers_title
Field name	Field Type	Constraint
title_fid	serial8	PRIMARY KEY
title_value	varchar[]	UNIQUE

gbusers_description
Field name	Field Type	Constraint
description_fid	serial8	PRIMARY KEY
description_value	text	UNIQUE

gbusers_attributetypes
Field name	Field Type	Constraint
attributetypes_fid	serial8	PRIMARY KEY
attributetypes_value	int8[]	UNIQUE

gbusers_attributes
Field name	Field Type	Constraint
attributes_fid	serial8	PRIMARY KEY
attributes_value	int8[]	UNIQUE

gbusers_relationtypes
Field name	Field Type	Constraint
relationtypes_fid	serial8	PRIMARY KEY
relationtypes_value	int8[]	UNIQUE

gbusers_relations
Field name	Field Type	Constraint
relations_fid	serial8	PRIMARY KEY
relations_value	int8[]	UNIQUE

gbusers_instanceof
Field name	Field Type	Constraint
instanceof_fid	serial8	PRIMARY KEY
instanceof_value	int8[]	UNIQUE

gbusers_firstname
Field name	Field Type	Constraint
firstname_fid	serial8	PRIMARY KEY
firstname_value	varchar	UNIQUE

gbusers_lastname
Field name	Field Type	Constraint
lastname_fid	serial8	PRIMARY KEY
lastname_value	varchar	UNIQUE

gbusers_middlename
Field name	Field Type	Constraint
middlename_fid	serial8	PRIMARY KEY
middlename_value	varchar	UNIQUE

gbusers_email
Field name	Field Type	Constraint
email_fid	serial8	PRIMARY KEY
email_value	varchar	UNIQUE

gbusers_domain
Field name	Field Type	Constraint
domain_fid	serial8	PRIMARY KEY
domain_value	varchar	UNIQUE

gbusers_password
Field name	Field Type	Constraint
password_fid	serial8	PRIMARY KEY
password_value	varchar	UNIQUE

gbusers_content
Field name	Field Type	Constraint
content_fid	serial8	PRIMARY KEY
content_value	varchar	UNIQUE

gbusers
Field name	Field Type	Constraint
ssid	int8	NOT NULL UNIQUE
inid	int8	REFERENCES gbnidinid ( inid )
uid	int8
status_fid	int8	REFERENCES gbusers_status ( status_fid )
uri_fid	int8	REFERENCES gbusers_uri ( uri_fid )
gbtimestamp	timestamptz	DEFAULT now()
noofmodifiedfields	int
fieldschanged	varchar[]
changetype	int[]
noofcommits	int
noofmodifications	int
history	int8[]
loginstatus	boolean
title_fid	int8	REFERENCES gbusers_title ( title_fid )
description_fid	int8	REFERENCES gbusers_description ( description_fid )
attributetypes_fid	int8	REFERENCES gbusers_attributetypes ( attributetypes_fid )
attributes_fid	int8	REFERENCES gbusers_attributes ( attributes_fid )
relationtypes_fid	int8	REFERENCES gbusers_relationtypes ( relationtypes_fid )
relations_fid	int8	REFERENCES gbusers_relations ( relations_fid )
instanceof_fid	int8	REFERENCES gbusers_instanceof ( instanceof_fid )
firstname_fid	int8	REFERENCES gbusers_firstname ( firstname_fid )
lastname_fid	int8	REFERENCES gbusers_lastname ( lastname_fid )
middlename_fid	int8	REFERENCES gbusers_middlename ( middlename_fid )
email_fid	int8	REFERENCES gbusers_email ( email_fid )
domain_fid	int8	REFERENCES gbusers_domain ( domain_fid )
password_fid	int8	REFERENCES gbusers_password ( password_fid )
content_fid	int8	REFERENCES gbusers_content ( content_fid )

gbvocabulary
Field name	Field Type	Constraint
vocabid	serial8	PRIMARY KEY
vocabname	varchar
vocabdescription	text

gbselectionlist
Field name	Field Type	Constraint
selid	serial8	PRIMARY KEY
sellist	int8[]

gbroletypes
Field name	Field Type	Constraint
rtid	serial8	PRIMARY KEY
role1	int8[]
role2	int8[]
card1	int
card2	int

gbdatatypes
Field name	Field Type	Constraint
datatypeid	serial8	PRIMARY KEY
datatypename	varchar
description	varchar

gbregularexpressions
Field name	Field Type	Constraint
regexid	serial8	PRIMARY KEY
expression	varchar
description	text

gbvaluerestrictions
Field name	Field Type	Constraint
restrictionid	serial8	PRIMARY KEY
datatypeid	int8	REFERENCES gbdatatypes ( datatypeid )
description	text
regexid	int8	REFERENCES gbregularexpressions ( regexid )
length	int8
range	varchar
precision	int

datatypes_bigint
Field name	Field Type	Constraint
bigint_vid	serial8	PRIMARY KEY
value	bigint

datatypes_bigint_array
Field name	Field Type	Constraint
bigint_array_vid	serial8	PRIMARY KEY
value	bigint[]

datatypes_bit
Field name	Field Type	Constraint
bit_vid	serial8	PRIMARY KEY
value	bit

datatypes_bit_array
Field name	Field Type	Constraint
bit_array_vid	serial8	PRIMARY KEY
value	bit[]

datatypes_varbit
Field name	Field Type	Constraint
varbit_vid	serial8	PRIMARY KEY
value	varbit

datatypes_varbit_array
Field name	Field Type	Constraint
varbit_array_vid	serial8	PRIMARY KEY
value	varbit[]

datatypes_boolean
Field name	Field Type	Constraint
boolean_vid	serial8	PRIMARY KEY
value	boolean

datatypes_boolean_array
Field name	Field Type	Constraint
boolean_array_vid	serial8	PRIMARY KEY
value	boolean[]

datatypes_box
Field name	Field Type	Constraint
box_vid	serial8	PRIMARY KEY
value	box

datatypes_box_array
Field name	Field Type	Constraint
box_array_vid	serial8	PRIMARY KEY
value	box[]

datatypes_bytea
Field name	Field Type	Constraint
bytea_vid	serial8	PRIMARY KEY
value	bytea

datatypes_bytea_array
Field name	Field Type	Constraint
bytea_array_vid	serial8	PRIMARY KEY
value	bytea[]

datatypes_varchar
Field name	Field Type	Constraint
varchar_vid	serial8	PRIMARY KEY
value	varchar

datatypes_varchar_array
Field name	Field Type	Constraint
varchar_array_vid	serial8	PRIMARY KEY
value	varchar[]

datatypes_char
Field name	Field Type	Constraint
char_vid	serial8	PRIMARY KEY
value	char

datatypes_char_array
Field name	Field Type	Constraint
char_array_vid	serial8	PRIMARY KEY
value	char[]

datatypes_cidr
Field name	Field Type	Constraint
cidr_vid	serial8	PRIMARY KEY
value	cidr

datatypes_cidr_array
Field name	Field Type	Constraint
cidr_array_vid	serial8	PRIMARY KEY
value	cidr[]

datatypes_circle
Field name	Field Type	Constraint
circle_vid	serial8	PRIMARY KEY
value	circle

datatypes_circle_array
Field name	Field Type	Constraint
circle_array_vid	serial8	PRIMARY KEY
value	circle[]

datatypes_date
Field name	Field Type	Constraint
date_vid	serial8	PRIMARY KEY
value	date

datatypes_date_array
Field name	Field Type	Constraint
date_array_vid	serial8	PRIMARY KEY
value	date[]

datatypes_float8
Field name	Field Type	Constraint
float8_vid	serial8	PRIMARY KEY
value	float8

datatypes_float8_array
Field name	Field Type	Constraint
float8_array_vid	serial8	PRIMARY KEY
value	float8[]

datatypes_inet
Field name	Field Type	Constraint
inet_vid	serial8	PRIMARY KEY
value	inet

datatypes_inet_array
Field name	Field Type	Constraint
inet_array_vid	serial8	PRIMARY KEY
value	inet[]

datatypes_int4
Field name	Field Type	Constraint
int4_vid	serial8	PRIMARY KEY
value	int4

datatypes_int4_array
Field name	Field Type	Constraint
int4_array_vid	serial8	PRIMARY KEY
value	int4[]

datatypes_interval
Field name	Field Type	Constraint
interval_vid	serial8	PRIMARY KEY
value	interval

datatypes_interval_array
Field name	Field Type	Constraint
interval_array_vid	serial8	PRIMARY KEY
value	interval[]

datatypes_line
Field name	Field Type	Constraint
line_vid	serial8	PRIMARY KEY
value	line

datatypes_line_array
Field name	Field Type	Constraint
line_array_vid	serial8	PRIMARY KEY
value	line[]

datatypes_lseg
Field name	Field Type	Constraint
lseg_vid	serial8	PRIMARY KEY
value	lseg

datatypes_lseg_array
Field name	Field Type	Constraint
lseg_array_vid	serial8	PRIMARY KEY
value	lseg[]

datatypes_macaddr
Field name	Field Type	Constraint
macaddr_vid	serial8	PRIMARY KEY
value	macaddr

datatypes_macaddr_array
Field name	Field Type	Constraint
macaddr_array_vid	serial8	PRIMARY KEY
value	macaddr[]

datatypes_money
Field name	Field Type	Constraint
money_vid	serial8	PRIMARY KEY
value	money

datatypes_money_array
Field name	Field Type	Constraint
money_array_vid	serial8	PRIMARY KEY
value	money[]

datatypes_numeric
Field name	Field Type	Constraint
numeric_vid	serial8	PRIMARY KEY
value	numeric

datatypes_numeric_array
Field name	Field Type	Constraint
numeric_array_vid	serial8	PRIMARY KEY
value	numeric[]

datatypes_path
Field name	Field Type	Constraint
path_vid	serial8	PRIMARY KEY
value	path

datatypes_path_array
Field name	Field Type	Constraint
path_array_vid	serial8	PRIMARY KEY
value	path[]

datatypes_point
Field name	Field Type	Constraint
point_vid	serial8	PRIMARY KEY
value	point

datatypes_point_array
Field name	Field Type	Constraint
point_array_vid	serial8	PRIMARY KEY
value	point[]

datatypes_polygon
Field name	Field Type	Constraint
polygon_vid	serial8	PRIMARY KEY
value	polygon

datatypes_polygon_array
Field name	Field Type	Constraint
polygon_array_vid	serial8	PRIMARY KEY
value	polygon[]

datatypes_float4
Field name	Field Type	Constraint
float4_vid	serial8	PRIMARY KEY
value	float4

datatypes_float4_array
Field name	Field Type	Constraint
float4_array_vid	serial8	PRIMARY KEY
value	float4[]

datatypes_int2
Field name	Field Type	Constraint
int2_vid	serial8	PRIMARY KEY
value	int2

datatypes_int2_array
Field name	Field Type	Constraint
int2_array_vid	serial8	PRIMARY KEY
value	int2[]

datatypes_text
Field name	Field Type	Constraint
text_vid	serial8	PRIMARY KEY
value	text

datatypes_text_array
Field name	Field Type	Constraint
text_array_vid	serial8	PRIMARY KEY
value	text[]

datatypes_time
Field name	Field Type	Constraint
time_vid	serial8	PRIMARY KEY
value	time

datatypes_time_array
Field name	Field Type	Constraint
time_array_vid	serial8	PRIMARY KEY
value	time[]

datatypes_timestamptz
Field name	Field Type	Constraint
timestamptz_vid	serial8	PRIMARY KEY
value	timestamptz

datatypes_timestamptz_array
Field name	Field Type	Constraint
timestamptz_array_vid	serial8	PRIMARY KEY
value	timestamptz[]

datatypes_abstime
Field name	Field Type	Constraint
abstime_vid	serial8	PRIMARY KEY
value	abstime

datatypes_abstime_array
Field name	Field Type	Constraint
abstime_array_vid	serial8	PRIMARY KEY
value	abstime[]

datatypes_aclitem
Field name	Field Type	Constraint
aclitem_vid	serial8	PRIMARY KEY
value	aclitem

datatypes_aclitem_array
Field name	Field Type	Constraint
aclitem_array_vid	serial8	PRIMARY KEY
value	aclitem[]

datatypes_bpchar
Field name	Field Type	Constraint
bpchar_vid	serial8	PRIMARY KEY
value	bpchar

datatypes_bpchar_array
Field name	Field Type	Constraint
bpchar_array_vid	serial8	PRIMARY KEY
value	bpchar[]

datatypes_cid
Field name	Field Type	Constraint
cid_vid	serial8	PRIMARY KEY
value	cid

datatypes_cid_array
Field name	Field Type	Constraint
cid_array_vid	serial8	PRIMARY KEY
value	cid[]

datatypes_oid
Field name	Field Type	Constraint
oid_vid	serial8	PRIMARY KEY
value	oid

datatypes_oid_array
Field name	Field Type	Constraint
oid_array_vid	serial8	PRIMARY KEY
value	oid[]

datatypes_refcursor
Field name	Field Type	Constraint
refcursor_vid	serial8	PRIMARY KEY
value	refcursor

datatypes_refcursor_array
Field name	Field Type	Constraint
refcursor_array_vid	serial8	PRIMARY KEY
value	refcursor[]

datatypes_regclass
Field name	Field Type	Constraint
regclass_vid	serial8	PRIMARY KEY
value	regclass

datatypes_regclass_array
Field name	Field Type	Constraint
regclass_array_vid	serial8	PRIMARY KEY
value	regclass[]

datatypes_regoper
Field name	Field Type	Constraint
regoper_vid	serial8	PRIMARY KEY
value	regoper

datatypes_regoper_array
Field name	Field Type	Constraint
regoper_array_vid	serial8	PRIMARY KEY
value	regoper[]

datatypes_regoperator
Field name	Field Type	Constraint
regoperator_vid	serial8	PRIMARY KEY
value	regoperator

datatypes_regoperator_array
Field name	Field Type	Constraint
regoperator_array_vid	serial8	PRIMARY KEY
value	regoperator[]

datatypes_regproc
Field name	Field Type	Constraint
regproc_vid	serial8	PRIMARY KEY
value	regproc

datatypes_regproc_array
Field name	Field Type	Constraint
regproc_array_vid	serial8	PRIMARY KEY
value	regproc[]

datatypes_regprocedure
Field name	Field Type	Constraint
regprocedure_vid	serial8	PRIMARY KEY
value	regprocedure

datatypes_regprocedure_array
Field name	Field Type	Constraint
regprocedure_array_vid	serial8	PRIMARY KEY
value	regprocedure[]

datatypes_regtype
Field name	Field Type	Constraint
regtype_vid	serial8	PRIMARY KEY
value	regtype

datatypes_regtype_array
Field name	Field Type	Constraint
regtype_array_vid	serial8	PRIMARY KEY
value	regtype[]

datatypes_reltime
Field name	Field Type	Constraint
reltime_vid	serial8	PRIMARY KEY
value	reltime

datatypes_reltime_array
Field name	Field Type	Constraint
reltime_array_vid	serial8	PRIMARY KEY
value	reltime[]

datatypes_smgr
Field name	Field Type	Constraint
smgr_vid	serial8	PRIMARY KEY
value	smgr

datatypes_tid
Field name	Field Type	Constraint
tid_vid	serial8	PRIMARY KEY
value	tid

datatypes_tid_array
Field name	Field Type	Constraint
tid_array_vid	serial8	PRIMARY KEY
value	tid[]

datatypes_timetz
Field name	Field Type	Constraint
timetz_vid	serial8	PRIMARY KEY
value	timetz

datatypes_timetz_array
Field name	Field Type	Constraint
timetz_array_vid	serial8	PRIMARY KEY
value	timetz[]

datatypes_tinterval
Field name	Field Type	Constraint
tinterval_vid	serial8	PRIMARY KEY
value	tinterval

datatypes_tinterval_array
Field name	Field Type	Constraint
tinterval_array_vid	serial8	PRIMARY KEY
value	tinterval[]

datatypes_unknown
Field name	Field Type	Constraint
unknown_vid	serial8	PRIMARY KEY
value	unknown

datatypes_xid
Field name	Field Type	Constraint
xid_vid	serial8	PRIMARY KEY
value	xid

datatypes_xid_array
Field name	Field Type	Constraint
xid_array_vid	serial8	PRIMARY KEY
value	xid[]

datatypes_int2vector
Field name	Field Type	Constraint
int2vector_vid	serial8	PRIMARY KEY
value	int2vector

datatypes_int2vector_array
Field name	Field Type	Constraint
int2vector_array_vid	serial8	PRIMARY KEY
value	int2vector[]

datatypes_name
Field name	Field Type	Constraint
name_vid	serial8	PRIMARY KEY
value	name

datatypes_name_array
Field name	Field Type	Constraint
name_array_vid	serial8	PRIMARY KEY
value	name[]

datatypes_oidvector
Field name	Field Type	Constraint
oidvector_vid	serial8	PRIMARY KEY
value	oidvector

datatypes_oidvector_array
Field name	Field Type	Constraint
oidvector_array_vid	serial8	PRIMARY KEY
value	oidvector[]

datatypes_serial
Field name	Field Type	Constraint
serial_vid	serial8	PRIMARY KEY
value	serial

datatypes_serial_array
Field name	Field Type	Constraint
serial_array_vid	serial8	PRIMARY KEY
value	serial[]

datatypes_bigserial
Field name	Field Type	Constraint
bigserial_vid	serial8	PRIMARY KEY
value	bigserial

datatypes_bigserial_array
Field name	Field Type	Constraint
bigserial_array_vid	serial8	PRIMARY KEY
value	bigserial[]