Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
View pub.mgd.mgi_relationship_markertss_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
_relationship_key int4 10  √  null
mgi_relationship._relationship_key Implied Constraint R
_category_key int4 10  √  null
mgi_relationship_category._category_key Implied Constraint R
_object_key_1 int4 10  √  null
_object_key_2 int4 10  √  null
_relationshipterm_key int4 10  √  null
_qualifier_key int4 10  √  null
_evidence_key int4 10  √  null
_refs_key int4 10  √  null
bib_notes._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
categoryterm text 2147483647  √  null
relationshipterm text 2147483647  √  null
qualifierterm text 2147483647  √  null
evidenceterm text 2147483647  √  null
marker1 text 2147483647  √  null
marker2 text 2147483647  √  null
jnumid text 2147483647  √  null
jnum int4 10  √  null
short_citation text 2147483647  √  null
modifiedby text 2147483647  √  null
createdby text 2147483647  √  null

Analyzed at Mon May 06 06:19 EDT 2019


Close relationships: