Dumped on 2005-02-28

Index of database - biolocal

public

db_info
mynucs
mypatts
myprots

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
bioroot	♦	♦	♦	♦	♦	♦	♦
biouser	♦	♦		♦

Index - Schema public

Table: mynucs

Table for my nucleotides

mynucs Structure
F-Key	Name	Type	Description
	id	integer	PRIMARY KEY Nucleotide ID (PK)
	name	text	UNIQUE NOT NULL Name of the entry
	descr	text	NOT NULL Description
	seq	text	NOT NULL The sequence
	type	text	NOT NULL Type: cds\|vector\|primer...
	fid	integer	FID from myprots if applable
	map_file	character varying(128)	Map-file (dir: biolocal/mynucs)
	mcs_file	character varying(128)	MCS-file (dir: biolocal/mynucs)

Permissions which apply to mynucs
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
bioroot	♦	♦	♦	♦	♦	♦	♦
biouser	♦

Index - Schema public

Table: mypatts

Table for my patterns

mypatts Structure
F-Key	Name	Type	Description
	id	integer	PRIMARY KEY Mintazat/pattern ID (PK)
	name	text	UNIQUE NOT NULL Name of the entry
	descr	text	NOT NULL Description
	pattern	text	NOT NULL ProSite/RegExp pattern

Permissions which apply to mypatts
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
bioroot	♦	♦	♦	♦	♦	♦	♦
biouser	♦

Index - Schema public

Table: myprots

Table for my proteins

myprots Structure
F-Key	Name	Type	Description
	id	integer	PRIMARY KEY Feherje/protein ID
	name	text	UNIQUE NOT NULL Name of the entry
	descr	text	NOT NULL Description
	seq	text	NOT NULL The sequence
	nid	integer	NID from mynucs if applable

Permissions which apply to myprots
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
bioroot	♦	♦	♦	♦	♦	♦	♦
biouser	♦

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict