Schema Version: 1.3 Module: chado

project_feature


Description

This table is intended associate records in the feature table with a project.

Columns

Column Type Size Foreign Key Nullable Default Comments
project_feature_id bigserial 19
nextval('project.project_feature_project_feature_id_seq'::regclass)
feature_id int8 19
feature.feature_id project_feature_feature_id_fkey C
null
project_id int8 19
project.project_id project_feature_project_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
project_feature_pkey Primary key Asc project_feature_id
project_feature_c1 Must be unique Asc/Asc feature_id + project_id
project_feature_idx1 Performance Asc feature_id
project_feature_idx2 Performance Asc project_id

Relationships

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