Schema Version: 1.3

stockcollection_db


Description

Stock collections may be respresented by an external online database. This table associates a stock collection with a database where its member stocks can be found. Individual stock that are part of this collction should have entries in the stock_dbxref table with the same db_id record

Columns

Column Type Size Foreign Key Nullable Default Comments
stockcollection_db_id bigserial 19
nextval('chado.stockcollection_db_stockcollection_db_id_seq'::regclass)
stockcollection_id int8 19
stockcollection.stockcollection_id stockcollection_db_stockcollection_id_fkey C
null
db_id int8 19
db.db_id stockcollection_db_db_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
stockcollection_db_pkey Primary key Asc stockcollection_db_id
stockcollection_db_c1 Must be unique Asc/Asc stockcollection_id + db_id
stockcollection_db_idx1 Performance Asc stockcollection_id
stockcollection_db_idx2 Performance Asc db_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the stockcollection_db table.

Show relationships within degrees of separation