Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.go_tracking
A record in this table represents the GO Tracking history for a specific Gene (_Marker_key).

 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
_marker_key int4 10
all_allele_driver_view._marker_key Implied Constraint R
all_allele_view._marker_key Implied Constraint R
bib_goxref_view._marker_key Implied Constraint R
go_tracking_view._marker_key Implied Constraint R
gxd_allelepair_view._marker_key Implied Constraint R
gxd_antibodymarker_view._marker_key Implied Constraint R
gxd_assay_view._marker_key Implied Constraint R
gxd_index_view._marker_key Implied Constraint R
mld_concordance_view._marker_key Implied Constraint R
mld_expt_marker_view._marker_key Implied Constraint R
mld_ridata_view._marker_key Implied Constraint R
mrk_alias._marker_key Implied Constraint R
mrk_alias_view._marker_key Implied Constraint R
mrk_anchors_view._marker_key Implied Constraint R
mrk_current_view._marker_key Implied Constraint R
mrk_history_view._marker_key Implied Constraint R
mrk_marker_view._marker_key Implied Constraint R
mrk_mouse_view._marker_key Implied Constraint R
mrk_nonmouse_view._marker_key Implied Constraint R
mrk_reference_view._marker_key Implied Constraint R
prb_marker_view._marker_key Implied Constraint R
prb_rflv_view._marker_key Implied Constraint R
prb_strain_marker_view._marker_key Implied Constraint R
pwi_all_allele_view._marker_key Implied Constraint R
pwi_mrk_marker_view._marker_key Implied Constraint R
seq_marker_cache_view._marker_key Implied Constraint R
mrk_marker._marker_key go_tracking__marker_key_fkey C
foreign key to MRK_Marker
isreferencegene int2 5 if 1, then the gene is a reference gene, else 0.
_completedby_key int4 10  √  null
mgi_user._user_key go_tracking__completedby_key_fkey R
user who completed the record
_createdby_key int4 10 1001
mgi_user._user_key go_tracking__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key go_tracking__modifiedby_key_fkey R
user who last modified the record
completion_date timestamp 29,6  √  now() date GO Tracking was completed
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 111,521 rows at Mon Mar 09 10:28 EDT 2020

Indexes:
Column(s) Type Sort Constraint Name
_marker_key Primary key, Used to cluster data Asc go_tracking_pkey
_completedby_key Performance Asc go_tracking_idx_completedby_key
completion_date Performance Asc go_tracking_idx_completion_date

Close relationships  within of separation: