A Make2D-DB II DATABASE: version 2.00, built 9-Dec-2005

Dumped on 2005-12-09

The Make2D-DB II Tool

Index of database structure for schema: log 

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

 

analyte Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: analytepreparation

analytepreparation Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: analyzable

analyzable Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: author

author Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: authorgroup

authorgroup Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: authorparent

authorparent Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

biologicalprocess Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: biosource

biosource Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

biosourceinformation Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: biosourcepreparation

biosourcepreparation Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

book Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

cellularcomponent Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: citer

citer Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commententry2d

commententry2d Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commententryfreetext

commententryfreetext Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commententryparent

commententryparent Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commenttopic

commenttopic Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

contact Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: dynamicremotemake2ddbinterface

dynamicremotemake2ddbinterface Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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
releasemapupdate integer
releaseupdate integer
mapannotationchanged boolean
entryannotationchanged boolean
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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrygelimage

entrygelimage Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrygelmaster

entrygelmaster Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrygene

entrygene Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

entrytheoreticalpimw Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

entryxrefdb Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

entryxrefdbdynamic Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

entryxrefdbparent Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: enzymenomenclature

enzymenomenclature Structure
F-Key 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
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

externalmainxrefdata Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 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 integer
gelinformaticsid integer
biosourceinformationid integer
showflag boolean
showflagswitch boolean
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

gel Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

gelcomputabledynamic Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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 integer
tissuespname character varying(256)
gelurl text
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

geldynamic Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

gelimage Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

gelinformatics Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

gelpreparation Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: geltissuesp

geltissuesp Structure
F-Key Name Type Description
gelid integer
tissuespname character varying(256)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

geltissuesp Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: genename

genename Structure
F-Key Name Type Description
geneid integer
genename character varying(16)
organismid integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

genename Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

geneontologyparent Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: geneorderedlocus

geneorderedlocus Structure
F-Key Name Type Description
geneid integer
orderedlocusname character varying(32)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

geneorderedlocus Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: geneorf

geneorf Structure
F-Key Name Type Description
geneid integer
orfname character varying(32)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

geneorf Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: generaltopicdefinition

generaltopicdefinition Structure
F-Key Name Type Description
generaltopicid integer
topicname character varying(64)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

generaltopicdefinition Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: generaltopicentrydata

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

 

generaltopicentrydata Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: genesynonym

genesynonym Structure
F-Key Name Type Description
geneid integer
synonym character varying(16)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

genesynonym Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: journal

journal Structure
F-Key Name Type Description
journalid integer
journalname character varying(256)
url text
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

journal Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

make2ddbtool Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

mappingtopicdefinition Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

molecularfunction Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: organism

organism Structure
F-Key Name Type Description
organismid integer
organismspecies text
organismclassification text
taxonomyxrefdbcode integer
taxonomycode integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

organism Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: project

project Structure
F-Key Name Type Description
projectid integer
description text
uri character varying(4096)
contactid integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

project Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: reference

reference Structure
F-Key Name Type Description
referenceid integer
referenceworkid integer
referencetitle text
referencetypeid integer
referencechecksum character(16)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

reference Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencedentry

referencedentry Structure
F-Key Name Type Description
referenceid integer
ac character varying(32)
rndisplayedvalue smallint
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencedentry Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencedgel

referencedgel Structure
F-Key Name Type Description
referenceid integer
gelid integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencedgel Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencedobjectparent

referencedobjectparent Structure
F-Key Name Type Description
referenceid integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencedobjectparent Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencedproject

referencedproject Structure
F-Key Name Type Description
referenceid integer
projectid integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencedproject Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencedsample

referencedsample Structure
F-Key Name Type Description
referenceid integer
sampleid integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencedsample Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationbook

referencelocationbook Structure
F-Key Name Type Description
referenceid integer
bookid integer
volume smallint
pagefirst integer
pagelast integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencelocationbook Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

referencelocationjournal Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationother

referencelocationother Structure
F-Key Name Type Description
referenceid integer
text text
personalcomment character varying(256)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencelocationother Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationparent

referencelocationparent Structure
F-Key Name Type Description
referenceid integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencelocationparent Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationpatent

referencelocationpatent Structure
F-Key Name Type Description
referenceid integer
patent_publication_number character varying(16)
date date
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencelocationpatent Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationsubmission

referencelocationsubmission Structure
F-Key Name Type Description
referenceid integer
month smallint
year smallint
xrefdbcode integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencelocationsubmission Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

referencelocationthesis Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationunpubobservations

referencelocationunpubobservations Structure
F-Key Name Type Description
referenceid integer
month smallint
year smallint
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencelocationunpubobservations Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencetype

referencetype Structure
F-Key Name Type Description
referencetypeid integer
referencetype character varying(32)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencetype Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencework

referencework Structure
F-Key Name Type Description
referenceworkid integer
referenceworkdescription character varying(64)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

referencework Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: release

release Structure
F-Key Name Type Description
releasenum integer
subrelease smallint
releasedate date
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

release Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: sample

sample Structure
F-Key Name Type Description
sampleid integer
biosourceid integer
samplepreparationid integer
description text
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

sample Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: samplepreparation

samplepreparation Structure
F-Key Name Type Description
samplepreparationid 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)

 

samplepreparation Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: secondaryac

secondaryac Structure
F-Key Name Type Description
secondaryac character varying(32)
ac character varying(32)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

secondaryac Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

spot Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotdataaacid

spotdataaacid Structure
F-Key Name Type Description
dataexpid integer
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)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

spotdataaacid Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotdataother

spotdataother Structure
F-Key Name Type Description
dataexpid integer
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)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

spotdataother Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotdataparent

spotdataparent Structure
F-Key Name Type Description
dataexpid integer
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)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

spotdataparent Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotdatapeptmassf

spotdatapeptmassf Structure
F-Key Name Type Description
dataexpid integer
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)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

spotdatapeptmassf Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotdatatandemms

spotdatatandemms Structure
F-Key Name Type Description
dataexpid integer
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)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

spotdatatandemms Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

spotentry Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

spotentrygeneraltopic Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

spotentrymappingtopic Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

spotentrytopicparent Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationaacid

spotidentificationaacid Structure
F-Key Name Type Description
identificationid integer
hassubset boolean
dataexpid integer
spotid character varying(16)
gelid integer
ac character varying(32)
isoform text
release 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)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

spotidentificationaacid Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationother

spotidentificationother Structure
F-Key Name Type Description
identificationid integer
hassubset boolean
dataexpid integer
spotid character varying(16)
gelid integer
ac character varying(32)
isoform text
release 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)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

spotidentificationother Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationparent

spotidentificationparent Structure
F-Key Name Type Description
identificationid integer
hassubset boolean
dataexpid integer
spotid character varying(16)
gelid integer
ac character varying(32)
isoform text
release 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)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

spotidentificationparent Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationpeptmassf

spotidentificationpeptmassf Structure
F-Key Name Type Description
identificationid integer
hassubset boolean
dataexpid integer
spotid character varying(16)
gelid integer
ac character varying(32)
isoform text
release 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)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

spotidentificationpeptmassf Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationtandemms

spotidentificationtandemms Structure
F-Key Name Type Description
identificationid integer
hassubset boolean
dataexpid integer
spotid character varying(16)
gelid integer
ac character varying(32)
isoform text
release 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)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

spotidentificationtandemms Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationtandemmssubset

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

 

spotidentificationtandemmssubset Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: study

study Structure
F-Key Name Type Description
studyid integer
projectid integer
description text
contactid integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

study Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: studygroup

studygroup Structure
F-Key Name Type Description
studygroupid integer
studyid integer
description text
biosourceinformationid integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

studygroup Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: tissue

tissue Structure
F-Key Name Type Description
tissueid integer
tissuename character varying(256)
tissueparentname character varying(256)
tissuecomment character varying(1024)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

tissue Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: tissuesp

tissuesp Structure
F-Key Name Type Description
tissuespname character varying(256)
tissueindate date
tissuecomment character varying(1024)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

tissuesp Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: tissuespaliase

tissuespaliase Structure
F-Key Name Type Description
tissuespname character varying(256)
alias character varying(256)
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

tissuespaliase Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: tissuesptissuemapping

tissuesptissuemapping Structure
F-Key Name Type Description
tissuespname character varying(256)
tissueid integer
userstamp character varying(128)
modificationdate timestamp without time zone DEFAULT now()
updatedordeleted character(1)
usermodifiername character varying(128)

 

tissuesptissuemapping Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

xrefdb Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

xrefdbdynamic Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

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

 

xrefdbparent Constraints
Name Constraint
$1 CHECK ((modificationdate IS NOT NULL))
$2 CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict