stock_cvterm

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

stock_cvterm_id

serial

10

√

nextval('stock_cvterm_stock_cvterm_id_seq'::regclass)

stock_cvtermprop.stock_cvterm_id

stock_cvtermprop_stock_cvterm_id_fkey

C

stock_id

int4

10

null

stock.stock_id

stock_cvterm_stock_id_fkey

C

cvterm_id

int4

10

null

cvterm.cvterm_id

stock_cvterm_cvterm_id_fkey

C

pub_id

int4

10

null

pub.pub_id

stock_cvterm_pub_id_fkey

C

rank

int4

10

0

is_not

bool

1

false

Showing 1 to 6 of 6 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
stock_cvterm_pkey	Primary key	Asc	stock_cvterm_id
stock_cvterm_c1	Must be unique	Asc/Asc/Asc/Asc	stock_id + cvterm_id + pub_id + rank
stock_cvterm_idx1	Performance	Asc	stock_id
stock_cvterm_idx2	Performance	Asc	cvterm_id
stock_cvterm_idx3	Performance	Asc	pub_id

Showing 1 to 5 of 5 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation