Schema Version: 1.3

assay_project


Description

Link assays to projects.

Columns

Column Type Size Foreign Key Nullable Default Comments
assay_project_id bigserial 19
nextval('chado.assay_project_assay_project_id_seq'::regclass)
assay_id int8 19
assay.assay_id assay_project_assay_id_fkey R
null
project_id int8 19
project.project_id assay_project_project_id_fkey R
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
assay_project_pkey Primary key Asc assay_project_id
assay_project_c1 Must be unique Asc/Asc assay_id + project_id
assay_project_idx1 Performance Asc assay_id
assay_project_idx2 Performance Asc project_id

Relationships