pubprop

0 rows


Description

Property-value pairs for a pub. Follows standard chado pattern - see sequence module for details

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pubprop_id serial 10 nextval('pubprop_pubprop_id_seq'::regclass)
pub_id int4 10 null
pub.pub_id pubprop_pub_id_fkey C
type_id int4 10 null
cvterm.cvterm_id pubprop_type_id_fkey C
value text 2147483647 null
rank int4 10 null

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