Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mld_matrix
Defines CROSS Experiment. Cross Experiments may use a well-defined Cross or a one-time only mating of two strains.
The Editorial Interface constructs the female and male genotypes based on the number of Markers used in the Experiment and the allele abbreviations designated for the Cross.

See MLD_MC2point, MLC_MCDataList, CRS_Cross.

 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
_expt_key int4 10
mld_expts._expt_key mld_matrix__expt_key_fkey C
foreign key to MLD_Expts
_cross_key int4 10
crs_cross._cross_key mld_matrix__cross_key_fkey R
foreign key to CRS_Cross
female text 2147483647  √  null genotype of mother
female2 text 2147483647  √  null genotype of mother; overflow
male text 2147483647  √  null genotype of father
male2 text 2147483647  √  null genotype of father; overflow
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 6,925 rows at Mon Jun 07 06:53 EDT 2021

Indexes:
Column(s) Type Sort Constraint Name
_expt_key Primary key, Used to cluster data Asc mld_matrix_pkey
_cross_key Performance Asc mld_matrix_idx_cross_key

Close relationships  within of separation: