Schema Version: 1.3 Module: chado

stock_library


Description

Links a stock with a library.

Columns

Column Type Size Foreign Key Nullable Default Comments
stock_library_id bigserial 19
nextval('stock.stock_library_stock_library_id_seq'::regclass)
library_id int8 19
library.library_id stock_library_library_id_fkey C
null
stock_id int8 19
stock.stock_id stock_library_stock_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
stock_library_pkey Primary key Asc stock_library_id
stock_library_c1 Must be unique Asc/Asc library_id + stock_id
stock_library_idx1 Performance Asc library_id
stock_library_idx2 Performance Asc stock_id

Relationships

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