SchemaSpy Analysis of cxgn.public - Columns

 Generated by
SchemaSpy
Generated by SchemaSpy on Sat Oct 11 01:33 EDT 2008
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
cxgn.public contains 675 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
abbreviation organism varchar 255  √  null
abstract pubabstract text 2147483647  √  null
abstract_tsvector pubabstract tsvector 2147483647  √  null
accession dbxref varchar 255 The local part of the identifier. Guaranteed by the db authority to be unique for that db
accession_id forward_amplicon_sequence_information text 2147483647  √  null
action bug text 2147483647  √  null
affected_page bug text 2147483647  √  null
agi ara_annotation varchar 16
ara_domain.agi Implied Constraint
ara_gfp_ms.agi Implied Constraint
ara_intron.agi Implied Constraint
ara_properties.agi Implied Constraint
ara_scop.agi Implied Constraint
ara_sequence.agi Implied Constraint
ara_signalp.agi Implied Constraint
ara_targetp.agi Implied Constraint
agi ara_domain varchar 16  √  null
ara_annotation.agi Implied Constraint
agi ara_gfp_ms varchar 16  √  null
ara_annotation.agi Implied Constraint
agi ara_intron varchar 16  √  null
ara_annotation.agi Implied Constraint
agi ara_properties varchar 16
ara_annotation.agi Implied Constraint
agi ara_scop varchar 16  √  null
ara_annotation.agi Implied Constraint
agi ara_sequence varchar 16
ara_annotation.agi Implied Constraint
agi ara_signalp varchar 16
ara_annotation.agi Implied Constraint
agi ara_targetp varchar 16
ara_annotation.agi Implied Constraint
algorithm analysis varchar 255  √  null
aliases ara_annotation text 2147483647  √  null
alignment_seq family_member text 2147483647  √  null
alt_id ara_go_term varchar 12  √  null
analysis_id analysis serial 10  √  nextval('analysis_analysis_id_seq'::regclass)
analysisfeature.analysis_id analysisfeature_analysis_id_fkey
analysisprop.analysis_id analysisprop_analysis_id_fkey
analysis_id analysisfeature int4 10
analysis.analysis_id analysisfeature_analysis_id_fkey
analysis_id analysisprop int4 10
analysis.analysis_id analysisprop_analysis_id_fkey
analysisfeature_id analysisfeature serial 10  √  nextval('analysisfeature_analysisfeature_id_seq'::regclass)
analysisprop_id analysisprop serial 10  √  nextval('analysisprop_analysisprop_id_seq'::regclass)
app_name ara_domain varchar 32  √  null
assay_id phenotype int4 10  √  null
cvterm.cvterm_id phenotype_assay_id_fkey
attr_id phenotype int4 10  √  null
cvterm.cvterm_id phenotype_attr_id_fkey
attribute gff3atts varchar 2147483647  √  null
attribute gffatts varchar 2147483647  √  null
author ara_interactome_all varchar 32  √  null
bac_locus ara_family varchar 128  √  null
band_position fpc_band int4 10  √  null
blastwatch_queries_id blastwatch_queries serial 10  √  nextval('blastwatch_queries_blastwatch_queries_id_seq'::regclass)
blastwatch_results.blastwatch_queries_id blastwatch_results_blastwatch_queries_id_fkey
blastwatch_queries_id blastwatch_results int4 10
blastwatch_queries.blastwatch_queries_id blastwatch_results_blastwatch_queries_id_fkey
blastwatch_results_id blastwatch_results serial 10  √  nextval('blastwatch_results_blastwatch_results_id_seq'::regclass)
bug_id bug serial 10  √  nextval('bug_bug_id_seq'::regclass)
build_date family_build timestamp 29,6  √  null
build_nr family_build int8 19  √  null
c_score ara_targetp float4 8,8  √  null
cdna ara_sequence text 2147483647  √  null
cds ara_sequence text 2147483647  √  null
cds_id family_member int8 19  √  null
cds_id signalp int8 19  √  null
cds_id unigene_signalp int8 19  √  null
children ara_go_term text 2147483647  √  null
chromosome ara_map bpchar 1  √  null
clone_feature_id clone_feature serial 10  √  nextval('clone_feature_clone_feature_id_seq'::regclass)
clone_id clone_feature int8 19  √  null
clone_id clone_in_silico_digestion int4 10  √  null
clone_id fpc_contig_clone int8 19
clone_id fpc_fingerprint int4 10
clone_in_silico_digestion_bands_id clone_in_silico_digestion_bands serial 10  √  nextval('clone_in_silico_digestion_ban_clone_in_silico_digestion_ban_seq'::regclass)
clone_in_silico_digestion_id clone_in_silico_digestion serial 10  √  nextval('clone_in_silico_digestion_clone_in_silico_digestion_id_seq'::regclass)
clone_in_silico_digestion_bands.clone_in_silico_digestion_id clone_in_silico_digestion_ban_clone_in_silico_digestion_id_fkey
clone_in_silico_digestion_id clone_in_silico_digestion_bands int4 10  √  null
clone_in_silico_digestion.clone_in_silico_digestion_id clone_in_silico_digestion_ban_clone_in_silico_digestion_id_fkey
code ara_evidef varchar 10  √  null
comment fpc_build text 2147483647  √  null
comment organism text 2147483647  √  null
common_name organism varchar 255  √  null
confirm_email ara_users bool 1  √  null
create_date bug timestamptz 35,6  √  null
create_date image timestamptz 35,6  √  null
create_date image_locus timestamptz 35,6  √  now()
create_date tag timestamptz 35,6  √  now()
create_date tag_experiment timestamptz 35,6  √  now()
create_date tag_image timestamptz 35,6  √  now()
created_by bug int8 19  √  null
criteria ara_family text 2147483647  √  null
cv_id cv serial 10  √  nextval('cv_cv_id_seq'::regclass)
cvterm.cv_id cvterm_cv_id_fkey
cvtermpath.cv_id cvtermpath_cv_id_fkey
cv_id cvterm int4 10
cv.cv_id cvterm_cv_id_fkey
The cv/ontology/namespace to which
this cvterm belongs
cv_id cvtermpath int4 10
cv.cv_id cvtermpath_cv_id_fkey
Closures will mostly be within
one cv. If the closure of a relationship traverses a cv, then this
refers to the cv of the object_id cvterm
cvalue_id phenotype int4 10  √  null
cvterm.cvterm_id phenotype_cvalue_id_fkey
cvterm_dbxref_id cvterm_dbxref serial 10  √  nextval('cvterm_dbxref_cvterm_dbxref_id_seq'::regclass)
cvterm_id cvterm serial 10  √  nextval('cvterm_cvterm_id_seq'::regclass)
analysisprop.type_id analysisprop_type_id_fkey
cvterm_dbxref.cvterm_id cvterm_dbxref_cvterm_id_fkey
cvterm_relationship.object_id cvterm_relationship_object_id_fkey
cvterm_relationship.subject_id cvterm_relationship_subject_id_fkey
cvterm_relationship.type_id cvterm_relationship_type_id_fkey
cvtermpath.object_id cvtermpath_object_id_fkey
cvtermpath.subject_id cvtermpath_subject_id_fkey
cvtermpath.type_id cvtermpath_type_id_fkey
cvtermprop.cvterm_id cvtermprop_cvterm_id_fkey
cvtermprop.type_id cvtermprop_type_id_fkey
cvtermsynonym.cvterm_id cvtermsynonym_cvterm_id_fkey
cvtermsynonym.type_id cvtermsynonym_type_id_fkey
dbxrefprop.type_id dbxrefprop_type_id_fkey
feature.type_id feature_type_id_fkey
feature_cvterm.cvterm_id feature_cvterm_cvterm_id_fkey
feature_cvtermprop.type_id feature_cvtermprop_type_id_fkey
feature_relationship.type_id feature_relationship_type_id_fkey
feature_relationshipprop.type_id feature_relationshipprop_type_id_fkey
featureprop.type_id featureprop_type_id_fkey
organism_relationship.type_id organism_relationship_type_id_fkey
organismpath.type_id organismpath_type_id_fkey
organismprop.type_id organismprop_type_id_fkey
phenotype.assay_id phenotype_assay_id_fkey
phenotype.attr_id phenotype_attr_id_fkey
phenotype.cvalue_id phenotype_cvalue_id_fkey
phenotype.observable_id phenotype_observable_id_fkey
phenotype_cvterm.cvterm_id phenotype_cvterm_cvterm_id_fkey
pub.type_id pub_type_id_fkey
pub_relationship.type_id pub_relationship_type_id_fkey
pubprop.type_id pubprop_type_id_fkey
synonym.type_id synonym_type_id_fkey
cvterm_id cvterm_dbxref int4 10
cvterm.cvterm_id cvterm_dbxref_cvterm_id_fkey
cvterm_id cvterm_pub_ranking int4 10  √  null
cvterm_id cvtermprop int4 10
cvterm.cvterm_id cvtermprop_cvterm_id_fkey
cvterm_id cvtermsynonym int4 10
cvterm.cvterm_id cvtermsynonym_cvterm_id_fkey
cvterm_id feature_cvterm int4 10
cvterm.cvterm_id feature_cvterm_cvterm_id_fkey
cvterm_id phenotype_cvterm int4 10
cvterm.cvterm_id phenotype_cvterm_cvterm_id_fkey
cvterm_relationship_id cvterm_relationship serial 10  √  nextval('cvterm_relationship_cvterm_relationship_id_seq'::regclass)
cvtermpath_id cvtermpath serial 10  √  nextval('cvtermpath_cvtermpath_id_seq'::regclass)
cvtermprop_id cvtermprop serial 10  √  nextval('cvtermprop_cvtermprop_id_seq'::regclass)
cvtermsynonym_id cvtermsynonym serial 10  √  nextval('cvtermsynonym_cvtermsynonym_id_seq'::regclass)
cxgn_production_visible forward_amplicon_sequence_information bool 1  √  null
cxgn_production_visible forward_amplicon_sequence_markers bool 1  √  null
database ara_interactome_all varchar 32  √  null
database blastwatch_queries varchar 50
database_name family_member varchar 20  √  null
date fpc_build date 13
db_id db serial 10  √  nextval('db_db_id_seq'::regclass)
dbxref.db_id dbxref_db_id_fkey
db_id dbxref int4 10
db.db_id dbxref_db_id_fkey
dbxref_id cvterm int4 10
dbxref.dbxref_id cvterm_dbxref_id_fkey
Primary identifier dbxref - The
unique global OBO identifier for this cvterm.  Note that a cvterm may
have multiple secondary dbxrefs - see also table: cvterm_dbxref
dbxref_id cvterm_dbxref int4 10
dbxref.dbxref_id cvterm_dbxref_dbxref_id_fkey
dbxref_id dbxref serial 10  √  nextval('dbxref_dbxref_id_seq'::regclass)
cvterm.dbxref_id cvterm_dbxref_id_fkey
cvterm_dbxref.dbxref_id cvterm_dbxref_dbxref_id_fkey
dbxrefprop.dbxref_id dbxrefprop_dbxref_id_fkey
feature.dbxref_id feature_dbxref_id_fkey
feature_cvterm_dbxref.dbxref_id feature_cvterm_dbxref_dbxref_id_fkey
feature_dbxref.dbxref_id feature_dbxref_dbxref_id_fkey
organism_dbxref.dbxref_id organism_dbxref_dbxref_id_fkey
pub_dbxref.dbxref_id pub_dbxref_dbxref_id_fkey
unigene_dbxref.dbxref_id unigene_dbxref_dbxref_id_fkey
dbxref_id dbxrefprop int4 10
dbxref.dbxref_id dbxrefprop_dbxref_id_fkey
dbxref_id feature int4 10  √  null
dbxref.dbxref_id feature_dbxref_id_fkey
An optional primary public stable
identifier for this feature. Secondary identifiers and external
dbxrefs go in table:feature_dbxref
dbxref_id feature_cvterm_dbxref int4 10
dbxref.dbxref_id feature_cvterm_dbxref_dbxref_id_fkey
dbxref_id feature_dbxref int4 10
dbxref.dbxref_id feature_dbxref_dbxref_id_fkey
dbxref_id organism_dbxref int4 10
dbxref.dbxref_id organism_dbxref_dbxref_id_fkey
dbxref_id pub_dbxref int4 10
dbxref.dbxref_id pub_dbxref_dbxref_id_fkey
dbxref_id unigene_dbxref int8 19
dbxref.dbxref_id unigene_dbxref_dbxref_id_fkey
dbxrefprop_id dbxrefprop serial 10  √  nextval('dbxrefprop_dbxrefprop_id_seq'::regclass)
definition ara_go_term text 2147483647  √  null
definition cv text 2147483647  √  null A text description of the criteria for
membership of this ontology
definition cvterm text 2147483647  √  null A human-readable text
definition
definition glossary text 2147483647
deleted cxgn_bac_pipeline_loading_log bool 1 false
deleted cxgn_bac_pipeline_processing_log bool 1 false
deleted cxgn_indexedlog_test_feel_free_to_delete_me bool 1 false
deleted itag_loading_log bool 1 false
description analysis text 2147483647  √  null
description ara_evidef text 2147483647  √  null
description ara_scop text 2147483647  √  null
description bug text 2147483647  √  null
description db varchar 255  √  null
description dbxref text 2147483647  √  null
description image text 2147483647  √  null
description project varchar 255
description tag text 2147483647  √  null
direction ara_map bpchar 1  √  null
dom_desc ara_domain varchar 32  √  null
dom_end ara_domain int4 10  √  null
dom_id ara_domain varchar 12  √  null
dom_start ara_domain int4 10  √  null
e_value ara_domain varchar 16  √  null
e_value ara_scop varchar 32  √  null
editor pubauthor bool 1  √  false indicates whether the author is an editor for linked publication. Note: this is a boolean field but does not follow the normal chado convention for naming booleans
email ara_users varchar 32  √  null
ending forward_amplicon_sequence_information text 2147483647  √  null
ending forward_amplicon_sequence_markers text 2147483647  √  null
endpos ara_map int4 10  √  null
enzyme_id clone_in_silico_digestion int4 10  √  null
enzyme_id enzyme_restriction_sites int4 10  √  null
enzyme_id fpc_fingerprint int4 10
enzyme_restriction_sites_id enzyme_restriction_sites serial 10  √  nextval('enzyme_restriction_sites_enzyme_restriction_sites_id_seq'::regclass)
evalue blastwatch_queries float8 17,17
evalue blastwatch_results float8 17,17
evidence ara_myristoylation varchar 8  √  null
experiment_id image_experiment int8 19  √  null
experiment_id tag_experiment int8 19  √  null
expert_annotation ara_family text 2147483647  √  null
expression resource_file text 2147483647
family_annotation family text 2147483647  √  null
family_build_id family int8 19  √  null
family_build_id family_build int8 19  √  null
family_id family int8 19  √  null
family_id family_member int8 19  √  null
family_member_id family_member int8 19  √  null
family_nr family int4 10  √  null
feature_cvterm_dbxref_id feature_cvterm_dbxref serial 10  √  nextval('feature_cvterm_dbxref_feature_cvterm_dbxref_id_seq'::regclass)
feature_cvterm_id feature_cvterm serial 10  √  nextval('feature_cvterm_feature_cvterm_id_seq'::regclass)
feature_cvterm_dbxref.feature_cvterm_id feature_cvterm_dbxref_feature_cvterm_id_fkey
feature_cvterm_pub.feature_cvterm_id feature_cvterm_pub_feature_cvterm_id_fkey
feature_cvtermprop.feature_cvterm_id feature_cvtermprop_feature_cvterm_id_fkey
feature_cvterm_id feature_cvterm_dbxref int4 10
feature_cvterm.feature_cvterm_id feature_cvterm_dbxref_feature_cvterm_id_fkey
feature_cvterm_id feature_cvterm_pub int4 10
feature_cvterm.feature_cvterm_id feature_cvterm_pub_feature_cvterm_id_fkey
feature_cvterm_id feature_cvtermprop int4 10
feature_cvterm.feature_cvterm_id feature_cvtermprop_feature_cvterm_id_fkey
feature_cvterm_pub_id feature_cvterm_pub serial 10  √  nextval('feature_cvterm_pub_feature_cvterm_pub_id_seq'::regclass)
feature_cvtermprop_id feature_cvtermprop serial 10  √  nextval('feature_cvtermprop_feature_cvtermprop_id_seq'::regclass)
feature_dbxref_id feature_dbxref serial 10  √  nextval('feature_dbxref_feature_dbxref_id_seq'::regclass)
feature_id analysisfeature int4 10
feature.feature_id analysisfeature_feature_id_fkey
feature_id clone_feature int8 19  √  null
feature.feature_id clone_feature_feature_id_fkey
feature_id feature serial 10  √  nextval('feature_feature_id_seq'::regclass)
analysisfeature.feature_id analysisfeature_feature_id_fkey
clone_feature.feature_id clone_feature_feature_id_fkey
feature_cvterm.feature_id feature_cvterm_feature_id_fkey
feature_dbxref.feature_id feature_dbxref_feature_id_fkey
feature_pub.feature_id feature_pub_feature_id_fkey
feature_relationship.object_id feature_relationship_object_id_fkey
feature_relationship.subject_id feature_relationship_subject_id_fkey
feature_synonym.feature_id feature_synonym_feature_id_fkey
featureloc.feature_id featureloc_feature_id_fkey
featureloc.srcfeature_id featureloc_srcfeature_id_fkey
featureprop.feature_id featureprop_feature_id_fkey
feature_id feature_cvterm int4 10
feature.feature_id feature_cvterm_feature_id_fkey
feature_id feature_dbxref int4 10
feature.feature_id feature_dbxref_feature_id_fkey
feature_id feature_pub int4 10
feature.feature_id feature_pub_feature_id_fkey
feature_id feature_synonym int4 10
feature.feature_id feature_synonym_feature_id_fkey
feature_id featureloc int4 10
feature.feature_id featureloc_feature_id_fkey
The feature that is being located. Any feature can have zero or more featurelocs
feature_id featureprop int4 10
feature.feature_id featureprop_feature_id_fkey
feature_id gff3atts int4 10  √  null
feature_id gff3view int4 10  √  null
feature_id gffatts int4 10  √  null
feature_id tmp_gff_load_cache int4 10  √  null
feature_pub_id feature_pub serial 10  √  nextval('feature_pub_feature_pub_id_seq'::regclass)
feature_relationship_id feature_relationship serial 10  √  nextval('feature_relationship_feature_relationship_id_seq'::regclass)
feature_relationship_pub.feature_relationship_id feature_relationship_pub_feature_relationship_id_fkey
feature_relationshipprop.feature_relationship_id feature_relationshipprop_feature_relationship_id_fkey
feature_relationship_id feature_relationship_pub int4 10
feature_relationship.feature_relationship_id feature_relationship_pub_feature_relationship_id_fkey
feature_relationship_id feature_relationshipprop int4 10
feature_relationship.feature_relationship_id feature_relationshipprop_feature_relationship_id_fkey
feature_relationship_pub_id feature_relationship_pub serial 10  √  nextval('feature_relationship_pub_feature_relationship_pub_id_seq'::regclass)
feature_relationshipprop_id feature_relationshipprop serial 10  √  nextval('feature_relationshipprop_feature_relationshipprop_id_seq'::regclass)
feature_relationshipprop_pub.feature_relationshipprop_id feature_relationshipprop_pub_feature_relationshipprop_id_fkey
feature_relationshipprop_id feature_relationshipprop_pub int4 10
feature_relationshipprop.feature_relationshipprop_id feature_relationshipprop_pub_feature_relationshipprop_id_fkey
feature_relationshipprop_pub_id feature_relationshipprop_pub serial 10  √  nextval('feature_relationshipprop_pub_feature_relationshipprop_pub_i_seq'::regclass)
feature_synonym_id feature_synonym serial 10  √  nextval('feature_synonym_feature_synonym_id_seq'::regclass)
featureloc_id featureloc serial 10  √  nextval('featureloc_featureloc_id_seq'::regclass)
featureloc_pub.featureloc_id featureloc_pub_featureloc_id_fkey
featureloc_id featureloc_pub int4 10
featureloc.featureloc_id featureloc_pub_featureloc_id_fkey
featureloc_pub_id featureloc_pub serial 10  √  nextval('featureloc_pub_featureloc_pub_id_seq'::regclass)
featureprop_id featureprop serial 10  √  nextval('featureprop_featureprop_id_seq'::regclass)
featureprop_pub.featureprop_id featureprop_pub_featureprop_id_fkey
featureprop_id featureprop_pub int4 10
featureprop.featureprop_id featureprop_pub_featureprop_id_fkey
featureprop_pub_id featureprop_pub serial 10  √  nextval('featureprop_pub_featureprop_pub_id_seq'::regclass)
fend gff3view int4 10  √  null
file_base fpc_build text 2147483647 file basename relative to the base path for keeping fpc data.  the actual filenames are file_base.cor and file_base.fpc
file_ext image varchar 20  √  null
fish_result_id image_fish_result int8 19