db

207 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
db_id serial 10 √ nextval('db_db_id_seq'::regclass)
dbxref.db_id dbxref_db_id_fkey C
name varchar 255 null
description varchar 255 √ null
urlprefix varchar 255 √ null
url varchar 255 √ null

Indexes

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

Relationships

Close relationships within degrees of separation