Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mgi_organism
A record in this table represents an Organism.

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_organism_key int4 10
acc_logicaldb._organism_key acc_logicaldb__organism_key_fkey R
acc_logicaldb_view._organism_key Implied Constraint R
acc_view._organism_key Implied Constraint R
gxd_antibody._organism_key gxd_antibody__organism_key_fkey R
gxd_antibody_view._organism_key Implied Constraint R
gxd_antibodyantigen_view._organism_key Implied Constraint R
gxd_antigen_view._organism_key Implied Constraint R
gxd_htsample._organism_key gxd_htsample__organism_key_fkey R
mgi_organism_antigen_view._organism_key Implied Constraint R
mgi_organism_marker_view._organism_key Implied Constraint R
mgi_organism_mgitype._organism_key mgi_organism_mgitype__organism_key_fkey C
mgi_organism_mgitype_view._organism_key Implied Constraint R
mgi_organism_probe_view._organism_key Implied Constraint R
mgi_organism_view._organism_key Implied Constraint R
mgi_synonym_allele_view._organism_key Implied Constraint R
mgi_synonym_goterm_view._organism_key Implied Constraint R
mgi_synonym_musmarker_view._organism_key Implied Constraint R
mgi_synonym_strain_view._organism_key Implied Constraint R
mgi_synonymtype._organism_key mgi_synonymtype__organism_key_fkey R
mgi_synonymtype_allele_view._organism_key Implied Constraint R
mgi_synonymtype_goterm_view._organism_key Implied Constraint R
mgi_synonymtype_musmarker_view._organism_key Implied Constraint R
mgi_synonymtype_strain_view._organism_key Implied Constraint R
mrk_acc_view._organism_key Implied Constraint R
mrk_chromosome._organism_key mrk_chromosome__organism_key_fkey C
mrk_do_cache._organism_key mrk_do_cache__organism_key_fkey R
mrk_label._organism_key mrk_label__organism_key_fkey R
mrk_label._orthologorganism_key mrk_label__orthologorganism_key_fkey R
mrk_location_cache._organism_key mrk_location_cache__organism_key_fkey R
mrk_marker._organism_key mrk_marker__organism_key_fkey R
mrk_marker_view._organism_key Implied Constraint R
mrk_mouse_view._organism_key Implied Constraint R
mrk_nonmouse_view._organism_key Implied Constraint R
prb_rflv_view._organism_key Implied Constraint R
prb_source._organism_key prb_source__organism_key_fkey R
prb_source_view._organism_key Implied Constraint R
pwi_mrk_marker_view._organism_key Implied Constraint R
seq_marker_cache._organism_key seq_marker_cache__organism_key_fkey R
seq_sequence._organism_key seq_sequence__organism_key_fkey R
seq_sequence_view._organism_key Implied Constraint R
organism (foreign key to MGI_Organism)
commonname text 2147483647 common name of organism
latinname text 2147483647  √  null latin name of organism
_createdby_key int4 10 1001
mgi_user._user_key mgi_organism__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key mgi_organism__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 77 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_organism_key Primary key, Used to cluster data Asc mgi_organism_pkey
commonname Performance Asc mgi_organism_idx_commonname
_createdby_key Performance Asc mgi_organism_idx_createdby_key
_modifiedby_key Performance Asc mgi_organism_idx_modifiedby_key

Close relationships  within of separation: