Schema Version: 1.3

library_cvterm


Description

The table library_cvterm links a library to controlled vocabularies which describe the library. For instance, there might be a link to the anatomy cv for "head" or "testes" for a head or testes library.

Columns

Column Type Size Foreign Key Nullable Default Comments
library_cvterm_id bigserial 19
nextval('chado.library_cvterm_library_cvterm_id_seq'::regclass)
library_id int8 19
library.library_id library_cvterm_library_id_fkey C
null
cvterm_id int8 19
cvterm.cvterm_id library_cvterm_cvterm_id_fkey R
null
pub_id int8 19
pub.pub_id library_cvterm_pub_id_fkey R
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
library_cvterm_pkey Primary key Asc library_cvterm_id
library_cvterm_c1 Must be unique Asc/Asc/Asc library_id + cvterm_id + pub_id
library_cvterm_idx1 Performance Asc library_id
library_cvterm_idx2 Performance Asc cvterm_id
library_cvterm_idx3 Performance Asc pub_id

Relationships

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

Show relationships within degrees of separation