Schema Version: 1.3 Module: chado

feature_contact


Description

Links contact(s) with a feature. Used to indicate a particular person or organization responsible for discovery or that can provide more information on a particular feature.

Columns

Column Type Size Foreign Key Nullable Default Comments
feature_contact_id bigserial 19
nextval('sequence.feature_contact_feature_contact_id_seq'::regclass)
feature_id int8 19
feature.feature_id feature_contact_feature_id_fkey C
null
contact_id int8 19
contact.contact_id feature_contact_contact_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
feature_contact_pkey Primary key Asc feature_contact_id
feature_contact_c1 Must be unique Asc/Asc feature_id + contact_id
feature_contact_idx1 Performance Asc feature_id
feature_contact_idx2 Performance Asc contact_id

Relationships

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