resource logo

SWISS-2DPAGE

Attention: World-2DPAGE is no longer maintained.

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 


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

 

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

Index - Schema public


Table: gelcomputabledynamic

gelcomputabledynamic Structure
F-Key Name Type Description
databasename character varying(64)
gelshortname character varying(32)
gelfullname character varying(256)
organismspecies text
taxonomycode integer
gelcomputableurl text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: geldynamic

geldynamic Structure
F-Key Name Type Description
databasename character varying(64)
gelshortname character varying(32)
gelfullname character varying(256)
organismspecies text
taxonomycode integer
tissuename character varying(256)
tissuespname character varying(256)
gelurl text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: gelimage

gelimage Structure
F-Key Name Type Description
gelid integer
masterimage oid
imageurl text
imagepath text
imagetype character varying(3)
smallimageurl text
smallimagepath text
smallimagetype character varying(3)
xpixelsize smallint
ypixelsize smallint
xratio numeric(6,4)
yratio numeric(6,4)
xpixelshift smallint
ypixelshift smallint
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: gelinformatics

gelinformatics Structure
F-Key Name Type Description
gelinformaticsid integer
uri character varying(4096)
informaticsdocument text
informaticsdescription text
soft text
contactid integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: gelpreparation

gelpreparation Structure
F-Key Name Type Description
gelpreparationid integer
analyteid integer
uri character varying(4096)
preparationdocument text
preparationdescription text
contactid integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: geltissuesp

geltissuesp Structure
F-Key Name Type Description
gelid integer
tissuespname character varying(256)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: genename

genename Structure
F-Key Name Type Description
geneid integer
genename character varying(16)
organismid integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: geneontologyparent

geneontologyparent 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 geneontologyparent
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
mostaguir
select2d

Index - Schema public


Table: geneorderedlocus

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

 

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

Index - Schema public


Table: geneorf

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

 

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

Index - Schema public


Table: generaltopicdefinition

generaltopicdefinition Structure
F-Key Name Type Description
generaltopicid integer
topicname character varying(64)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: generaltopicentrydata

generaltopicentrydata Structure
F-Key Name Type Description
topicdataid integer
generaltopicid integer
topicdatatext text
allreferences integer[]
ambiguousreference boolean
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: genesynonym

genesynonym Structure
F-Key Name Type Description
geneid integer
synonym character varying(16)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: journal

journal Structure
F-Key Name Type Description
journalid integer
journalname character varying(256)
url text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: make2ddbtool

make2ddbtool Structure
F-Key Name Type Description
version numeric(4,2)
subversion character varying(64)
versiondate date
postgresqlversion text
action text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: mappingtopicdefinition

mappingtopicdefinition Structure
F-Key Name Type Description
mappingtechnique character varying(8)
techniquedescription character varying(256)
containingregexp text
excludingregexp text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: molecularfunction

molecularfunction 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 molecularfunction
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
mostaguir
select2d

Index - Schema public


Table: organism

organism Structure
F-Key Name Type Description
organismid integer
organismspecies text
organismclassification text
taxonomyxrefdbcode integer
taxonomycode integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: project

project Structure
F-Key Name Type Description
projectid integer
description text
uri character varying(4096)
contactid integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: reference

reference Structure
F-Key Name Type Description
referenceid integer
referenceworkid integer
referencetitle text
referencetypeid integer
referencechecksum character(16)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencedentry

referencedentry Structure
F-Key Name Type Description
referenceid integer
ac character varying(32)
rndisplayedvalue smallint
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencedgel

referencedgel Structure
F-Key Name Type Description
referenceid integer
gelid integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencedobjectparent

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

 

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

Index - Schema public


Table: referencedproject

referencedproject Structure
F-Key Name Type Description
referenceid integer
projectid integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencedsample

referencedsample Structure
F-Key Name Type Description
referenceid integer
sampleid integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencelocationbook

referencelocationbook Structure
F-Key Name Type Description
referenceid integer
bookid integer
volume smallint
pagefirst integer
pagelast integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencelocationjournal

referencelocationjournal Structure
F-Key Name Type Description
referenceid integer
journalid integer
volume smallint
subvolume smallint
pagefirst integer
pagelast integer
year smallint
crossreferences character varying(128)[]
unpublished boolean
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencelocationother

referencelocationother Structure
F-Key Name Type Description
referenceid integer
text text
personalcomment character varying(256)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencelocationparent

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

 

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

Index - Schema public


Table: referencelocationpatent

referencelocationpatent Structure
F-Key Name Type Description
referenceid integer
patent_publication_number character varying(16)
date date
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencelocationsubmission

referencelocationsubmission Structure
F-Key Name Type Description
referenceid integer
month smallint
year smallint
xrefdbcode integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencelocationthesis

referencelocationthesis Structure
F-Key Name Type Description
referenceid integer
year smallint
institution character varying(128)
country character varying(64)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencelocationunpubobservations

referencelocationunpubobservations Structure
F-Key Name Type Description
referenceid integer
month smallint
year smallint
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: referencetype

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

 

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

Index - Schema public


Table: referencework

referencework Structure
F-Key Name Type Description
referenceworkid integer
referenceworkdescription character varying(64)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: release

release Structure
F-Key Name Type Description
releasenum integer
subrelease smallint
releasedate date
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: sample

sample Structure
F-Key Name Type Description
sampleid integer
biosourceid integer
uri character varying(4096)
samplepreparationid integer
description text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: samplepreparation

samplepreparation Structure
F-Key Name Type Description
samplepreparationid integer
uri character varying(4096)
samplepreparationdocument text
samplepreparationprotocol text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: secondaryac

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

 

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

Index - Schema public


Table: spot

spot Structure
F-Key Name Type Description
spotid character varying(16)
gelid integer
mw integer
pi numeric(4,2)
xcoordinate integer
ycoordinate integer
odrelative real
volumerelative real
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotdataaacid

spotdataaacid Structure
F-Key Name Type Description
dataexpid integer
humanidentifier character varying(256)
spotid character varying(16)
gelid integer
referenceid integer
contactid integer
uri character varying(4096)
datadocument text
experimentdescription text
experimentdate date
appreciation smallint
datadisplayer text
showflag boolean
showflagswitch boolean
aminoacidlist text
relateddata text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotdataother

spotdataother Structure
F-Key Name Type Description
dataexpid integer
humanidentifier character varying(256)
spotid character varying(16)
gelid integer
referenceid integer
contactid integer
uri character varying(4096)
datadocument text
experimentdescription text
experimentdate date
appreciation smallint
datadisplayer text
showflag boolean
showflagswitch boolean
results text
relateddata text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotdataparent

spotdataparent Structure
F-Key Name Type Description
dataexpid integer
humanidentifier character varying(256)
spotid character varying(16)
gelid integer
referenceid integer
contactid integer
uri character varying(4096)
datadocument text
experimentdescription text
experimentdate date
appreciation smallint
datadisplayer text
showflag boolean
showflagswitch boolean
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotdatapeptmassf

spotdatapeptmassf Structure
F-Key Name Type Description
dataexpid integer
humanidentifier character varying(256)
spotid character varying(16)
gelid integer
referenceid integer
contactid integer
uri character varying(4096)
datadocument text
experimentdescription text
experimentdate date
appreciation smallint
datadisplayer text
showflag boolean
showflagswitch boolean
peptidemasses double precision[]
enzyme character varying(32)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotdatatandemms

spotdatatandemms Structure
F-Key Name Type Description
dataexpid integer
humanidentifier character varying(256)
spotid character varying(16)
gelid integer
referenceid integer
contactid integer
uri character varying(4096)
datadocument text
experimentdescription text
experimentdate date
appreciation smallint
datadisplayer text
showflag boolean
showflagswitch boolean
parentmass double precision
parentcharge smallint
ionmasses double precision[]
relateddata text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotentry

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

 

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

Index - Schema public


Table: spotentrygeneraltopic

spotentrygeneraltopic Structure
F-Key Name Type Description
topicdataid integer
spotid character varying(16)
gelid integer
ac character varying(32)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotentrymappingtopic

spotentrymappingtopic Structure
F-Key Name Type Description
topicdataid integer
spotid character varying(16)
gelid integer
ac character varying(32)
mappingtechnique character varying(8)[]
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotentrytopicparent

spotentrytopicparent Structure
F-Key Name Type Description
topicdataid integer
spotid character varying(16)
gelid integer
ac character varying(32)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotidentificationaacid

spotidentificationaacid Structure
F-Key Name Type Description
identificationid integer
humanidentifier character varying(256)
hassubset boolean
dataexpid integer
spotid character varying(16)
gelid integer
ac character varying(32)
isoform text
version integer
contactid integer
uri character varying(4096)
identificationdocument text
identificationdescription text
allexperimentdata boolean
appreciation numeric(2,1)
datadisplayer text
showflag boolean
showflagswitch boolean
aminoacidlist text
relateddata text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotidentificationother

spotidentificationother Structure
F-Key Name Type Description
identificationid integer
humanidentifier character varying(256)
hassubset boolean
dataexpid integer
spotid character varying(16)
gelid integer
ac character varying(32)
isoform text
version integer
contactid integer
uri character varying(4096)
identificationdocument text
identificationdescription text
allexperimentdata boolean
appreciation numeric(2,1)
datadisplayer text
showflag boolean
showflagswitch boolean
results text
relateddata text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotidentificationparent

spotidentificationparent Structure
F-Key Name Type Description
identificationid integer
humanidentifier character varying(256)
hassubset boolean
dataexpid integer
spotid character varying(16)
gelid integer
ac character varying(32)
isoform text
version integer
contactid integer
uri character varying(4096)
identificationdocument text
identificationdescription text
allexperimentdata boolean
appreciation numeric(2,1)
datadisplayer text
showflag boolean
showflagswitch boolean
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotidentificationpeptmassf

spotidentificationpeptmassf Structure
F-Key Name Type Description
identificationid integer
humanidentifier character varying(256)
hassubset boolean
dataexpid integer
spotid character varying(16)
gelid integer
ac character varying(32)
isoform text
version integer
contactid integer
uri character varying(4096)
identificationdocument text
identificationdescription text
allexperimentdata boolean
appreciation numeric(2,1)
datadisplayer text
showflag boolean
showflagswitch boolean
peptidemasses double precision[]
relateddata text
xxac character varying(32)
xxdirectory character varying(256)
xxfile character varying(64)
xxprogversion character varying(64)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotidentificationtandemms

spotidentificationtandemms Structure
F-Key Name Type Description
identificationid integer
humanidentifier character varying(256)
hassubset boolean
dataexpid integer
spotid character varying(16)
gelid integer
ac character varying(32)
isoform text
version integer
contactid integer
uri character varying(4096)
identificationdocument text
identificationdescription text
allexperimentdata boolean
appreciation numeric(2,1)
datadisplayer text
showflag boolean
showflagswitch boolean
ionmasses double precision[]
relateddata text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: spotidentificationtandemmssubset

spotidentificationtandemmssubset Structure
F-Key Name Type Description
identificationid integer
ionmasses double precision[]
identifiedpeptidesequence text
sequencestartposition smallint
sequenceendposition smallint
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: study

study Structure
F-Key Name Type Description
studyid integer
projectid integer
description text
contactid integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: studygroup

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

 

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

Index - Schema public


Table: tissue

tissue Structure
F-Key Name Type Description
tissueid integer
tissuename character varying(256)
tissueparentid integer
tissuecomment character varying(1024)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: tissuesp

tissuesp Structure
F-Key Name Type Description
tissuespname character varying(256)
tissuespdisplayedname character varying(256)
tissueindate date
tissuecomment character varying(1024)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: tissuespaliase

tissuespaliase Structure
F-Key Name Type Description
tissuespname character varying(256)
alias character varying(256)
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: tissuesptissuemapping

tissuesptissuemapping Structure
F-Key Name Type Description
tissuespname character varying(256)
tissueid integer
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: tmp_last_entry

tmp_last_entry Structure
F-Key Name Type Description
identifier character varying(32)
id_method character varying(48)
accession_number character varying(32)
secondary_identifiers text
creation text
version_2d text
version_general text
description text
genes text
organism text
organism_classification text
taxonomy_cross_reference text
masters text
images text
free_comments text
reference_lines text
one_d_comments text
one_d_blocks text
two_d_comments text
two_d_blocks text
database_cross_reference text

 

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

Index - Schema public


Table: viewentry

viewentry Structure
F-Key Name Type Description
identifier character varying(32)
id_method character varying(48)
accession_number character varying(32)
secondary_identifiers text
creation text
version_2d text
version_general text
description text
genes text
organism text
organism_classification text
taxonomy_cross_reference text
masters text
images text
free_comments text
reference_lines text
one_d_comments text
one_d_blocks text
two_d_comments text
two_d_blocks text
database_cross_reference text

 

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

Index - Schema public


Table: viewmapentrylist

viewmapentrylist Structure
F-Key Name Type Description
gelid integer
genes character varying(1024)
description text
spotid character varying(16)
ac character varying(32)
id character varying(32)
pi numeric(4,2)
mw numeric(6,3)
volumerelative real
odrelative real
fragment boolean
topicdescription text
mappingtechniques text
availableresults text
rn_references text
referenceids text
showflag boolean
showflagswitch boolean

 

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

Index - Schema public


Table: viewref

viewref Structure
F-Key Name Type Description
referenceid integer
referenceworkdescription character varying(64)
crossreferences character varying(256)
authorsgroup character varying(2048)
authors character varying(8192)
referencetitle text
referencelocation text

 

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

Index - Schema public


Table: viewspotentry

viewspotentry Structure
F-Key Name Type Description
spotid character varying(16)
gelid integer
ac character varying(32)
fragment boolean
aminoacidlist text
aa_version integer
msms text
ms_version integer
peptidesequences text
peptseq_version integer
peptidemasses text
pmf_version integer
showflag boolean
showflagswitch boolean

 

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

Index - Schema public


Table: viewspotentrylast

viewspotentrylast Structure
F-Key Name Type Description
spotid character varying(16)
gelid integer
ac character varying(32)
fragment boolean
aminoacidlist text
aa_version integer
msms text
ms_version integer
peptidesequences text
peptseq_version integer
peptidemasses text
pmf_version integer
showflag boolean
showflagswitch boolean

 

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

Index - Schema public


Table: xrefdb

xrefdb Structure
F-Key Name Type Description
xrefdbcode integer
xrefdbname character varying(64)
description text
url text
displayerurl text
displayerparameters text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: xrefdbdynamic

xrefdbdynamic Structure
F-Key Name Type Description
xrefdbcode integer
xrefdbname character varying(64)
description text
url text
displayerurl text
displayerparameters text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public


Table: xrefdbparent

xrefdbparent Structure
F-Key Name Type Description
xrefdbcode integer
xrefdbname character varying(64)
description text
url text
displayerurl text
displayerparameters text
userstamp character varying(128)
update timestamp without time zone

 

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

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict