nd_experiment_stockprop

0 rows


Description

Property/value associations for experiment_stocks. This table can store the properties such as treatment

Columns

Column Type Size Nulls Auto Default Children Parents Comments
nd_experiment_stockprop_id serial 10 √ nextval('nd_experiment_stockprop_nd_experiment_stockprop_id_seq'::regclass)
nd_experiment_stock_id int4 10 null
nd_experiment_stock.nd_experiment_stock_id nd_experiment_stockprop_nd_experiment_stock_id_fkey C

The experiment_stock to which the property applies.
type_id int4 10 null
cvterm.cvterm_id nd_experiment_stockprop_type_id_fkey C

The name of the property as a reference to a controlled vocabulary term.
value text 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_experiment_stockprop_pkey Primary key Asc nd_experiment_stockprop_id
nd_experiment_stockprop_c1 Must be unique Asc/Asc/Asc nd_experiment_stock_id + type_id + rank

Relationships

Close relationships within degrees of separation