Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.prb_strain
A record in this table represents a unique strain or genetic background. Accession IDs for Strains (MGI, JRS, EMMA, MMRC, etc.) are stored in the ACC_Accession table.

Generated by
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
_strain_key serial 10  √  nextval('prb_strain_seq'::regclass)
all_allele._strain_key all_allele__strain_key_fkey R
all_cellline._strain_key all_cellline__strain_key_fkey R
all_variant._strain_key all_variant__strain_key_fkey R
crs_cross._femalestrain_key crs_cross__femalestrain_key_fkey R
crs_cross._malestrain_key crs_cross__malestrain_key_fkey R
crs_cross._strainho_key crs_cross__strainho_key_fkey R
crs_cross._strainht_key crs_cross__strainht_key_fkey R
gxd_genotype._strain_key gxd_genotype__strain_key_fkey R
mld_fish._strain_key mld_fish__strain_key_fkey R
mld_insitu._strain_key mld_insitu__strain_key_fkey R
mrk_strainmarker._strain_key mrk_strainmarker__strain_key_fkey R
prb_allele_strain._strain_key prb_allele_strain__strain_key_fkey R
prb_source._strain_key prb_source__strain_key_fkey R
prb_strain_genotype._strain_key prb_strain_genotype__strain_key_fkey C
prb_strain_marker._strain_key prb_strain_marker__strain_key_fkey C
ri_riset._strain_key_1 ri_riset__strain_key_1_fkey R
ri_riset._strain_key_2 ri_riset__strain_key_2_fkey R
primary key
_species_key int4 10
voc_term._term_key prb_strain__species_key_fkey R
foreign key to VOC_Term where _Vocab_key = 26 (Strain Species)
_straintype_key int4 10
voc_term._term_key prb_strain__straintype_key_fkey R
foreign key to VOC_Term where _Vocab_key = 55 (Strain Type)
strain text 2147483647 strain description
standard int2 5 if 1, then the strain is official.
private int2 5 if 1, then the Strain record is private (deleted from public copies of the database)
geneticbackground int2 5 genetic background/strain prefix
_createdby_key int4 10 1001
mgi_user._user_key prb_strain__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key prb_strain__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 89,555 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_strain_key Primary key Asc prb_strain_pkey
_createdby_key Performance Asc prb_strain_idx_createdby_key
creation_date Performance Asc prb_strain_idx_creation_date
modification_date Performance Asc prb_strain_idx_modification_date
_modifiedby_key Performance Asc prb_strain_idx_modifiedby_key
_species_key Performance Asc prb_strain_idx_species_key
strain Performance Asc prb_strain_idx_strain
_straintype_key Performance Asc prb_strain_idx_straintype_key

Close relationships  within of separation: