Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
View pub.mgd.seq_allele_assoc_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
_accession_key int4 10  √  null
acc_accession._accession_key Implied Constraint R
accid text 2147483647  √  null
prefixpart text 2147483647  √  null
acc_accessionmax.prefixpart Implied Constraint R
numericpart int4 10  √  null
_logicaldb_key int4 10  √  null
acc_logicaldb._logicaldb_key Implied Constraint R
_object_key int4 10  √  null
_mgitype_key int4 10  √  null
acc_mgitype._mgitype_key Implied Constraint R
preferred int2 5  √  null
jnum int4 10  √  null
short_citation text 2147483647  √  null
jnumid text 2147483647  √  null
modifiedby text 2147483647  √  null
_assoc_key int4 10  √  null
seq_source_assoc._assoc_key Implied Constraint R
_sequence_key int4 10  √  null
seq_genetrap._sequence_key Implied Constraint R
_allele_key int4 10  √  null
all_allele._allele_key Implied Constraint R
_qualifier_key int4 10  √  null
_refs_key int4 10  √  null
bib_refs._refs_key Implied Constraint R
_createdby_key int4 10  √  null
_modifiedby_key int4 10  √  null
creation_date timestamp 29,6  √  null
modification_date timestamp 29,6  √  null
createdby text 2147483647  √  null
logicaldb text 2147483647  √  null

Analyzed at Mon Nov 20 05:26 EST 2017


Close relationships: