Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
View pub.mgd.pwi_all_allele_view 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
_allele_key int4 10  √  null
all_allele._allele_key Implied Constraint R
_marker_key int4 10  √  null
go_tracking._marker_key Implied Constraint R
_strain_key int4 10  √  null
prb_strain._strain_key Implied Constraint R
_mode_key int4 10  √  null
_allele_type_key int4 10  √  null
_allele_status_key int4 10  √  null
_transmission_key int4 10  √  null
_collection_key int4 10  √  null
map_coord_collection._collection_key Implied Constraint R
symbol text 2147483647  √  null
name text 2147483647  √  null
iswildtype int2 5  √  null
isextinct int2 5  √  null
ismixed int2 5  √  null
_refs_key int4 10  √  null
bib_refs._refs_key Implied Constraint R
_markerallele_status_key int4 10  √  null
_createdby_key int4 10  √  null
_modifiedby_key int4 10  √  null
_approvedby_key int4 10  √  null
approval_date timestamp 29,6  √  null
creation_date timestamp 29,6  √  null
modification_date timestamp 29,6  √  null
mgiid text 2147483647  √  null

Analyzed at Mon Nov 20 05:26 EST 2017


Close relationships: