Schema Version: 1.3

db


Description

A database authority. Typical databases in bioinformatics are FlyBase, GO, UniProt, NCBI, MGI, etc. The authority is generally known by this shortened form, which is unique within the bioinformatics and biomedical realm. To Do - add support for URIs, URNs (e.g. 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 Foreign Key Nullable Default Comments
db_id bigserial 19
nextval('chado.db_db_id_seq'::regclass)
name varchar 255
null
description varchar 255
√ null
urlprefix varchar 255
√ null
url varchar 255
√ null

Table contained -1 rows

Indexes

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

Relationships

The following entity relationship (ER) diagram shows the relationships involving the db table.

Show relationships within degrees of separation