Schema Version: 1.3 Module: chado

featureloc_pub


Description

Provenance of featureloc. Linking table between featurelocs and publications that mention them.

Columns

Column Type Size Foreign Key Nullable Default Comments
featureloc_pub_id bigserial 19
nextval('sequence.featureloc_pub_featureloc_pub_id_seq'::regclass)
featureloc_id int8 19
featureloc.featureloc_id featureloc_pub_featureloc_id_fkey C
null
pub_id int8 19
pub.pub_id featureloc_pub_pub_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
featureloc_pub_pkey Primary key Asc featureloc_pub_id
featureloc_pub_c1 Must be unique Asc/Asc featureloc_id + pub_id
featureloc_pub_idx1 Performance Asc featureloc_id
featureloc_pub_idx2 Performance Asc pub_id

Relationships

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