stock_genotype

0 rows

Description

Simple table linking a stock to a genotype. Features with genotypes can be linked to stocks thru feature_genotype -> genotype -> stock_genotype -> stock.

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

stock_genotype_id

serial

10

√

nextval('stock_genotype_stock_genotype_id_seq'::regclass)

stock_id

int4

10

null

stock.stock_id

stock_genotype_stock_id_fkey

C

genotype_id

int4

10

null

genotype.genotype_id

stock_genotype_genotype_id_fkey

C

Indexes

Constraint Name	Type	Sort	Column(s)
stock_genotype_pkey	Primary key	Asc	stock_genotype_id
stock_genotype_c1	Must be unique	Asc/Asc	stock_id + genotype_id
stock_genotype_idx1	Performance	Asc	stock_id
stock_genotype_idx2	Performance	Asc	genotype_id

Relationships

Close relationships within degrees of separation