stock_dbxref

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

stock_dbxref_id

serial

10

√

nextval('stock_dbxref_stock_dbxref_id_seq'::regclass)

stock_dbxrefprop_stock_dbxref_id_fkey

C

stock_id

int4

10

null

stock.stock_id

stock_dbxref_stock_id_fkey

C

dbxref_id

int4

10

null

dbxref.dbxref_id

stock_dbxref_dbxref_id_fkey

C

is_current

bool

1

true

The is_current boolean indicates whether the linked dbxref is the current -official- dbxref for the linked stock.

Constraint Name	Type	Sort	Column(s)
stock_dbxref_pkey	Primary key	Asc	stock_dbxref_id
stock_dbxref_c1	Must be unique	Asc/Asc	stock_id + dbxref_id
stock_dbxref_idx1	Performance	Asc	stock_id
stock_dbxref_idx2	Performance	Asc	dbxref_id