Schema Version: 1.3

cvprop


Description

Additional extensible properties can be attached to a cv using this table. A notable example would be the cv version

Columns

Column Type Size Foreign Key Nullable Default Comments
cvprop_id bigserial 19
nextval('chado.cvprop_cvprop_id_seq'::regclass)
cv_id int8 19
cv.cv_id cvprop_cv_id_fkey R
null
type_id int8 19
cvterm.cvterm_id cvprop_type_id_fkey R
null

The name of the property or slot is a cvterm. The meaning of the property is defined in that cvterm.
value text 2147483647
√ null

The value of the property, represented as text. Numeric values are converted to their text representation.
rank int4 10
0

Property-Value ordering. Any cv can have multiple values for any particular property type - these are ordered in a list using rank, counting from zero. For properties that are single-valued rather than multi-valued, the default 0 value should be used.

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
cvprop_pkey Primary key Asc cvprop_id
cvprop_c1 Must be unique Asc/Asc/Asc cv_id + type_id + rank

Relationships

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

Show relationships within degrees of separation