SchemaSpy Analysis of cxgn.public - Constraints

Generated by
SchemaSpy
140 Foreign Key Constraints:
SourceForge.net
Please support this project

Constraint Name Child Column Parent Column
analysisfeature_analysis_id_fkey analysisfeature.analysis_id analysis.analysis_id
analysisfeature_feature_id_fkey analysisfeature.feature_id feature.feature_id
analysisprop_analysis_id_fkey analysisprop.analysis_id analysis.analysis_id
analysisprop_type_id_fkey analysisprop.type_id cvterm.cvterm_id
blastwatch_queries_sp_person_id_fkey blastwatch_queries.sp_person_id
blastwatch_results_blastwatch_queries_id_fkey blastwatch_results.blastwatch_queries_id blastwatch_queries.blastwatch_queries_id
bug_created_by_fkey bug.created_by
bug_sp_person_id_fkey bug.sp_person_id
bug_updated_by_fkey bug.updated_by
clone_feature_clone_id_fkey clone_feature.clone_id
clone_feature_feature_id_fkey clone_feature.feature_id feature.feature_id
clone_in_silico_digestion_ban_clone_in_silico_digestion_id_fkey clone_in_silico_digestion_bands.clone_in_silico_digestion_id clone_in_silico_digestion.clone_in_silico_digestion_id
clone_in_silico_digestion_clone_id_fkey clone_in_silico_digestion.clone_id
clone_in_silico_digestion_enzyme_id_fkey clone_in_silico_digestion.enzyme_id
cvterm_cv_id_fkey cvterm.cv_id cv.cv_id
cvterm_dbxref_cvterm_id_fkey cvterm_dbxref.cvterm_id cvterm.cvterm_id
cvterm_dbxref_dbxref_id_fkey cvterm_dbxref.dbxref_id dbxref.dbxref_id
cvterm_dbxref_id_fkey cvterm.dbxref_id dbxref.dbxref_id
cvterm_pub_ranking_cvterm_id_fkey cvterm_pub_ranking.cvterm_id cvterm.cvterm_id
cvterm_pub_ranking_pub_id_fkey cvterm_pub_ranking.pub_id pub.pub_id
cvterm_relationship_object_id_fkey cvterm_relationship.object_id cvterm.cvterm_id
cvterm_relationship_subject_id_fkey cvterm_relationship.subject_id cvterm.cvterm_id
cvterm_relationship_type_id_fkey cvterm_relationship.type_id cvterm.cvterm_id
cvtermpath_cv_id_fkey cvtermpath.cv_id cv.cv_id
cvtermpath_object_id_fkey cvtermpath.object_id cvterm.cvterm_id
cvtermpath_subject_id_fkey cvtermpath.subject_id cvterm.cvterm_id
cvtermpath_type_id_fkey cvtermpath.type_id cvterm.cvterm_id
cvtermprop_cvterm_id_fkey cvtermprop.cvterm_id cvterm.cvterm_id
cvtermprop_type_id_fkey cvtermprop.type_id cvterm.cvterm_id
cvtermsynonym_cvterm_id_fkey cvtermsynonym.cvterm_id cvterm.cvterm_id
cvtermsynonym_type_id_fkey cvtermsynonym.type_id cvterm.cvterm_id
dbxref_db_id_fkey dbxref.db_id db.db_id
dbxrefprop_dbxref_id_fkey dbxrefprop.dbxref_id dbxref.dbxref_id
dbxrefprop_type_id_fkey dbxrefprop.type_id cvterm.cvterm_id
enzyme_restriction_sites_enzyme_id_fkey enzyme_restriction_sites.enzyme_id
feature_cvterm_cvterm_id_fkey feature_cvterm.cvterm_id cvterm.cvterm_id
feature_cvterm_dbxref_dbxref_id_fkey feature_cvterm_dbxref.dbxref_id dbxref.dbxref_id
feature_cvterm_dbxref_feature_cvterm_id_fkey feature_cvterm_dbxref.feature_cvterm_id feature_cvterm.feature_cvterm_id
feature_cvterm_feature_id_fkey feature_cvterm.feature_id feature.feature_id
feature_cvterm_pub_feature_cvterm_id_fkey feature_cvterm_pub.feature_cvterm_id feature_cvterm.feature_cvterm_id
feature_cvterm_pub_id_fkey feature_cvterm.pub_id pub.pub_id
feature_cvterm_pub_pub_id_fkey feature_cvterm_pub.pub_id pub.pub_id
feature_cvtermprop_feature_cvterm_id_fkey feature_cvtermprop.feature_cvterm_id feature_cvterm.feature_cvterm_id
feature_cvtermprop_type_id_fkey feature_cvtermprop.type_id cvterm.cvterm_id
feature_dbxref_dbxref_id_fkey feature_dbxref.dbxref_id dbxref.dbxref_id
feature_dbxref_feature_id_fkey feature_dbxref.feature_id feature.feature_id
feature_dbxref_id_fkey feature.dbxref_id dbxref.dbxref_id
feature_organism_id_fkey feature.organism_id organism.organism_id
feature_pub_feature_id_fkey feature_pub.feature_id feature.feature_id
feature_pub_pub_id_fkey feature_pub.pub_id pub.pub_id
feature_relationship_object_id_fkey feature_relationship.object_id feature.feature_id
feature_relationship_pub_feature_relationship_id_fkey feature_relationship_pub.feature_relationship_id feature_relationship.feature_relationship_id
feature_relationship_pub_pub_id_fkey feature_relationship_pub.pub_id pub.pub_id
feature_relationship_subject_id_fkey feature_relationship.subject_id feature.feature_id
feature_relationship_type_id_fkey feature_relationship.type_id cvterm.cvterm_id
feature_relationshipprop_feature_relationship_id_fkey feature_relationshipprop.feature_relationship_id feature_relationship.feature_relationship_id
feature_relationshipprop_pub_feature_relationshipprop_id_fkey feature_relationshipprop_pub.feature_relationshipprop_id feature_relationshipprop.feature_relationshipprop_id
feature_relationshipprop_pub_pub_id_fkey feature_relationshipprop_pub.pub_id pub.pub_id
feature_relationshipprop_type_id_fkey feature_relationshipprop.type_id cvterm.cvterm_id
feature_synonym_feature_id_fkey feature_synonym.feature_id feature.feature_id
feature_synonym_pub_id_fkey feature_synonym.pub_id pub.pub_id
feature_synonym_synonym_id_fkey feature_synonym.synonym_id synonym.synonym_id
feature_type_id_fkey feature.type_id cvterm.cvterm_id
featureloc_feature_id_fkey featureloc.feature_id feature.feature_id
featureloc_pub_featureloc_id_fkey featureloc_pub.featureloc_id featureloc.featureloc_id
featureloc_pub_pub_id_fkey featureloc_pub.pub_id pub.pub_id
featureloc_srcfeature_id_fkey featureloc.srcfeature_id feature.feature_id
featureprop_feature_id_fkey featureprop.feature_id feature.feature_id
featureprop_pub_featureprop_id_fkey featureprop_pub.featureprop_id featureprop.featureprop_id
featureprop_pub_pub_id_fkey featureprop_pub.pub_id pub.pub_id
featureprop_type_id_fkey featureprop.type_id cvterm.cvterm_id
fpc_band_fpc_fingerprint_id_fkey fpc_band.fpc_fingerprint_id fpc_fingerprint.fpc_fingerprint_id
fpc_build_fpc_fingerprint_fpc_build_id_fkey fpc_build_fpc_fingerprint.fpc_build_id fpc_build.fpc_build_id
fpc_build_fpc_fingerprint_fpc_fingerprint_id_fkey fpc_build_fpc_fingerprint.fpc_fingerprint_id fpc_fingerprint.fpc_fingerprint_id
fpc_build_fpc_series_id_fkey fpc_build.fpc_series_id fpc_series.fpc_series_id
fpc_contig_clone_clone_id_fkey fpc_contig_clone.clone_id
fpc_contig_clone_fpc_contig_id_fkey fpc_contig_clone.fpc_contig_id fpc_contig.fpc_contig_id
fpc_contig_fpc_build_id_fkey fpc_contig.fpc_build_id fpc_build.fpc_build_id
fpc_fingerprint_clone_id_fkey fpc_fingerprint.clone_id
fpc_fingerprint_enzyme_id_fkey fpc_fingerprint.enzyme_id
image_experiment_experiment_id_fkey image_experiment.experiment_id
image_experiment_image_id_fkey image_experiment.image_id image.image_id
image_fish_result_fish_result_id_fkey image_fish_result.fish_result_id
image_fish_result_image_id_fkey image_fish_result.image_id image.image_id
image_individual_image_id_fkey image_individual.image_id image.image_id
image_individual_individual_id_fkey image_individual.individual_id
image_locus_image_id_fkey image_locus.image_id image.image_id
image_locus_locus_id_fkey image_locus.locus_id
image_sp_person_id_fkey image.sp_person_id
locus_pub_ranking_locus_id_fkey locus_pub_ranking.locus_id
locus_pub_ranking_pub_id_fkey locus_pub_ranking.pub_id pub.pub_id
locus_pub_ranking_validate_locus_id_fkey locus_pub_ranking_validate.locus_id
locus_pub_ranking_validate_pub_id_fkey locus_pub_ranking_validate.pub_id pub.pub_id
organism_dbxref_dbxref_id_fkey organism_dbxref.dbxref_id dbxref.dbxref_id
organism_dbxref_organism_id_fkey organism_dbxref.organism_id organism.organism_id
organism_relationship_object_id_fkey organism_relationship.object_id organism.organism_id
organism_relationship_subject_id_fkey organism_relationship.subject_id organism.organism_id
organism_relationship_type_id_fkey organism_relationship.type_id cvterm.cvterm_id
organism_sgn_organism_id_fkey organism.sgn_organism_id organism.organism_id
organismpath_object_id_fkey organismpath.object_id organism.organism_id
organismpath_subject_id_fkey organismpath.subject_id organism.organism_id
organismpath_type_id_fkey organismpath.type_id cvterm.cvterm_id
organismprop_organism_id_fkey organismprop.organism_id organism.organism_id
organismprop_type_id_fkey organismprop.type_id cvterm.cvterm_id
phenotype_assay_id_fkey phenotype.assay_id cvterm.cvterm_id
phenotype_attr_id_fkey phenotype.attr_id cvterm.cvterm_id
phenotype_cvalue_id_fkey phenotype.cvalue_id cvterm.cvterm_id
phenotype_cvterm_cvterm_id_fkey phenotype_cvterm.cvterm_id cvterm.cvterm_id
phenotype_cvterm_phenotype_id_fkey phenotype_cvterm.phenotype_id phenotype.phenotype_id
phenotype_individual_id_fkey phenotype.individual_id
phenotype_observable_id_fkey phenotype.observable_id cvterm.cvterm_id
phenotype_sp_person_id_fkey phenotype.sp_person_id
pub_curator_assigned_to_fkey pub_curator.assigned_to
pub_curator_curated_by_fkey pub_curator.curated_by
pub_curator_pub_id_fkey pub_curator.pub_id pub.pub_id
pub_curator_sp_person_id_fkey pub_curator.sp_person_id
pub_dbxref_dbxref_id_fkey pub_dbxref.dbxref_id dbxref.dbxref_id
pub_dbxref_pub_id_fkey pub_dbxref.pub_id pub.pub_id
pub_relationship_object_id_fkey pub_relationship.object_id pub.pub_id
pub_relationship_subject_id_fkey pub_relationship.subject_id pub.pub_id
pub_relationship_type_id_fkey pub_relationship.type_id cvterm.cvterm_id
pub_type_id_fkey pub.type_id cvterm.cvterm_id
pubabstract_pub_id_fkey pubabstract.pub_id pub.pub_id
pubauthor_pub_id_fkey pubauthor.pub_id pub.pub_id
pubprop_pub_id_fkey pubprop.pub_id pub.pub_id
pubprop_type_id_fkey pubprop.type_id cvterm.cvterm_id
synonym_type_id_fkey synonym.type_id cvterm.cvterm_id
tag_experiment_experiment_id_fkey tag_experiment.experiment_id
tag_experiment_sp_person_id_fkey tag_experiment.sp_person_id
tag_experiment_tag_id_fkey tag_experiment.tag_id tag.tag_id
tag_image_image_id_fkey tag_image.image_id image.image_id
tag_image_sp_person_id_fkey tag_image.sp_person_id
tag_image_tag_id_fkey tag_image.tag_id tag.tag_id
tag_sp_person_id_fkey tag.sp_person_id
unigene_dbxref_dbxref_id_fkey unigene_dbxref.dbxref_id dbxref.dbxref_id
unigene_dbxref_unigene_id_fkey unigene_dbxref.unigene_id
unigene_relations_superceded_by_fkey unigene_relations.superceded_by
unigene_relations_unigene_id_fkey unigene_relations.unigene_id
unigene_signalp_cds_id_fkey unigene_signalp.cds_id
unigene_signalp_unigene_id_fkey unigene_signalp.unigene_id

Check Constraints:

Table Constraint Name Constraint
None detected