nd_protocolprop

1 rows


Description

Property/value associations for protocol.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
nd_protocolprop_id serial 10 nextval('nd_protocolprop_nd_protocolprop_id_seq'::regclass)
nd_protocol_id int4 10 null
nd_protocol.nd_protocol_id nd_protocolprop_nd_protocol_id_fkey C

The protocol to which the property applies.

type_id int4 10 null
cvterm.cvterm_id nd_protocolprop_type_id_fkey C

The name of the property as a reference to a controlled vocabulary term.

value jsonb 2147483647 null

The value of the property.

rank int4 10 0

The rank of the property value, if the property has an array of values.

Indexes

Constraint Name Type Sort Column(s)
nd_protocolprop_pkey Primary key Asc nd_protocolprop_id
nd_protocolprop_c1 Must be unique Asc/Asc/Asc nd_protocol_id + type_id + rank

Relationships