Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.all_cre_cache
A record in this table represents the cached values of a Cre Allele (that may/may not contain Assay information). See ALL_Allele, GXD_Assay, allcacheload/allelecrecache.csh.

 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
_cache_key int4 10
seq_marker_cache._cache_key Implied Constraint R
primary key
_allele_key int4 10
all_allele._allele_key all_cre_cache__allele_key_fkey C
foreign key to ALL_Allele
_allele_type_key int4 10
voc_term._term_key all_cre_cache__allele_type_key_fkey C
foreign key to VOC_Term where _Vocab_key = 38 (Allele Type)
_emapa_term_key int4 10  √  null
voc_term._term_key all_cre_cache__emapa_term_key_fkey C
foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
_celltype_term_key int4 10  √  null
voc_term._term_key all_cre_cache__celltype_term_key_fkey C
foreign key to VOC_Term where _Vocab_key = 102 (Cell Ontology)
_stage_key int4 10  √  null
gxd_theilerstage._stage_key all_cre_cache__stage_key_fkey C
foreign key to GXD_TheilerStage
_assay_key int4 10  √  null
gxd_assay._assay_key all_cre_cache__assay_key_fkey C
foreign key to GXD_Assay
strength text 2147483647  √  null
accid text 2147483647 accession id
symbol text 2147483647 Allele symbol
name text 2147483647 Allele name
alleletype text 2147483647 allele type name (VOC_Term.term) via ALL_Allele._AlleleType_key = VOC_Term._Term_key
drivernote text 2147483647 MGI_Relationship._Object_key_2 (marker) where _Category_key = 1006
emapaterm text 2147483647  √  null term from VOC_Term where _Vocab_key = 90
age text 2147483647  √  null age of anatomical structure
agemin numeric 131089  √  null minimum age value determined by age field
agemax numeric 131089  √  null maximum age value determined by age field
expressed int4 10  √  null if 1 (true), then this Assay is expressing this Structure, else 0
hasimage int4 10  √  null does this record have an image?
cresystemlabel text 2147483647  √  null Cre System Label
_createdby_key int4 10 1001
mgi_user._user_key all_cre_cache__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key all_cre_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 62,804 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort Constraint Name
_cache_key Primary key Asc all_cre_cache_pkey
_allele_key Performance Asc all_cre_cache_idx_allele_key
_allele_type_key Performance Asc all_cre_cache_idx_allele_type_key
_assay_key Performance Asc all_cre_cache_idx_assay_key
_celltype_term_key Performance Asc all_cre_cache_idx_celltype_term_key
_allele_key + _emapa_term_key + _stage_key + _assay_key + expressed Performance, Used to cluster data Asc/Asc/Asc/Asc/Asc all_cre_cache_idx_clustered
_emapa_term_key Performance Asc all_cre_cache_idx_emapa_term_key
_stage_key Performance Asc all_cre_cache_idx_stage_key

Close relationships  within of separation: