Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.prb_strain_marker
A record in this table represents a Strain/Marker/Allele association. An associations is qualified using the _Qualifier_key. A Strain can have 0 or more Marker/Allele pairs associated with it.

A Strain may be created as the result of a mutation (transgenic allele), in which case the transgenic allele is associated with the newly bred Strain using this table. For example: MGI:4847055/Tg(Foxi2-EGFP)HX217Gsat, strain of origin: FVB/NTac. New Strain: MGI:5003868/STOCK Tg(Foxi2-EGFP)HX217Gsat/Mmucd associated with MGI:5003868/Tg(Foxi2-EGFP)HX217Gsat via PRB_Strain/PRB_Strain_Marker.

 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
_strainmarker_key serial 10  √  nextval('prb_strain_marker_seq'::regclass)
mrk_strainmarker._strainmarker_key Implied Constraint R
primary key
_strain_key int4 10
prb_strain._strain_key prb_strain_marker__strain_key_fkey C
foreign key to PRB_Strain
_marker_key int4 10  √  null
mrk_marker._marker_key prb_strain_marker__marker_key_fkey R
foreign key to MRK_Marker
_allele_key int4 10  √  null
all_allele._allele_key prb_strain_marker__allele_key_fkey R
foreign key to ALL_Allele
_qualifier_key int4 10
voc_term._term_key prb_strain_marker__qualifier_key_fkey R
foreign key to VOC_Term where _Vocab_key = 31 (Strain Allele Qualifier); 'nomenclature'
_createdby_key int4 10 1001
mgi_user._user_key prb_strain_marker__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key prb_strain_marker__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 79,202 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort Constraint Name
_strainmarker_key Primary key, Used to cluster data Asc prb_strain_marker_pkey
_allele_key Performance Asc prb_strain_marker_idx_allele_key
_strain_key Performance Asc prb_strain_marker_idx_clustered
_createdby_key Performance Asc prb_strain_marker_idx_createdby_key
_marker_key Performance Asc prb_strain_marker_idx_marker_key
_modifiedby_key Performance Asc prb_strain_marker_idx_modifiedby_key
_qualifier_key Performance Asc prb_strain_marker_idx_qualifier_key

Close relationships  within of separation: