Schema Version: 1.3

study_assay


Columns

Column Type Size Foreign Key Nullable Default Comments
study_assay_id bigserial 19
nextval('chado.study_assay_study_assay_id_seq'::regclass)
study_id int8 19
study.study_id study_assay_study_id_fkey C
null
assay_id int8 19
assay.assay_id study_assay_assay_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
study_assay_pkey Primary key Asc study_assay_id
study_assay_c1 Must be unique Asc/Asc study_id + assay_id
study_assay_idx1 Performance Asc study_id
study_assay_idx2 Performance Asc assay_id

Relationships

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

Show relationships within degrees of separation