population

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
population_id serial 10 √ nextval('phenome.population_population_id_seq'::regclass)
individual.population_id individual_population_id_fkey C
individual_history.population_id Implied Constraint R
is_public.population_id is_public_population_id_fkey C
population_dbxref.population_id population_dbxref_population_id_fkey C
user_trait_unit.population_id user_trait_unit_population_id_fkey C
map.population_id map_population_id_fkey C
name varchar 100 √ null
description text 2147483647 √ null
person_id int4 10 √ null
sp_person.sp_person_id population_person_id_fkey R
sp_person_id int8 19 √ null
sp_person.sp_person_id population_sp_person_id_fkey R
create_date timestamptz 35,6 √ now()
modified_date timestamptz 35,6 √ null
background_accession_id int8 19 √ null
accession.accession_id population_background_accession_id_fkey R
obsolete bool 1 √ false
cross_type_id int4 10 √ null
cross_type.cross_type_id population_cross_type_id_fkey R
female_parent_id int4 10 √ null
accession.accession_id population_female_parent_id_fkey R
male_parent_id int4 10 √ null
accession.accession_id population_male_parent_id_fkey R
recurrent_parent_id int4 10 √ null
accession.accession_id population_recurrent_parent_id_fkey R
donor_parent_id int4 10 √ null
accession.accession_id population_donor_parent_id_fkey R
comment text 2147483647 √ null
web_uploaded bool 1 √ null
common_name_id int4 10 √ null
common_name.common_name_id population_common_name_id_fkey R
stock_id int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
population_pkey Primary key Asc population_id
population_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation