Schema Version: 1.3

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('chado.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.

Show relationships within degrees of separation