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
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)
primary key
_strain_key int4 10
prb_strain
foreign key to PRB_Strain
_marker_key int4 10  √  null
mrk_marker
foreign key to MRK_Marker
_allele_key int4 10  √  null
all_allele
foreign key to ALL_Allele
_qualifier_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 31 (Strain Allele Qualifier); 'nomenclature'
_createdby_key int4 10 1001
mgi_user
user who created the record
_modifiedby_key int4 10 1001
mgi_user
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
_strainmarker_key Primary key, Used to cluster data Asc
_allele_key Performance Asc
_strain_key Performance Asc
_createdby_key Performance Asc
_marker_key Performance Asc
_modifiedby_key Performance Asc
_qualifier_key Performance Asc

Close relationships  within of separation: