Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
View pub.mgd.mgi_usertask_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
_userrole_key int4 10  √  null
mgi_userrole._userrole_key Implied Constraint R
_role_key int4 10  √  null
_user_key int4 10  √  null
mgi_user._user_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
userrole text 2147483647  √  null
login text 2147483647  √  null
createdby text 2147483647  √  null
modifiedby text 2147483647  √  null
usertask text 2147483647  √  null

Analyzed at Mon Mar 09 10:28 EDT 2020


Close relationships: