Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.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
_cross_key int4 10
crs_matrix._cross_key crs_matrix__cross_key R
crs_progeny._cross_key crs_progeny__cross_key R
crs_references._cross_key crs_references__cross_key R
mld_matrix._cross_key mld_matrix__cross_key R
type varchar 3
_femalestrain_key int4 10
prb_strain._strain_key crs_cross__femalestrain_key R
femaleallele1 bpchar 1  √  null
femaleallele2 bpchar 1  √  null
_malestrain_key int4 10
maleallele1 bpchar 1  √  null
maleallele2 bpchar 1  √  null
abbrevho varchar 4  √  null
_strainho_key int4 10
prb_strain._strain_key crs_cross__strainho_key R
abbrevht varchar 4  √  null
_strainht_key int4 10
prb_strain._strain_key crs_cross__strainht_key R
whosecross varchar 30  √  null
allelefromsegparent int2 5
f1directionknown int2 5  √  null
nprogeny int4 10  √  null
displayed int2 5  √  null
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 4,491 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_cross_key Primary key Asc crs_cross_pkey
_cross_key Must be unique Asc crs_cross_idx_cross_key
_femalestrain_key Performance Asc crs_cross_idx_femalestrain_key
_malestrain_key Performance Asc crs_cross_idx_malestrain_key
_strainho_key Performance Asc crs_cross_idx_strainho_key
_strainht_key Performance Asc crs_cross_idx_strainht_key
type Performance Asc crs_cross_idx_type
whosecross Performance Asc crs_cross_idx_whosecross

Close relationships  within of separation: