Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.all_knockout_cache
A record in this table represents a Deltagen or Lexicon knockout.

 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
_knockout_key int4 10 primary key
_marker_key int4 10
mrk_marker._marker_key all_knockout_cache__marker_key_fkey C
foreign key to MRK_Marker
_allele_key int4 10  √  null
all_allele._allele_key all_knockout_cache__allele_key_fkey R
foreign key to ALL_Allele
holder text 2147483647 the holder of the knockout (Deltagen or Lexicon)
repository text 2147483647 the repository from which this knockout is available (JAX or MMRRC)
companyid text 2147483647  √  null the company ID of the knockout (the Deltagen or Lexicon ID)
nihid text 2147483647  √  null the NIH ID of the knockout
jrsid text 2147483647  √  null the Jax Registry ID (JRS) of the knockout
_createdby_key int4 10 1001
mgi_user._user_key all_knockout_cache__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key all_knockout_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 257 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort Constraint Name
_knockout_key Primary key Asc all_knockout_cache_pkey
_marker_key Must be unique Asc all_knockout_cache_idx_marker_key
_allele_key Performance, Used to cluster data Asc all_knockout_cache_idx_clustered

Close relationships  within of separation: