Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.crs_cross
Controlled vocabulary table for all Mapping Cross descriptions.

See MLD_Matrix, CRS_Matrix.

 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
_cross_key int4 10
crs_matrix
crs_progeny
crs_references
mld_matrix
primary key
type text 2147483647 type of cross
_femalestrain_key int4 10
prb_strain
foreign key to PRB_Strain; maternal strain
femaleallele1 bpchar 1  √  null first allele of maternal strain; used during construction of maternal genotype
femaleallele2 bpchar 1  √  null second allele of maternal strain; used during construction of maternal genotype
_malestrain_key int4 10
prb_strain
foreign key to PRB_Strain; paternal strain
maleallele1 bpchar 1  √  null first allele of paternal strain; used during construction of paternal genotype
maleallele2 bpchar 1  √  null second allele of paternal strain; used during construction of paternal genotype
abbrevho text 2147483647  √  null strain abbreviation for homozygous strain
_strainho_key int4 10
prb_strain
foreign key to PRB_Strain; homozygous strain
abbrevht text 2147483647  √  null strain abbreviation for heterozygous strain
_strainht_key int4 10
prb_strain
foreign key to PRB_Strain; heterozygous strain
whosecross text 2147483647  √  null if non-null, then name of cross. if null, then this is a one-time only anonymous cross.
allelefromsegparent int2 5 is the allele from the segregating parent?
f1directionknown int2 5 is the F1 direction known?
nprogeny int4 10  √  null number of progeny resulting from cross
displayed int2 5 does this cross get displayed in the Cross Lookup list? yes (1), no (0)
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 4,491 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort
_cross_key Primary key Asc
_femalestrain_key Performance Asc
_malestrain_key Performance Asc
_strainho_key Performance Asc
_strainht_key Performance Asc
type Performance Asc
whosecross Performance Asc

Close relationships  within of separation: