Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mrk_mcv_count_cache
A cache of the current number of markers annotated to a given Feature Type Vocab Term (formerly known as Marker Category Vocabulary)

 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
_mcvterm_key int4 10
mrk_mcv_cache._mcvterm_key Implied Constraint R
foreign key to VOC_Term (_Vocab_key = 79)
markercount int4 10 the current number of markers annotated to this term
_createdby_key int4 10 1001
mgi_user._user_key mrk_mcv_count_cache__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key mrk_mcv_count_cache__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 54 rows at Mon May 07 06:18 EDT 2018

Indexes:
Column(s) Type Sort Constraint Name
_mcvterm_key Primary key, Used to cluster data Asc mrk_mcv_count_cache_pkey

Close relationships  within of separation: