Schema Version: 1.3 Module: chado

assay_project


Description

Link assays to projects.

Columns

Column Type Size Foreign Key Nullable Default Comments
assay_project_id bigserial 19
nextval('mage.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

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

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation