Table cxgn.public.db

A database authority. Typical dbs in
bioinformatics are FlyBase, GO, UniProt, NCBI, MGI, etc. The authority
is generally known by this sortened form, which is unique within the
bioinformatics and biomedical realm. **TODO** - add support for URIs,
URNs (eg LSIDs). We can do this by treating the url as a uri -
however, some applications may expect this to be resolvable - to be
decided

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

db_id

serial

√

nextval('db_db_id_seq'::regclass)

dbxref.db_id

dbxref_db_id_fkey

name

varchar

255

description

varchar

255

√

null

urlprefix

varchar

255

√

null

url

varchar

255

√

null

Table contained 190 rows at Wed May 20 01:40 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
db_id	Primary key	Asc	db_pkey
name	Must be unique	Asc	db_c1