Schema Version: 1.3 Module: chado

project_analysis


Description

Links an analysis to a project that may contain multiple analyses. The rank column can be used to specify a simple ordering in which analyses were executed.

Columns

Column Type Size Foreign Key Nullable Default Comments
project_analysis_id bigserial 19
nextval('project.project_analysis_project_analysis_id_seq'::regclass)
project_id int8 19
project.project_id project_analysis_project_id_fkey C
null
analysis_id int8 19
analysis.analysis_id project_analysis_analysis_id_fkey C
null
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
project_analysis_pkey Primary key Asc project_analysis_id
project_analysis_c1 Must be unique Asc/Asc project_id + analysis_id
project_analysis_idx1 Performance Asc project_id
project_analysis_idx2 Performance Asc analysis_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the project_analysis 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