SchemaSpy - Table pub.mgd.go

A record in this table represents the GO Tracking history for a specific Gene (_Marker_key).

Generated by
SchemaSpy

Legend:

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

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
gxd_allelepair_view._marker_key	Implied Constraint R
gxd_antibodymarker_view._marker_key	Implied Constraint R
gxd_assay_dltemplate_view._marker_key	Implied Constraint R
gxd_assay_view._marker_key	Implied Constraint R
gxd_index_summaryby_view._marker_key	Implied Constraint R
gxd_index_view._marker_key	Implied Constraint R
mld_expt_marker_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_summarybyreference_view._marker_key	Implied Constraint R
prb_marker_view._marker_key	Implied Constraint R
prb_strain_marker_view._marker_key	Implied Constraint R

mrk_marker._marker_key

go_tracking__marker_key_fkey C

foreign key to MRK_Marker

isreferencegene

int2

if 1, then the gene is a reference gene, else 0.

_completedby_key

int4

√

null

mgi_user._user_key

go_tracking__completedby_key_fkey R

user who completed the record

_createdby_key

int4

1001

mgi_user._user_key

go_tracking__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

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 109,235 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_marker_key	Primary key	Asc	go_tracking_pkey
_completedby_key	Performance	Asc	go_tracking_idx_completedby_key
completion_date	Performance	Asc	go_tracking_idx_completion_date
_createdby_key	Performance	Asc	go_tracking_idx_createdby_key
creation_date	Performance	Asc	go_tracking_idx_creation_date
modification_date	Performance	Asc	go_tracking_idx_modification_date
_modifiedby_key	Performance	Asc	go_tracking_idx_modifiedby_key