Schema Version: 1.3

biomaterial_treatment


Description

Link biomaterials to treatments. Treatments have an order of operations (rank), and associated measurements (unittype_id, value).

Columns

Column Type Size Foreign Key Nullable Default Comments
biomaterial_treatment_id bigserial 19
nextval('chado.biomaterial_treatment_biomaterial_treatment_id_seq'::regclass)
biomaterial_id int8 19
biomaterial.biomaterial_id biomaterial_treatment_biomaterial_id_fkey C
null
treatment_id int8 19
treatment.treatment_id biomaterial_treatment_treatment_id_fkey C
null
unittype_id int8 19
cvterm.cvterm_id biomaterial_treatment_unittype_id_fkey N
√ null
value float4 8,8
√ null
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
biomaterial_treatment_pkey Primary key Asc biomaterial_treatment_id
biomaterial_treatment_c1 Must be unique Asc/Asc biomaterial_id + treatment_id
biomaterial_treatment_idx1 Performance Asc biomaterial_id
biomaterial_treatment_idx2 Performance Asc treatment_id
biomaterial_treatment_idx3 Performance Asc unittype_id

Relationships

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

Show relationships within degrees of separation