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
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
_strain_key int4 10
all_allele._strain_key all_allele__strain_key_fkey R
all_allele_view._strain_key Implied Constraint R
all_cellline._strain_key all_cellline__strain_key_fkey R
all_cellline_view._strain_key Implied Constraint 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_antibodyantigen_view._strain_key Implied Constraint R
gxd_antigen_view._strain_key Implied Constraint R
gxd_genotype._strain_key gxd_genotype__strain_key_fkey R
gxd_genotype_view._strain_key Implied Constraint R
mld_fish._strain_key mld_fish__strain_key_fkey R
mld_fish_view._strain_key Implied Constraint R
mld_insitu._strain_key mld_insitu__strain_key_fkey R
mld_insitu_view._strain_key Implied Constraint R
prb_allele_strain._strain_key prb_allele_strain__strain_key_fkey R
prb_rflv_view._strain_key Implied Constraint R
prb_source._strain_key prb_source__strain_key_fkey R
prb_source_view._strain_key Implied Constraint R
prb_strain_attribute_view._strain_key Implied Constraint R
prb_strain_genotype._strain_key prb_strain_genotype__strain_key_fkey C
prb_strain_genotype_view._strain_key Implied Constraint R
prb_strain_marker._strain_key prb_strain_marker__strain_key_fkey C
prb_strain_marker_view._strain_key Implied Constraint R
prb_strain_view._strain_key Implied Constraint R
pwi_all_allele_view._strain_key Implied Constraint R
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 = 27 (Strain Attributes)
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 48,057 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_strain_key Primary key, Used to cluster data Asc prb_strain_pkey
_createdby_key Performance Asc prb_strain_idx_createdby_key
_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: