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 serial 10  √  nextval('mgi_organism_seq'::regclass)
acc_logicaldb._organism_key acc_logicaldb__organism_key_fkey R
gxd_antibody._organism_key gxd_antibody__organism_key_fkey R
gxd_htsample._organism_key gxd_htsample__organism_key_fkey R
gxd_htsample_rnaseqset._organism_key gxd_htsample_rnaseqset__organism_key_fkey R
mgi_organism_mgitype._organism_key mgi_organism_mgitype__organism_key_fkey C
mgi_synonymtype._organism_key mgi_synonymtype__organism_key_fkey 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
prb_source._organism_key prb_source__organism_key_fkey R
seq_marker_cache._organism_key seq_marker_cache__organism_key_fkey R
seq_sequence._organism_key seq_sequence__organism_key_fkey 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 110 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort Constraint Name
_organism_key Primary key 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: