ExPASy logo ExPASy Home page Site Map Search ExPASy Contact us
Search for

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