A Make2D-DB II DATABASE: version 2.50, built 18-Jul-2006

Dumped on 2006-07-18

The Make2D-DB II Tool

Index of database structure for schema: public

public

analyte
analytepreparation
analyzable
author
authorgroup
authorparent
biologicalprocess
biosource
biosourceinformation
biosourcepreparation
book
cellularcomponent
citer
commententry2d
commententryfreetext
commententryparent
commenttopic
contact
dynamicremotemake2ddbinterface
entry
entrygelimage
entrygelmaster
entrygene
entrytheoreticalpimw
entryversion2d
entryversiongeneral
entryversionparent
entryxrefdb
entryxrefdbdynamic
entryxrefdbparent
enzymenomenclature
externalmainxrefdata
gel
gelcomputabledynamic
geldynamic
gelimage
gelinformatics
gelpreparation
geltissuesp
genename
geneontologyparent
geneorderedlocus
geneorf
generaltopicdefinition
generaltopicentrydata
genesynonym
journal
make2ddbtool
mappingtopicdefinition
molecularfunction
organism
project
reference
referencedentry
referencedgel
referencedobjectparent
referencedproject
referencedsample
referencelocationbook
referencelocationjournal
referencelocationother
referencelocationparent
referencelocationpatent
referencelocationsubmission
referencelocationthesis
referencelocationunpubobservations
referencetype
referencework
release
sample
samplepreparation
secondaryac
spot
spotdataaacid
spotdataother
spotdataparent
spotdatapeptmassf
spotdatatandemms
spotentry
spotentrygeneraltopic
spotentrymappingtopic
spotentrytopicparent
spotidentificationaacid
spotidentificationother
spotidentificationparent
spotidentificationpeptmassf
spotidentificationtandemms
spotidentificationtandemmssubset
study
studygroup
tissue
tissuesp
tissuespaliase
tissuesptissuemapping
tmp_last_entry
viewentry
viewmapentrylist
viewref
viewspotentry
viewspotentrylast
xrefdb
xrefdbdynamic
xrefdbparent

Table: analyte

analyte Structure
F-Key	Name	Type	Description
	analyteid	integer
	sampleid	integer
	analytepreparationid	integer
	description	text
	analyteparentid	integer
	fromanalyzablesource	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to analyte
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: analytepreparation

analytepreparation Structure
F-Key	Name	Type	Description
	analytepreparationid	integer
	preparationprotocol	text
	uri	character varying(4096)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to analytepreparation
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: analyzable

analyzable Structure
F-Key	Name	Type	Description
	analyzableid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to analyzable
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: author

author Structure
F-Key	Name	Type	Description
	author	character varying(1024)
	article	integer
	authorpriority	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to author
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: authorgroup

authorgroup Structure
F-Key	Name	Type	Description
	author	character varying(1024)
	article	integer
	authorpriority	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to authorgroup
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: authorparent

authorparent Structure
F-Key	Name	Type	Description
	author	character varying(1024)
	article	integer
	authorpriority	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to authorparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: biologicalprocess

biologicalprocess Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	goid	character varying(32)
	goname	character varying(256)
	gosynoymsnames	character varying(1024)
	godefinition	character varying(1024)
	lastupdate	timestamp without time zone
	mappedenzymeclassification	character varying(16)
	mappedtransportclassification	character varying(16)
	goparents	character varying(32)[]
	gochildren	character varying(32)[]
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to biologicalprocess
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: biosource

biosource Structure
F-Key	Name	Type	Description
	biosourceid	integer
	studygroupid	integer
	biosourceinformationid	integer
	biosourcepreparationid	integer
	description	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to biosource
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: biosourceinformation

biosourceinformation Structure
F-Key	Name	Type	Description
	biosourceinformationid	integer
	organismid	integer
	organismstrain	character varying(256)
	straindetailsdescription	text
	individualscount	character varying(256)
	genotype	character varying(16)
	developmentalstage	character varying(256)
	anatomy	character varying(256)
	tissueid	integer
	cell	character varying(256)
	cellline	character varying(256)
	measuredproperties	text
	environmet	character varying(256)
	treatment	text
	phenotype	text
	behaviour	text
	pathology	text
	provider	character varying(256)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to biosourceinformation
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: biosourcepreparation

biosourcepreparation Structure
F-Key	Name	Type	Description
	biosourcepreparationid	integer
	preparationprotocol	text
	uri	character varying(4096)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to biosourcepreparation
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: book

book Structure
F-Key	Name	Type	Description
	bookid	integer
	booktitle	character varying(256)
	editors	character varying(256)
	publisher	character varying(128)
	city	character varying(64)
	year	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to book
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: cellularcomponent

cellularcomponent Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	goid	character varying(32)
	goname	character varying(256)
	gosynoymsnames	character varying(1024)
	godefinition	character varying(1024)
	lastupdate	timestamp without time zone
	mappedenzymeclassification	character varying(16)
	mappedtransportclassification	character varying(16)
	goparents	character varying(32)[]
	gochildren	character varying(32)[]
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to cellularcomponent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: citer

citer Structure
F-Key	Name	Type	Description
	author	character varying(1024)
	article	integer
	authorpriority	smallint
	unpublished	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to citer
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: commententry2d

commententry2d Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	commenttopicid	integer
	commentfreetext	text
	geldimension	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to commententry2d
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: commententryfreetext

commententryfreetext Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	commenttopicid	integer
	commentfreetext	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to commententryfreetext
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: commententryparent

commententryparent Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	commenttopicid	integer
	commentfreetext	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to commententryparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: commenttopic

commenttopic Structure
F-Key	Name	Type	Description
	commenttopicid	integer
	commenttopicname	character varying(64)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to commenttopic
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: contact

contact Structure
F-Key	Name	Type	Description
	contactid	integer
	name	character varying(256)
	email	character varying(256)
	institution	character varying(256)
	address	text
	remark	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to contact
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: dynamicremotemake2ddbinterface

dynamicremotemake2ddbinterface Structure
F-Key	Name	Type	Description
	interfaceid	integer
	interfaceuri	text
	dbnumber	integer
	dbname	character varying(128)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to dynamicremotemake2ddbinterface
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entry

entry Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	id	character varying(32)
	entryclass	character varying(32)
	identmethod	character varying(16)
	description	text
	releasecreation	integer
	subreleasecreation	integer
	genenames	character varying(1024)
	keywords	character varying(1024)
	organismid	integer
	organismstrain	character varying(256)
	entrychecksum	character(16)
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entry
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entrygelimage

entrygelimage Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	gelid	integer
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entrygelimage
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entrygelmaster

entrygelmaster Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	gelid	integer
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entrygelmaster
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entrygene

entrygene Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	geneid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entrygene
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entrytheoreticalpimw

entrytheoreticalpimw Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	modifiedproteindescription	text
	theoreticalpi	numeric(4,2)
	theoreticalmw	integer
	algorithmoriginandversion	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entrytheoreticalpimw
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryversion2d

entryversion2d Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	version	integer
	versiondate	date
	annotationchanged	boolean
	annotationchecksum	character(16)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryversion2d
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryversiongeneral

entryversiongeneral Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	version	integer
	versiondate	date
	annotationchanged	boolean
	annotationchecksum	character(16)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryversiongeneral
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryversionparent

entryversionparent Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	version	integer
	versiondate	date
	annotationchanged	boolean
	annotationchecksum	character(16)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryversionparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryxrefdb

entryxrefdb Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	xrefdbcode	integer
	xrefprimaryidentifier	character varying(32)
	xrefsecondaryidentifier	character varying(1024)
	xreftertiaryidentifier	character varying(1024)
	xrefotheridentifiers	character varying(1024)
	activated	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryxrefdb
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryxrefdbdynamic

entryxrefdbdynamic Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	xrefdbcode	integer
	xrefprimaryidentifier	character varying(32)
	xrefsecondaryidentifier	character varying(1024)
	xreftertiaryidentifier	character varying(1024)
	xrefotheridentifiers	character varying(1024)
	activated	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryxrefdbdynamic
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryxrefdbparent

entryxrefdbparent Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	xrefdbcode	integer
	xrefprimaryidentifier	character varying(32)
	xrefsecondaryidentifier	character varying(1024)
	xreftertiaryidentifier	character varying(1024)
	xrefotheridentifiers	character varying(1024)
	activated	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryxrefdbparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: enzymenomenclature

enzymenomenclature Structure
F-Key	Name	Type	Description
	enzymecode	character varying(16)
	ac	character varying(32)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to enzymenomenclature
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: externalmainxrefdata

externalmainxrefdata Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	uniprotextractiondate	date
	uniprotac	character varying(32)
	uniprotsecondaryac	character varying(32)[]
	uniprotid	character varying(32)
	uniprotversion	numeric(5,2)
	uniprotentryincorporateddate	date
	uniprotsequpdate	date
	uniprotsequpversion	smallint
	uniprotentryupdate	date
	uniprotentryupversion	smallint
	uniprotdescription	text
	uniprotenzymecode	character varying(16)
	uniprotgenenames	character varying(1024)
	uniprotorganelleplasmid	character varying(256)
	uniprotcategorykeywords	character varying(1024)
	uniprotxrefs	character varying(1024)[]
	sportrembl	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to externalmainxrefdata
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: gel

gel Structure
F-Key	Name	Type	Description
	gelid	integer
	melaniegeneratedid	character varying(64)
	shortname	character varying(32)
	fullname	character varying(256)
	dimension	smallint
	startmw	bigint
	endmw	bigint
	startpi	numeric(4,2)
	endpi	numeric(4,2)
	organismid	integer
	organismstrain	character varying(256)
	gelparentid	integer
	gelpreparationid	integer
	gelinformaticsid	integer
	biosourceinformationid	integer
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone