Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.gxd_allelepair
Defines Allele Pair for Genotype object. Each pair specifies two alleles, both of which must be associated with the same marker. Allele Pairs may be homozygous, heterzygous or hemizygous. For hemizygous Allele Pairs, Allele 2 is null.

See GXD_Genotype.

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
_allelepair_key int4 10
gxd_allelepair_view._allelepair_key Implied Constraint R
primary key
_genotype_key int4 10
gxd_genotype._genotype_key gxd_allelepair__genotype_key_fkey C
foreign key to GXD_Genotype
_allele_key_1 int4 10
all_allele._allele_key gxd_allelepair__allele_key_1_fkey R
foreign key to ALL_Allele
_allele_key_2 int4 10  √  null
all_allele._allele_key gxd_allelepair__allele_key_2_fkey R
foreign key to ALL_Allele
_marker_key int4 10  √  null
mrk_marker._marker_key gxd_allelepair__marker_key_fkey R
foreign key to MRK_Marker
_mutantcellline_key_1 int4 10  √  null
all_cellline._cellline_key gxd_allelepair__mutantcellline_key_1_fkey R
foreign key to ALL_CellLine
_mutantcellline_key_2 int4 10  √  null
all_cellline._cellline_key gxd_allelepair__mutantcellline_key_2_fkey R
foreign key to ALL_CellLine
_pairstate_key int4 10
voc_term._term_key gxd_allelepair__pairstate_key_fkey R
foreign key to VOC_Term where _Vocab_key = 39 (Allele Pair State)
_compound_key int4 10
voc_term._term_key gxd_allelepair__compound_key_fkey R
foreign key to VOC_Term where _Vocab_key = 74 (GXD Conditional Mutants)
sequencenum int4 10 sequence number for ordering records
_createdby_key int4 10 1001
mgi_user._user_key gxd_allelepair__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key gxd_allelepair__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 93,037 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_allelepair_key Primary key, Used to cluster data Asc gxd_allelepair_pkey
_allele_key_2 Performance Asc gxd_allelepair_idx_allele_key_2
_allele_key_1 Performance Asc gxd_allelepair_idx_clustered
_compound_key Performance Asc gxd_allelepair_idx_compound_key
_createdby_key Performance Asc gxd_allelepair_idx_createdby_key
_genotype_key Performance Asc gxd_allelepair_idx_genotype_key
_marker_key Performance Asc gxd_allelepair_idx_marker_key
_modifiedby_key Performance Asc gxd_allelepair_idx_modifiedby_key
_mutantcellline_key_1 Performance Asc gxd_allelepair_idx_mutantcellline_key_1
_mutantcellline_key_2 Performance Asc gxd_allelepair_idx_mutantcellline_key_2
_pairstate_key Performance Asc gxd_allelepair_idx_pairstate_key

Close relationships  within of separation: