phenotype

3502 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
phenotype_id serial 10 √ nextval('phenotype_phenotype_id_seq'::regclass)
phenotype_user_trait.phenotype_id phenotype_user_trait_phenotype_id_fkey C
materialized_phenoview.phenotype_id Implied Constraint R
nd_experiment_phenotype.phenotype_id nd_experiment_phenotype_phenotype_id_fkey C
phenotype_comparison.phenotype1_id phenotype_comparison_phenotype1_id_fkey C
phenotype_comparison.phenotype2_id phenotype_comparison_phenotype2_id_fkey C
phenotype_cvterm.phenotype_id phenotype_cvterm_phenotype_id_fkey C
phenotypeprop.phenotype_id phenotypeprop_phenotype_id_fkey C
phenstatement.phenotype_id phenstatement_phenotype_id_fkey C
uniquename text 2147483647 null
observable_id int4 10 √ null
cvterm.cvterm_id phenotype_observable_id_fkey C
attr_id int4 10 √ null
cvterm.cvterm_id phenotype_attr_id_fkey N
value varchar 2147483647 √ null
cvalue_id int4 10 √ null
cvterm.cvterm_id phenotype_cvalue_id_fkey N
assay_id int4 10 √ null
cvterm.cvterm_id phenotype_assay_id_fkey N
individual_id int4 10 √ null
individual.individual_id phenotype_individual_id_fkey C
sp_person_id int4 10 √ null
sp_person.sp_person_id phenotype_sp_person_id_fkey N
name text 2147483647 √ null
create_date timestamp 29,6 √ now()
collect_date timestamp 29,6 √ null
operator varchar 128 √ null

Indexes

Constraint Name Type Sort Column(s)
phenotype_pkey Primary key Asc phenotype_id
phenotype_c1 Must be unique Asc uniquename
phenotype_idx1 Performance Asc cvalue_id
phenotype_idx2 Performance Asc observable_id
phenotype_idx3 Performance Asc attr_id

Relationships

Close relationships within degrees of separation