Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.mld_expts
Defines a Mapping Experiment for a specific Reference. A Reference may have one or more Experiments associated with it. Each Experiment within a specific Reference is assigned an Experiment Type and and Experiment Tag value (CROSS-1). The currently supported Experiment Types are: CONTIG, CROSS, FISH, HYBRID, IN SITU, MAP, RI, TEXT.

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
_expt_key serial 10  √  nextval('mld_expts_seq'::regclass)
mld_concordance._expt_key mld_concordance__expt_key_fkey C
mld_contig._expt_key mld_contig__expt_key_fkey C
mld_expt_marker._expt_key mld_expt_marker__expt_key_fkey C
mld_expt_notes._expt_key mld_expt_notes__expt_key_fkey C
mld_fish._expt_key mld_fish__expt_key_fkey C
mld_fish_region._expt_key mld_fish_region__expt_key_fkey C
mld_hit._expt_key mld_hit__expt_key_fkey C
mld_hybrid._expt_key mld_hybrid__expt_key_fkey C
mld_insitu._expt_key mld_insitu__expt_key_fkey C
mld_isregion._expt_key mld_isregion__expt_key_fkey C
mld_matrix._expt_key mld_matrix__expt_key_fkey C
mld_mc2point._expt_key mld_mc2point__expt_key_fkey C
mld_mcdatalist._expt_key mld_mcdatalist__expt_key_fkey C
mld_ri._expt_key mld_ri__expt_key_fkey C
mld_ri2point._expt_key mld_ri2point__expt_key_fkey C
mld_ridata._expt_key mld_ridata__expt_key_fkey C
mld_statistics._expt_key mld_statistics__expt_key_fkey C
ri_summary_expt_ref._expt_key ri_summary_expt_ref__expt_key_fkey R
primary key
_refs_key int4 10
bib_refs._refs_key mld_expts__refs_key_fkey R
foreign key to BIB_Refs
expttype text 2147483647 experiment type (ex. CROSS, RI, FISH, IN SITU, TEXT)
tag int4 10 unique integer value for each experiment type defined for a given reference (CROSS-1, CROSS-2, etc.)
chromosome text 2147483647 chromosome value
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 24,051 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_expt_key Primary key, Used to cluster data Asc mld_expts_pkey
chromosome Performance Asc mld_expts_idx_chromosome
creation_date Performance Asc mld_expts_idx_creation_date
expttype Performance Asc mld_expts_idx_expttype
modification_date Performance Asc mld_expts_idx_modification_date
_refs_key Performance Asc mld_expts_idx_refs_key

Close relationships  within of separation: