SchemaSpy Analysis of cxgn.phenome - Columns

 Generated by
SchemaSpy
Generated by SchemaSpy on Thu Aug 28 01:30 EDT 2008
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
cxgn.phenome contains 335 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
alias allele_alias text 2147483647
alias locus_alias text 2147483647
allele_alias_id allele_alias serial 10  √  nextval('allele_alias_allele_alias_id_seq'::regclass)
allele_dbxref_id allele_dbxref serial 10  √  nextval('allele_dbxref_allele_dbxref_id_seq'::regclass)
allele_history_id allele_history serial 10  √  nextval('allele_history_allele_history_id_seq'::regclass)
allele_id allele serial 10  √  nextval('allele_allele_id_seq'::regclass)
allele_alias.allele_id allele_alias_allele_id_fkey
allele_dbxref.allele_id allele_dbxref_allele_id_fkey
allele_history.allele_id allele_history_allele_id_fkey
individual_allele.allele_id individual_allele_allele_id_fkey
phenotype.allele_id phenotype_allele_id_fkey
allele_id allele_alias int4 10
allele.allele_id allele_alias_allele_id_fkey
allele_id allele_dbxref int4 10
allele.allele_id allele_dbxref_allele_id_fkey
allele_id allele_history int4 10
allele.allele_id allele_history_allele_id_fkey
allele_id individual_allele int8 19
allele.allele_id individual_allele_allele_id_fkey
allele_id phenotype int4 10  √  null
allele.allele_id phenotype_allele_id_fkey
allele_name allele varchar 255  √  null
allele_name allele_history varchar 32  √  null
allele_notes allele text 2147483647  √  null
allele_phenotype allele text 2147483647  √  null
allele_phenotype allele_history text 2147483647  √  null
allele_symbol allele varchar 32  √  null
allele_symbol allele_history varchar 32  √  null
allele_synonym allele _varchar 2147483647  √  null
allele_type phenotype varchar 255  √  null
background_accession_id genotype int8 19  √  null
background_accession_id genotype_experiment int8 19  √  null
background_accession_id population int8 19  √  null
chromosome tomato_il_bin int4 10
common_name_id individual int8 19  √  null
common_name_id locus int4 10
complete tomato_term2term int8 19 (0)::bigint
create_date allele timestamptz 35,6  √  now()
create_date allele_alias timestamptz 35,6  √  now()
create_date allele_dbxref timestamptz 35,6  √  now()
create_date allele_history timestamptz 35,6  √  now()
create_date genotype timestamptz 35,6  √  null
create_date genotype_experiment timestamptz 35,6  √  null
create_date genotype_region timestamptz 35,6 now()
create_date germplasm timestamptz 35,6  √  now()
create_date individual timestamptz 35,6  √  now()
create_date individual_allele timestamptz 35,6  √  now()
create_date individual_dbxref timestamptz 35,6  √  now()
create_date individual_dbxref_evidence timestamptz 35,6  √  now()
create_date individual_dbxref_evidence_history timestamptz 35,6  √  now()
create_date individual_history timestamptz 35,6  √  now()
create_date individual_locus timestamptz 35,6  √  now()
create_date locus timestamptz 35,6  √  now()
create_date locus2locus timestamptz 35,6  √  now()
create_date locus_alias timestamptz 35,6  √  now()
create_date locus_dbxref timestamptz 35,6  √  now()
create_date locus_dbxref_evidence timestamptz 35,6  √  now()
create_date locus_dbxref_evidence_history timestamptz 35,6  √  now()
create_date locus_history timestamptz 35,6  √  now()
create_date locus_marker timestamptz 35,6  √  now()
create_date locus_owner timestamptz 35,6  √  now()
create_date locus_registry timestamptz 35,6  √  now()
create_date locus_unigene timestamptz 35,6  √  now()
create_date polymorphic_fragment timestamptz 35,6  √  null
create_date population timestamptz 35,6  √  now()
create_date population_dbxref timestamptz 35,6  √  now()
create_date registry timestamptz 35,6  √  now()
dbxref_id allele_dbxref int4 10
dbxref_id germplasm int8 19  √  null
dbxref_id individual_dbxref int4 10
dbxref_id locus_dbxref int4 10
dbxref_id population_dbxref int4 10
dbxref_type_definition dbxref_type varchar 255  √  null
dbxref_type_id dbxref_type serial 10  √  nextval('dbxref_type_dbxref_type_id_seq'::regclass)
dbxref_type_name dbxref_type varchar 32  √  null
dbxref_type_url dbxref_type varchar 255  √  null
description germplasm text 2147483647  √  null
description individual text 2147483647  √  null
description individual_history text 2147483647  √  null
description locus text 2147483647  √  null
description population text 2147483647  √  null
description registry text 2147483647
evidence_code individual_dbxref_evidence int4 10  √  null
evidence_code individual_dbxref_evidence_history int4 10  √  null
evidence_code locus_dbxref_evidence_history int4 10  √  null
evidence_code_id locus_dbxref_evidence int4 10  √  null
evidence_description individual_dbxref_evidence int4 10  √  null
evidence_description individual_dbxref_evidence_history int4 10  √  null
evidence_description locus_dbxref_evidence_history int4 10  √  null
evidence_description_id locus_dbxref_evidence int4 10  √  null
evidence_id locus2locus int8 19  √  null
evidence_with individual_dbxref_evidence int4 10  √  null
evidence_with individual_dbxref_evidence_history int4 10  √  null
evidence_with locus_dbxref_evidence int4 10  √  null
evidence_with locus_dbxref_evidence_history int4 10  √  null
experiment_name genotype varchar 100  √  null
experiment_name genotype_experiment varchar 100  √  null
flanking_marker1_id polymorphic_fragment int8 19  √  null
flanking_marker2_id polymorphic_fragment int8 19  √  null
gene_activity locus text 2147483647  √  null
gene_activity locus_history text 2147483647  √  null
genotype_experiment_id genotype int8 19  √  null
genotype_experiment.genotype_experiment_id genotype_genotype_experiment_id_fkey
genotype_experiment_id genotype_experiment serial 10  √  nextval('genotype_experiment_genotype_experiment_id_seq'::regclass)
genotype.genotype_experiment_id genotype_genotype_experiment_id_fkey
genotype_id genotype serial 10  √  nextval('genotype_genotype_id_seq'::regclass)
genotype_region.genotype_id genotype_region_genotype_id_fkey
polymorphic_fragment.genotype_id polymorphic_fragment_genotype_id_fkey
genotype_id genotype_region int4 10  √  null
genotype.genotype_id genotype_region_genotype_id_fkey
optional genotype this region belongs to.  some regions are artificial, arising from combinations of other regions, and thus do not have an associated genotype
genotype_id polymorphic_fragment int8 19  √  null
genotype.genotype_id polymorphic_fragment_genotype_id_fkey
genotype_region_id genotype_region serial 10  √  nextval('genotype_region_genotype_region_id_seq'::regclass)
germplasm_id germplasm serial 10  √  nextval('germplasm_germplasm_id_seq'::regclass)
germplasm_type germplasm varchar 10  √  null
granted_by locus_owner int4 10  √  null
il_bin_id tomato_il_bin serial 10  √  nextval('tomato_il_bin_il_bin_id_seq'::regclass)
image_file_name image varchar 20  √  null
image_id image serial 10  √  nextval('image_image_id_seq'::regclass)
individual_allele_id individual_allele serial 10  √  nextval('individual_allele_individual_allele_id_seq'::regclass)
individual_dbxref_evidence_history_id individual_dbxref_evidence_history serial 10  √  nextval('individual_dbxref_evidence_hi_individual_dbxref_evidence_hi_seq'::regclass)
individual_dbxref_evidence_id individual_dbxref_evidence serial 10  √  nextval('individual_dbxref_evidence_individual_dbxref_evidence_id_seq'::regclass)
individual_dbxref_evidence_history.individual_dbxref_evidence_id individual_dbxref_evidence_hi_individual_dbxref_evidence_i_fkey
individual_dbxref_evidence_id individual_dbxref_evidence_history int4 10  √  null
individual_dbxref_evidence.individual_dbxref_evidence_id individual_dbxref_evidence_hi_individual_dbxref_evidence_i_fkey
individual_dbxref_id individual_dbxref serial 10  √  nextval('individual_dbxref_individual_dbxref_id_seq'::regclass)
individual_dbxref_evidence.individual_dbxref_id individual_dbxref_evidence_individual_dbxref_id_fkey
individual_dbxref_evidence_history.individual_dbxref_id individual_dbxref_evidence_history_individual_dbxref_id_fkey
individual_dbxref_id individual_dbxref_evidence int4 10  √  null
individual_dbxref.individual_dbxref_id individual_dbxref_evidence_individual_dbxref_id_fkey
individual_dbxref_id individual_dbxref_evidence_history int4 10  √  null
individual_dbxref.individual_dbxref_id individual_dbxref_evidence_history_individual_dbxref_id_fkey
individual_history_id individual_history serial 10  √  nextval('individual_history_individual_history_id_seq'::regclass)
individual_id genotype int8 19  √  null
individual.individual_id genotype_individual_id_fkey
individual_id germplasm int8 19
individual.individual_id germplasm_individual_id_fkey
individual_id individual serial 10  √  nextval('individual_individual_id_seq'::regclass)
genotype.individual_id genotype_individual_id_fkey
germplasm.individual_id germplasm_individual_id_fkey
individual_allele.individual_id individual_allele_individual_id_fkey
individual_dbxref.individual_id individual_dbxref_individual_id_fkey
individual_history.individual_id individual_history_individual_id_fkey
individual_locus.individual_id individual_locus_individual_id_fkey
individual_id individual_allele int8 19
individual.individual_id individual_allele_individual_id_fkey
individual_id individual_dbxref int4 10
individual.individual_id individual_dbxref_individual_id_fkey
individual_id individual_history int4 10
individual.individual_id individual_history_individual_id_fkey
individual_id individual_locus int8 19
individual.individual_id individual_locus_individual_id_fkey
individual_locus_id individual_locus serial 10  √  nextval('individual_locus_individual_locus_id_seq'::regclass)
is_default allele bool 1  √  true
is_obsolete tomato_term int8 19 (0)::bigint
is_root tomato_term int8 19 (0)::bigint
lg_arm locus varchar 16  √  null
lg_arm locus_history varchar 16  √  null
lg_id genotype_region int4 10  √  null the linkage group in a specific version of a specific map where this region is located
linkage_group locus varchar 16  √  null
linkage_group locus_history varchar 16  √  null
linkage_group polymorphic_fragment text 2147483647  √  null
locus2locus_id locus2locus serial 10  √  nextval('locus2locus_locus2locus_id_seq'::regclass)
locus_alias_id locus_alias serial 10  √  nextval('locus_alias_locus_alias_id_seq'::regclass)
locus_dbxref_evidence_history_id locus_dbxref_evidence_history serial 10  √  nextval('locus_dbxref_evidence_history_locus_dbxref_evidence_history_seq'::regclass)
locus_dbxref_evidence_id locus_dbxref_evidence serial 10  √  nextval('locus_dbxref_evidence_locus_dbxref_evidence_id_seq'::regclass)
locus_dbxref_evidence_history.locus_dbxref_evidence_id locus_dbxref_evidence_history_locus_dbxref_evidence_id_fkey
locus_dbxref_evidence_id locus_dbxref_evidence_history int4 10  √  null
locus_dbxref_evidence.locus_dbxref_evidence_id locus_dbxref_evidence_history_locus_dbxref_evidence_id_fkey
locus_dbxref_id locus_dbxref serial 10  √  nextval('locus_dbxref_locus_dbxref_id_seq'::regclass)
locus_dbxref_evidence.locus_dbxref_id locus_dbxref_evidence_locus_dbxref_id_fkey
locus_dbxref_evidence_history.locus_dbxref_id locus_dbxref_evidence_history_locus_dbxref_id_fkey
locus_dbxref_id locus_dbxref_evidence int4 10  √  null
locus_dbxref.locus_dbxref_id locus_dbxref_evidence_locus_dbxref_id_fkey
locus_dbxref_id locus_dbxref_evidence_history int4 10  √  null
locus_dbxref.locus_dbxref_id locus_dbxref_evidence_history_locus_dbxref_id_fkey
locus_description locus_history text 2147483647  √  null
locus_history_id locus_history serial 10  √  nextval('locus_history_locus_history_id_seq'::regclass)
locus_id allele int4 10  √  null
locus.locus_id allele_locus_id_fkey
locus_id allele_history int4 10
locus.locus_id allele_history_locus_id_fkey
locus_id individual_locus int8 19
locus.locus_id individual_locus_locus_id_fkey
locus_id locus serial 10  √  nextval('locus_locus_id_seq'::regclass)
allele.locus_id allele_locus_id_fkey
allele_history.locus_id allele_history_locus_id_fkey
individual_locus.locus_id individual_locus_locus_id_fkey
locus2locus.object_id locus2locus_object_id_fkey
locus2locus.subject_id locus2locus_subject_id_fkey
locus_alias.locus_id locus_alias_locus_id_fkey
locus_dbxref.locus_id locus_dbxref_locus_id_fkey
locus_history.locus_id locus_history_locus_id_fkey
locus_marker.locus_id locus_marker_locus_id_fkey
locus_owner.locus_id locus_owner_locus_id_fkey
locus_registry.locus_id locus_registry_locus_id_fkey
locus_unigene.locus_id locus_unigene_locus_id_fkey
phenotype.locus_id phenotype_locus_id_fkey
variant.locus_id variant_locus_id_fkey
locus_id locus_alias int4 10
locus.locus_id locus_alias_locus_id_fkey
locus_id locus_dbxref int4 10
locus.locus_id locus_dbxref_locus_id_fkey
locus_id locus_history int4 10
locus.locus_id locus_history_locus_id_fkey
locus_id locus_marker int4 10
locus.locus_id locus_marker_locus_id_fkey
locus_id locus_owner int4 10
locus.locus_id locus_owner_locus_id_fkey
locus_id locus_registry int4 10  √  null
locus.locus_id locus_registry_locus_id_fkey
locus_id locus_unigene int4 10
locus.locus_id locus_unigene_locus_id_fkey
locus_id phenotype int4 10  √  null
locus.locus_id phenotype_locus_id_fkey
locus_id variant int4 10
locus.locus_id variant_locus_id_fkey
locus_marker_id locus_marker serial 10  √  nextval('locus_marker_locus_marker_id_seq'::regclass)
locus_name locus varchar 255
locus_name locus_history varchar 255  √  null
locus_notes locus text 2147483647  √  null
locus_notes locus_history text 2147483647  √  null
locus_owner_id locus_owner serial 10  √  nextval('locus_owner_locus_owner_id_seq'::regclass)
locus_registry_id locus_registry serial 10  √  nextval('locus_registry_locus_registry_id_seq'::regclass)
locus_symbol locus varchar 32
locus_symbol locus_history varchar 32  √  null
locus_unigene_id locus_unigene serial 10  √  nextval('locus_unigene_locus_unigene_id_seq'::regclass)
marker_id locus_marker int4 10
marker_id_nn genotype_region int8 19  √  null the north marker in the pair of markers bracketing the north end of this region. this may be null for regions at the north end of a linkage group
marker_id_ns genotype_region int8 19 the south marker in the pair of markers bracketing the north end of this region
marker_id_sn genotype_region int8 19 the north marker in the pair of markers bracketing the south end of this region
marker_id_ss genotype_region int8 19  √  null the south marker in the pair of markers bracketing the south end of this region. this may be null for regions at the south end of a linkage group.
mode_of_inheritance allele varchar 18  √  null
mode_of_inheritance allele_history varchar 18  √  null
modified_date allele timestamptz 35,6  √  null
modified_date allele_alias timestamptz 35,6  √  null
modified_date allele_dbxref timestamptz 35,6  √  null
modified_date genotype timestamptz 35,6  √  null
modified_date genotype_experiment timestamptz 35,6  √  null
modified_date genotype_region timestamptz 35,6 now()
modified_date germplasm timestamptz 35,6  √  null
modified_date individual timestamptz 35,6  √  null
modified_date individual_allele timestamptz 35,6  √  null
modified_date individual_dbxref timestamptz 35,6  √  null
modified_date individual_dbxref_evidence timestamptz 35,6  √  null
modified_date individual_dbxref_evidence_history timestamptz 35,6  √  null
modified_date individual_locus timestamptz 35,6  √  null
modified_date locus timestamptz 35,6  √  null
modified_date locus2locus timestamptz 35,6  √  null
modified_date locus_alias timestamptz 35,6  √  null
modified_date locus_dbxref timestamptz 35,6  √  null
modified_date locus_dbxref_evidence timestamptz 35,6  √  null
modified_date locus_dbxref_evidence_history timestamptz 35,6  √  null
modified_date locus_marker timestamptz 35,6  √  null
modified_date locus_owner timestamptz 35,6  √  null
modified_date locus_registry timestamptz 35,6  √  null
modified_date locus_unigene timestamptz 35,6  √  null
modified_date polymorphic_fragment timestamptz 35,6  √  null
modified_date population timestamptz 35,6  √  null
modified_date population_dbxref timestamptz 35,6  √  null
modified_date registry timestamptz 35,6  √  null
n_marker_n tomato_il_bin int4 10  √  null
n_marker_s tomato_il_bin int4 10  √  null
name genotype_region varchar 32  √  null special name for this region, if any.  optional
name individual varchar 100  √  null
name individual_history varchar 255  √  null
name population varchar 100  √  null
name registry varchar 255
name tomato_il_bin varchar 32
object_id locus2locus int8 19  √  null
locus.locus_id locus2locus_object_id_fkey
obsolete allele bool 1  √  false
obsolete allele_alias bool 1  √  false
obsolete allele_dbxref bool 1  √  false
obsolete allele_history bool 1  √  false
obsolete genotype bool 1  √  false
obsolete genotype_experiment bool 1  √  false
obsolete genotype_region bool 1 false
obsolete germplasm bool 1  √  false
obsolete individual bool 1  √  false
obsolete individual_allele bool 1  √  false
obsolete individual_dbxref bool 1  √  false
obsolete individual_dbxref_evidence bool 1  √  false
obsolete individual_dbxref_evidence_history bool 1  √  false
obsolete individual_history bool 1  √  false
obsolete individual_locus bool 1  √  false
obsolete locus bool 1  √  false
obsolete locus2locus bool 1  √  false
obsolete locus_alias bool 1  √  false
obsolete locus_dbxref bool 1  √  false
obsolete locus_dbxref_evidence bool 1  √  false
obsolete locus_dbxref_evidence_history bool 1  √  false
obsolete locus_history bool 1  √  false
obsolete locus_marker bool 1  √  false
obsolete locus_owner bool 1  √  false
obsolete locus_registry bool 1  √  false
obsolete locus_unigene bool 1  √  false
obsolete polymorphic_fragment bool 1  √  false
obsolete population bool 1  √  false
obsolete population_dbxref bool 1  √  false
origin registry varchar 32  √  null
original_symbol locus varchar 32  √  null