genotype_experiment - cxgn_breedbase.phenome

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

genotype_experiment_id

serial

10

√

nextval('phenome.genotype_experiment_genotype_experiment_id_seq'::regclass)

phenome_genotype.genotype_experiment_id

genotype_genotype_experiment_id_fkey

R

experiment_name

varchar

100

√

null

reference_map_id

int8

19

√

null

map.map_id

genotype_experiment_reference_map_id_fkey

C

background_accession_id

int8

19

√

null

accession.accession_id

genotype_experiment_background_accession_id_fkey

R

preferred

bool

1

√

null

sp_person_id

int8

19

√

null

sp_person.sp_person_id

genotype_experiment_sp_person_id_fkey

R

modified_date

timestamptz

35,6

√

null

create_date

timestamptz

35,6

√

null

obsolete

bool

1

√

false

Showing 1 to 9 of 9 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
genotype_experiment_pkey	Primary key	Asc	genotype_experiment_id
background_accession_id_idx	Performance	Asc	background_accession_id
reference_map_id_idx	Performance	Asc	reference_map_id

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees