ExPASy Home page

Site Map

Search ExPASy

Contact us

The ExPASy Server requires Javascript to be fully functional. You may not see all the information available for this page (More information).

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: log

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
xrefdb
xrefdbdynamic
xrefdbparent

Table: analyte

analyte Structure
Name	Type	Description
analyteid	integer
sampleid	integer
analytepreparationid	integer
description	text
analyteparentid	integer
fromanalyzablesource	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

analyte Constraints
Name	Constraint
analyte_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
analyte_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: analytepreparation

analytepreparation Structure
Name	Type	Description
analytepreparationid	integer
preparationprotocol	text
uri	character varying(4096)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

analytepreparation Constraints
Name	Constraint
analytepreparation_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
analytepreparation_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: analyzable

analyzable Structure
Name	Type	Description
analyzableid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

analyzable Constraints
Name	Constraint
analyzable_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
analyzable_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: author

author Structure
Name	Type	Description
author	character varying(1024)
article	integer
authorpriority	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

author Constraints
Name	Constraint
author_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
author_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: authorgroup

authorgroup Structure
Name	Type	Description
author	character varying(1024)
article	integer
authorpriority	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

authorgroup Constraints
Name	Constraint
authorgroup_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
authorgroup_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: authorparent

authorparent Structure
Name	Type	Description
author	character varying(1024)
article	integer
authorpriority	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

authorparent Constraints
Name	Constraint
authorparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
authorparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: biologicalprocess

biologicalprocess Structure
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)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

biologicalprocess Constraints
Name	Constraint
biologicalprocess_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
biologicalprocess_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: biosource

biosource Structure
Name	Type	Description
biosourceid	integer
studygroupid	integer
biosourceinformationid	integer
biosourcepreparationid	integer
description	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

biosource Constraints
Name	Constraint
biosource_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
biosource_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: biosourceinformation

biosourceinformation Structure
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)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

biosourceinformation Constraints
Name	Constraint
biosourceinformation_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
biosourceinformation_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: biosourcepreparation

biosourcepreparation Structure
Name	Type	Description
biosourcepreparationid	integer
preparationprotocol	text
uri	character varying(4096)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

biosourcepreparation Constraints
Name	Constraint
biosourcepreparation_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
biosourcepreparation_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: book

book Structure
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)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

book Constraints
Name	Constraint
book_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
book_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: cellularcomponent

cellularcomponent Structure
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)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

cellularcomponent Constraints
Name	Constraint
cellularcomponent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
cellularcomponent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: citer

citer Structure
Name	Type	Description
author	character varying(1024)
article	integer
authorpriority	smallint
unpublished	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

citer Constraints
Name	Constraint
citer_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
citer_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commententry2d

commententry2d Structure
Name	Type	Description
ac	character varying(32)
commenttopicid	integer
commentfreetext	text
geldimension	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

commententry2d Constraints
Name	Constraint
commententry2d_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
commententry2d_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commententryfreetext

commententryfreetext Structure
Name	Type	Description
ac	character varying(32)
commenttopicid	integer
commentfreetext	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

commententryfreetext Constraints
Name	Constraint
commententryfreetext_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
commententryfreetext_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commententryparent

commententryparent Structure
Name	Type	Description
ac	character varying(32)
commenttopicid	integer
commentfreetext	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

commententryparent Constraints
Name	Constraint
commententryparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
commententryparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commenttopic

commenttopic Structure
Name	Type	Description
commenttopicid	integer
commenttopicname	character varying(64)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

commenttopic Constraints
Name	Constraint
commenttopic_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
commenttopic_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: contact

contact Structure
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)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

contact Constraints
Name	Constraint
contact_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
contact_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: dynamicremotemake2ddbinterface

dynamicremotemake2ddbinterface Structure
Name	Type	Description
interfaceid	integer
interfaceuri	text
dbnumber	integer
dbname	character varying(128)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

dynamicremotemake2ddbinterface Constraints
Name	Constraint
dynamicremotemake2ddbinterface_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
dynamicremotemake2ddbinterface_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entry

entry Structure
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)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entry Constraints
Name	Constraint
entry_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entry_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrygelimage

entrygelimage Structure
Name	Type	Description
ac	character varying(32)
gelid	integer
showflag	boolean
showflagswitch	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entrygelimage Constraints
Name	Constraint
entrygelimage_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entrygelimage_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrygelmaster

entrygelmaster Structure
Name	Type	Description
ac	character varying(32)
gelid	integer
showflag	boolean
showflagswitch	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entrygelmaster Constraints
Name	Constraint
entrygelmaster_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entrygelmaster_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrygene

entrygene Structure
Name	Type	Description
ac	character varying(32)
geneid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entrygene Constraints
Name	Constraint
entrygene_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entrygene_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrytheoreticalpimw

entrytheoreticalpimw Structure
Name	Type	Description
ac	character varying(32)
modifiedproteindescription	text
theoreticalpi	numeric(4,2)
theoreticalmw	integer
algorithmoriginandversion	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entrytheoreticalpimw Constraints
Name	Constraint
entrytheoreticalpimw_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entrytheoreticalpimw_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryversion2d

entryversion2d Structure
Name	Type	Description
ac	character varying(32)
version	integer
versiondate	date
annotationchanged	boolean
annotationchecksum	character(16)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryversion2d Constraints
Name	Constraint
entryversion2d_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryversion2d_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryversiongeneral

entryversiongeneral Structure
Name	Type	Description
ac	character varying(32)
version	integer
versiondate	date
annotationchanged	boolean
annotationchecksum	character(16)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryversiongeneral Constraints
Name	Constraint
entryversiongeneral_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryversiongeneral_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryversionparent

entryversionparent Structure
Name	Type	Description
ac	character varying(32)
version	integer
versiondate	date
annotationchanged	boolean
annotationchecksum	character(16)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryversionparent Constraints
Name	Constraint
entryversionparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryversionparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryxrefdb

entryxrefdb Structure
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)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryxrefdb Constraints
Name	Constraint
entryxrefdb_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryxrefdb_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryxrefdbdynamic

entryxrefdbdynamic Structure
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)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryxrefdbdynamic Constraints
Name	Constraint
entryxrefdbdynamic_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryxrefdbdynamic_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryxrefdbparent

entryxrefdbparent Structure
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)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryxrefdbparent Constraints
Name	Constraint
entryxrefdbparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryxrefdbparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: enzymenomenclature

enzymenomenclature Structure
Name	Type	Description
enzymecode	character varying(16)
ac	character varying(32)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

enzymenomenclature Constraints
Name	Constraint
enzymenomenclature_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
enzymenomenclature_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: externalmainxrefdata

externalmainxrefdata Structure
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)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

externalmainxrefdata Constraints
Name	Constraint
externalmainxrefdata_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
externalmainxrefdata_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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<