Dumped on 2005-02-28

Index of database - mbs_up

Table: acc2

Old/secondary accession numbers

acc2 Structure
F-Key Name Type Description
prots.fid fid integer

Feherje/protein ID (FK)
acc2 character(6)

Old/secondary accession number

 

Permissions which apply to acc2
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: cc_ref

Fixed value array for cc

cc_ref Structure
F-Key Name Type Description
cc_acc integer PRIMARY KEY

Comment-topic accession number (PK)
cc_name text

Comment-topic
cc_desc text

Description of the comment-topic

Tables referencing this one via Foreign Key Constraints:

 

Permissions which apply to cc_ref
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: ccs

Comments (MM)

ccs Structure
F-Key Name Type Description
prots.fid fid integer

Feherje/protein ID (FK)
cc_ref.cc_acc cc_acc integer

Comment-topic accession number (FK)
comment text

Comment

 

Permissions which apply to ccs
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: db_info

General infos

db_info Structure
F-Key Name Type Description
itype text

Info type
rtype text

Result type
name text

Name
descr text

Description

 

Permissions which apply to db_info
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦
♦
♦

Index - Schema public

Table: db_ref

Databases from dbxref.txt

db_ref Structure
F-Key Name Type Description
db_acc integer PRIMARY KEY

DB accession number (PK)
abbr text

Abbreviation of db_name
name text

Full name
linktype text

LinkType
server text

Server
url text

URL

Tables referencing this one via Foreign Key Constraints:

 

Permissions which apply to db_ref
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: dbx

Database cross references (MM)

dbx Structure
F-Key Name Type Description
prots.fid fid integer

Feherje/protein ID (FK)
db_ref.db_acc db_acc integer

DB accession number (FK)
pri text

The primary identifier
sec text

The secondary identifier
ter text

The tertiary identifier

 

Permissions which apply to dbx
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: ft_ref

Feature-key references

ft_ref Structure
F-Key Name Type Description
ft_acc integer PRIMARY KEY

Feature-key accession number (PK)
ft_name text

Feature-key name
ft_desc text

Feature-key description

Tables referencing this one via Foreign Key Constraints:

 

Permissions which apply to ft_ref
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: fts

Future table (MM)

fts Structure
F-Key Name Type Description
prots.fid fid integer

Feherje/protein ID (FK)
ft_ref.ft_acc ft_acc integer

Feature-key accession number (FK)
tol text

FROM-endpoint
ig text

TO-endpoint
descr text

Description

 

Permissions which apply to fts
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: kw_ref

Keywords from keywlist.txt

kw_ref Structure
F-Key Name Type Description
kw_acc integer PRIMARY KEY

Keyword accession number (PK)
id text

Name/ID of kw
def text

Definition
syn text

Synonyms
go text

Gene ontology (GO) mapping
hi text

Hierarchy
annot text

Annotation note
rule text

Rules
www text

Interesting WWW site
categ text

Category

Tables referencing this one via Foreign Key Constraints:

 

Permissions which apply to kw_ref
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: kwx

Keywords (MM)

kwx Structure
F-Key Name Type Description
prots.fid fid integer

Feherje/protein ID (FK)
kw_ref.kw_acc kw_acc integer

KW accession number (FK)

 

Permissions which apply to kwx
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: prots

The Main PRT table

prots Structure
F-Key Name Type Description
fid integer PRIMARY KEY

Feherje/protein ID
name character varying(10) UNIQUE NOT NULL

Entry name
acc character(6) UNIQUE NOT NULL

Accession number
class integer

Data class
creat date

Created-date
creat_ver integer

Created-version
updat date

Updated-date
updat_ver integer

Updated-version
annot date

Annotation-date
annot_ver integer

Annotation-version
descr text

Description
gene_name text

Gene name
organism text

Organism
organelle text

Organelle
classif text

Organism classification
classid text

Organism taxonomy cross-reference
len integer

Length of the sequence
mw integer

Molecular weigth
crc text

CRC number
seq text

The Sequence

Tables referencing this one via Foreign Key Constraints:

 

Permissions which apply to prots
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦
quser
♦

Index - Schema public

Table: ref_ref

Details of References

ref_ref Structure
F-Key Name Type Description
ref_acc integer PRIMARY KEY

Reference accession number (PK)
num smallint

Reference Number
pos text

Reference Position
commnt text

Reference Comment
ml_id character(8)

Medline ID
pm_id character varying(12)

PubMed ID
doi text

Digital Object Identifier
refgroup text

Refrence Group
authors text

Reference Authors
title text

Reference Title
location text

Reference Location/Source

Tables referencing this one via Foreign Key Constraints:

 

Permissions which apply to ref_ref
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: refx

References (MM)

refx Structure
F-Key Name Type Description
prots.fid fid integer

Feherje/protein ID (FK)
ref_ref.ref_acc ref_acc integer

Reference accession number (FK)

 

Permissions which apply to refx
User
Select
Insert
Update
Delete
Reference
Rule
Trigger
proot
♦
♦
♦
♦
♦
♦
♦
puser
♦

Index - Schema public

Table: res_main (to store the result of the R domain pattern search)

res_main Structure
F-Key Name Type Description
fid integer
name character varying(10)
acc character(6)
class integer
descr text
seq text
strn integer
pstrn integer
propatt character varying(255)
starts text
ends text

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict