cvprop

6 rows


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 Nulls Auto Default Children Parents Comments
cvprop_id serial 10 nextval('cvprop_cvprop_id_seq'::regclass)
cv_id int4 10 null
cv.cv_id cvprop_cv_id_fkey R
type_id int4 10 null
cvterm.cvterm_id cvprop_type_id_fkey R

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.

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