stock_pub

0 rows

Description

Provenance. Linking table between stocks and, for example, a stocklist computer file.

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

stock_pub_id

serial

10

√

nextval('stock_pub_stock_pub_id_seq'::regclass)

stock_id

int4

10

null

stock.stock_id

stock_pub_stock_id_fkey

C

pub_id

int4

10

null

pub.pub_id

stock_pub_pub_id_fkey

C

Indexes

Constraint Name	Type	Sort	Column(s)
stock_pub_pkey	Primary key	Asc	stock_pub_id
stock_pub_c1	Must be unique	Asc/Asc	stock_id + pub_id
stock_pub_idx1	Performance	Asc	stock_id
stock_pub_idx2	Performance	Asc	pub_id

Relationships

Close relationships within degrees of separation