phendesc

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

phendesc_id

serial

10

√

nextval('phendesc_phendesc_id_seq'::regclass)

genotype_id

int4

10

null

genotype.genotype_id

phendesc_genotype_id_fkey

C

environment_id

int4

10

null

environment.environment_id

phendesc_environment_id_fkey

C

description

text

2147483647

null

type_id

int4

10

null

cvterm.cvterm_id

phendesc_type_id_fkey

C

pub_id

int4

10

null

pub.pub_id

phendesc_pub_id_fkey

C

Showing 1 to 6 of 6 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
phendesc_pkey	Primary key	Asc	phendesc_id
phendesc_c1	Must be unique	Asc/Asc/Asc/Asc	genotype_id + environment_id + type_id + pub_id
phendesc_idx1	Performance	Asc	genotype_id
phendesc_idx2	Performance	Asc	environment_id
phendesc_idx3	Performance	Asc	pub_id

Showing 1 to 5 of 5 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation