SchemaSpy Analysis of cxgn.sgn - Constraints

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

Constraint Name Child Column Parent Column
accession_id_fk pcr_exp_accession.accession_id accession.accession_id
accession_name_id_fk accession.accession_name_id accession_names.accession_name_id
apply_id_fkey blast_annotations.apply_id unigene.unigene_id
author_id_fk manual_annotations.author_id
blast_db_blast_db_group_id_fkey blast_db.blast_db_group_id blast_db_group.blast_db_group_id
blast_hits_blast_annotation_id_fkey blast_hits.blast_annotation_id blast_annotations.blast_annotation_id
cds_protein_feature_id_fkey cds.protein_feature_id
cds_unigene_id_fkey cds.unigene_id unigene.unigene_id
clone_id_fk seqread.clone_id clone.clone_id
common_name_id_fk organism.common_name_id common_name.common_name_id
confidence_fk deprecated_marker_locations.confidence deprecated_marker_confidences.legacy_conf_id
domain_dbxref_id_fkey domain.dbxref_id
domain_match_cds_id_fkey domain_match.cds_id cds.cds_id
domain_match_domain_id_fkey domain_match.domain_id domain.domain_id
domain_match_metadata_id_fkey domain_match.metadata_id metadata.metadata_id
domain_metadata_id_fkey domain.metadata_id metadata.metadata_id
enzyme_id_fk pcr_product.enzyme_id enzymes.enzyme_id
est_dbxref_dbxref_id_fkey est_dbxref.dbxref_id
est_dbxref_est_id_fkey est_dbxref.est_id est.est_id
est_id_fk qc_report.est_id est.est_id
est_id_fkey unigene_member.est_id est.est_id
experiment_type_id_fk pcr_experiment.experiment_type_id experiment_type.experiment_type_id
facility_id_fk seqread.facility_id facility.facility_id
family_family_build_id_fkey family.family_build_id family_build.family_build_id
family_member_family_id_fkey family_member.family_id family.family_id
family_tree_family_id_fkey family_tree.family_id family.family_id
fish_experimenter_id_fkey fish_result.fish_experimenter_id fish_experimenter.fish_experimenter_id
fish_result_attribution_id_fkey fish_result.attribution_id
fish_result_clone_id_fkey fish_result.clone_id clone.clone_id
foriegn submit_user.sp_person_id
forward_seq_id_fk rflp_markers.forward_seq_id rflp_sequences.seq_id
interpro_go_go_accession_fkey interpro_go.go_accession go.go_accession
interpro_go_interpro_accession_fkey interpro_go.interpro_accession interpro.interpro_accession
lg_id_fk deprecated_mapdata.lg_id deprecated_linkage_groups.lg_id
library_id_fk clone.library_id library.library_id
library_sp_person_id_fkey library.sp_person_id
linkage_group_map_version_id_fkey linkage_group.map_version_id map_version.map_version_id
linkage_group_north_location_id_fkey linkage_group.north_location_id marker_location.location_id
linkage_group_south_location_id_fkey linkage_group.south_location_id marker_location.location_id
loc_id_fk deprecated_marker_locations.loc_id deprecated_mapdata.loc_id
map_ancestor_fkey map.ancestor accession.accession_id
map_id_fk pcr_experiment.map_id map.map_id
map_id_fkey fish_result.map_id deprecated_maps.map_id
map_parent_1_fkey map.parent_1 accession.accession_id
map_parent_2_fkey map.parent_2 accession.accession_id
map_version_default_threshold_fkey map_version.default_threshold deprecated_marker_confidences.confidence_id
map_version_map_id_fkey map_version.map_id map.map_id
marker_alias_marker_id_fkey marker_alias.marker_id marker.marker_id
marker_collectible_marker_id_fkey marker_collectible.marker_id marker.marker_id
marker_collectible_mc_id_fkey marker_collectible.mc_id marker_collection.mc_id
marker_derived_from_derived_from_source_id_fkey marker_derived_from.derived_from_source_id derived_from_source.derived_from_source_id
marker_derived_from_marker_id_fkey marker_derived_from.marker_id deprecated_markers.marker_id
marker_experiment_location_id_fkey marker_experiment.location_id marker_location.location_id
marker_experiment_marker_id_fkey marker_experiment.marker_id marker.marker_id
marker_experiment_pcr_experiment_id_fkey marker_experiment.pcr_experiment_id pcr_experiment.pcr_experiment_id
marker_experiment_rflp_experiment_id_fkey marker_experiment.rflp_experiment_id rflp_markers.rflp_id
marker_id_fk primer_unigene_match.marker_id marker.marker_id
marker_location_confidence_id_fkey marker_location.confidence_id marker_confidence.confidence_id
marker_location_lg_id_fkey marker_location.lg_id linkage_group.lg_id
marker_location_map_version_id_fkey marker_location.map_version_id map_version.map_version_id
marker_type_fk deprecated_markers.marker_type deprecated_marker_types.marker_type_id
metadata_create_person_id_fkey metadata.create_person_id
metadata_modified_person_id_fkey metadata.modified_person_id
organism_family_tax_fkey organism.family_tax taxonomy.tax_id
organism_genus_tax_fkey organism.genus_tax taxonomy.tax_id
organism_id_fk accession.organism_id organism.organism_id
organism_order_tax_fkey organism.order_tax taxonomy.tax_id
organism_subfamily_tax_fkey organism.subfamily_tax taxonomy.tax_id
organismprop_common_name_id_fkey organismprop.common_name_id common_name.common_name_id
organismprop_type_id_fkey organismprop.type_id
pcr_exp_accession_id_fk pcr_product.pcr_exp_accession_id pcr_exp_accession.pcr_exp_accession_id
pcr_experiment_id_fk pcr_exp_accession.pcr_experiment_id pcr_experiment.pcr_experiment_id
primer_id_fwd_fk pcr_experiment.primer_id_fwd sequence.sequence_id
primer_id_rev_fk pcr_experiment.primer_id_rev sequence.sequence_id
primer_unigene_match_unigene_id_fkey primer_unigene_match.unigene_id unigene.unigene_id
read_id_fkey est.read_id seqread.read_id
reverse_seq_id_fk rflp_markers.reverse_seq_id rflp_sequences.seq_id
rflp_seq_id_fk rflp_unigene_associations.rflp_seq_id rflp_sequences.seq_id
ssr_id_fk ssr_primer_unigene_matches.ssr_id ssr.ssr_id
temp_map_correspondence_map_version_id_fkey temp_map_correspondence.map_version_id map_version.map_version_id
temp_map_correspondence_old_map_id_fkey temp_map_correspondence.old_map_id deprecated_maps.map_id
temp_marker_correspondence_old_marker_id_fkey temp_marker_correspondence.old_marker_id deprecated_markers.marker_id
tm_id_fk tm_markers.tm_id tm_markers.tm_id
type_fkey library.type types.type_id
unigene_build_blast_db_id_fkey unigene_build.blast_db_id blast_db.blast_db_id
unigene_build_latest_build_id_fkey unigene_build.latest_build_id unigene_build.unigene_build_id
unigene_build_next_build_id_fkey unigene_build.next_build_id unigene_build.unigene_build_id
unigene_build_organism_group_id_fkey unigene_build.organism_group_id groups.group_id
unigene_build_superseding_build_id_fkey unigene_build.superseding_build_id unigene_build.unigene_build_id
unigene_id_fk rflp_unigene_associations.unigene_id unigene.unigene_id
unigene_member_unigene_id_fkey unigene_member.unigene_id unigene.unigene_id
unigene_unigene_build_id_fkey unigene.unigene_build_id unigene_build.unigene_build_id
unigene_unigene_consensi_id_fkey unigene.consensi_id unigene_consensi.consensi_id

Check Constraints:

Table Constraint Name Constraint
None detected