Schema Version: 1.3

assay_biomaterial


Description

A biomaterial can be hybridized many times (technical replicates), or combined with other biomaterials in a single hybridization (for two-channel arrays).

Columns

Column Type Size Foreign Key Nullable Default Comments
assay_biomaterial_id bigserial 19
nextval('chado.assay_biomaterial_assay_biomaterial_id_seq'::regclass)
assay_id int8 19
assay.assay_id assay_biomaterial_assay_id_fkey C
null
biomaterial_id int8 19
biomaterial.biomaterial_id assay_biomaterial_biomaterial_id_fkey C
null
channel_id int8 19
channel.channel_id assay_biomaterial_channel_id_fkey N
√ null
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
assay_biomaterial_pkey Primary key Asc assay_biomaterial_id
assay_biomaterial_c1 Must be unique Asc/Asc/Asc/Asc assay_id + biomaterial_id + channel_id + rank
assay_biomaterial_idx1 Performance Asc assay_id
assay_biomaterial_idx2 Performance Asc biomaterial_id
assay_biomaterial_idx3 Performance Asc channel_id

Relationships

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

Show relationships within degrees of separation