Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.mld_expts 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_concordance._expt_key mld_concordance__expt_key R
mld_contig._expt_key mld_contig__expt_key R
mld_distance._expt_key mld_distance__expt_key R
mld_expt_marker._expt_key mld_expt_marker__expt_key R
mld_expt_notes._expt_key mld_expt_notes__expt_key R
mld_fish._expt_key mld_fish__expt_key R
mld_fish_region._expt_key mld_fish_region__expt_key R
mld_hit._expt_key mld_hit__expt_key R
mld_hybrid._expt_key mld_hybrid__expt_key R
mld_insitu._expt_key mld_insitu__expt_key R
mld_isregion._expt_key mld_isregion__expt_key R
mld_matrix._expt_key mld_matrix__expt_key R
mld_mcdatalist._expt_key mld_mcdatalist__expt_key R
mld_physmap._expt_key mld_physmap__expt_key R
mld_ri._expt_key mld_ri__expt_key R
mld_statistics._expt_key mld_statistics__expt_key R
_refs_key int4 10
bib_refs._refs_key mld_expts__refs_key R
expttype varchar 255
tag int4 10
chromosome varchar 8
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 22,289 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_expt_key Primary key Asc mld_expts_pkey
_expt_key Must be unique Asc mld_expts_idx_expt_key
chromosome Performance Asc mld_expts_idx_chromosome
expttype Performance Asc mld_expts_idx_expttype
_refs_key Performance Asc mld_expts_idx_refs_key

Close relationships  within of separation: