individual

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
individual_id serial 10 √ nextval('phenome.individual_individual_id_seq'::regclass)
germplasm.individual_id germplasm_individual_id_fkey R
individual_alias.individual_id individual_alias_individual_id_fkey R
individual_allele.individual_id individual_allele_individual_id_fkey R
individual_dbxref.individual_id individual_dbxref_individual_id_fkey R
individual_history.individual_id individual_history_individual_id_fkey C
individual_image.individual_id individual_image_individual_id_fkey R
individual_locus.individual_id individual_locus_individual_id_fkey R
phenome_genotype.individual_id genotype_individual_id_fkey C
phenotype.individual_id phenotype_individual_id_fkey C
sp_clone_il_mapping_segment_log.individual_id sp_clone_il_mapping_segment_log_individual_id_fkey R
name varchar 100 √ null
description text 2147483647 √ null
sp_person_id int8 19 √ null
sp_person.sp_person_id individual_sp_person_id_fkey R
create_date timestamptz 35,6 √ now()
modified_date timestamptz 35,6 √ null
obsolete bool 1 √ false
population_id int8 19 √ null
population.population_id individual_population_id_fkey C
updated_by int4 10 √ null
sp_person.sp_person_id individual_updated_by_fkey R
common_name_id int8 19 √ null
common_name.common_name_id individual_common_name_id_fkey R
accession_id int4 10 √ null
accession.accession_id individual_accession_id_fkey R
stock_id int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
individual_pkey Primary key Asc individual_id
phenome_individual_name_idx Performance Asc name
phenome_population_id_idx Performance Asc population_id

Relationships

Close relationships within degrees of separation