Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mgi_userrole
A record in this table represents a Role/User association.

 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
mgi_userrole_view._userrole_key Implied Constraint R
mgi_usertask_view._userrole_key Implied Constraint R
primary key
_role_key int4 10
voc_term._term_key mgi_userrole__role_key_fkey R
foreign key to VOC_Term where _Vocab_key = 33 (User Role)
_user_key int4 10
mgi_user._user_key Implied Constraint R
foreign key to MGI_User
_createdby_key int4 10 1001
mgi_user._user_key mgi_userrole__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key mgi_userrole__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 287 rows at Mon Mar 09 10:28 EDT 2020

Indexes:
Column(s) Type Sort Constraint Name
_userrole_key Primary key Asc mgi_userrole_pkey
_createdby_key Performance Asc mgi_userrole_idx_createdby_key
_modifiedby_key Performance Asc mgi_userrole_idx_modifiedby_key
_role_key Performance Asc mgi_userrole_idx_role_key
_user_key Performance Asc mgi_userrole_idx_user_key

Close relationships  within of separation: