Schema Version: 1.3

pubprop


Description

Property-value pairs for a pub. Follows standard chado pattern.

Columns

Column Type Size Foreign Key Nullable Default Comments
pubprop_id bigserial 19
nextval('chado.pubprop_pubprop_id_seq'::regclass)
pub_id int8 19
pub.pub_id pubprop_pub_id_fkey C
null
type_id int8 19
cvterm.cvterm_id pubprop_type_id_fkey C
null
value text 2147483647
null
rank int4 10
√ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
pubprop_pkey Primary key Asc pubprop_id
pubprop_c1 Must be unique Asc/Asc/Asc pub_id + type_id + rank
pubprop_idx1 Performance Asc pub_id
pubprop_idx2 Performance Asc type_id

Relationships

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

Show relationships within degrees of separation