Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mgi_user
A record in this table represents a valid MGI user login.

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
_user_key int4 10
acc_accession._createdby_key acc_accession__createdby_key_fkey R
acc_accession._modifiedby_key acc_accession__modifiedby_key_fkey R
acc_accessionreference._createdby_key acc_accessionreference__createdby_key_fkey R
acc_accessionreference._modifiedby_key acc_accessionreference__modifiedby_key_fkey R
acc_actualdb._createdby_key acc_actualdb__createdby_key_fkey R
acc_actualdb._modifiedby_key acc_actualdb__modifiedby_key_fkey R
acc_logicaldb._createdby_key acc_logicaldb__createdby_key_fkey R
acc_logicaldb._modifiedby_key acc_logicaldb__modifiedby_key_fkey R
acc_mgitype._createdby_key acc_mgitype__createdby_key_fkey R
acc_mgitype._modifiedby_key acc_mgitype__modifiedby_key_fkey R
all_allele._approvedby_key all_allele__approvedby_key_fkey R
all_allele._createdby_key all_allele__createdby_key_fkey R
all_allele._modifiedby_key all_allele__modifiedby_key_fkey R
all_allele_cellline._createdby_key all_allele_cellline__createdby_key_fkey R
all_allele_cellline._modifiedby_key all_allele_cellline__modifiedby_key_fkey R
all_cellline._createdby_key all_cellline__createdby_key_fkey R
all_cellline._modifiedby_key all_cellline__modifiedby_key_fkey R
all_cellline_derivation._createdby_key all_cellline_derivation__createdby_key_fkey R
all_cellline_derivation._modifiedby_key all_cellline_derivation__modifiedby_key_fkey R
all_cre_cache._createdby_key all_cre_cache__createdby_key_fkey R
all_cre_cache._modifiedby_key all_cre_cache__modifiedby_key_fkey R
all_knockout_cache._createdby_key all_knockout_cache__createdby_key_fkey R
all_knockout_cache._modifiedby_key all_knockout_cache__modifiedby_key_fkey R
bib_dataset._createdby_key bib_dataset__createdby_key_fkey R
bib_dataset._modifiedby_key bib_dataset__modifiedby_key_fkey R
bib_dataset_assoc._createdby_key bib_dataset_assoc__createdby_key_fkey R
bib_dataset_assoc._modifiedby_key bib_dataset_assoc__modifiedby_key_fkey R
bib_refs._createdby_key bib_refs__createdby_key_fkey R
bib_refs._modifiedby_key bib_refs__modifiedby_key_fkey R
go_tracking._completedby_key go_tracking__completedby_key_fkey R
go_tracking._createdby_key go_tracking__createdby_key_fkey R
go_tracking._modifiedby_key go_tracking__modifiedby_key_fkey R
gxd_allelegenotype._createdby_key gxd_allelegenotype__createdby_key_fkey R
gxd_allelegenotype._modifiedby_key gxd_allelegenotype__modifiedby_key_fkey R
gxd_allelepair._createdby_key gxd_allelepair__createdby_key_fkey R
gxd_allelepair._modifiedby_key gxd_allelepair__modifiedby_key_fkey R
gxd_antibody._createdby_key gxd_antibody__createdby_key_fkey R
gxd_antibody._modifiedby_key gxd_antibody__modifiedby_key_fkey R
gxd_antigen._createdby_key gxd_antigen__createdby_key_fkey R
gxd_antigen._modifiedby_key gxd_antigen__modifiedby_key_fkey R
gxd_assay._createdby_key gxd_assay__createdby_key_fkey R
gxd_assay._modifiedby_key gxd_assay__modifiedby_key_fkey R
gxd_genotype._createdby_key gxd_genotype__createdby_key_fkey R
gxd_genotype._modifiedby_key gxd_genotype__modifiedby_key_fkey R
gxd_htexperiment._createdby_key gxd_htexperiment__createdby_key_fkey R
gxd_htexperiment._evaluatedby_key gxd_htexperiment__evaluatedby_key_fkey R
gxd_htexperiment._initialcuratedby_key gxd_htexperiment__initialcuratedby_key_fkey R
gxd_htexperiment._lastcuratedby_key gxd_htexperiment__lastcuratedby_key_fkey R
gxd_htexperiment._modifiedby_key gxd_htexperiment__modifiedby_key_fkey R
gxd_htsample._createdby_key gxd_htsample__createdby_key_fkey R
gxd_htsample._modifiedby_key gxd_htsample__modifiedby_key_fkey R
gxd_index._createdby_key gxd_index__createdby_key_fkey R
gxd_index._modifiedby_key gxd_index__modifiedby_key_fkey R
gxd_index_stages._createdby_key gxd_index_stages__createdby_key_fkey R
gxd_index_stages._modifiedby_key gxd_index_stages__modifiedby_key_fkey R
img_image._createdby_key img_image__createdby_key_fkey R
img_image._modifiedby_key img_image__modifiedby_key_fkey R
img_imagepane_assoc._createdby_key img_imagepane_assoc__createdby_key_fkey R
img_imagepane_assoc._modifiedby_key img_imagepane_assoc__modifiedby_key_fkey R
map_coord_collection._createdby_key map_coord_collection__createdby_key_fkey R
map_coord_collection._modifiedby_key map_coord_collection__modifiedby_key_fkey R
map_coord_feature._createdby_key map_coord_feature__createdby_key_fkey R
map_coord_feature._modifiedby_key map_coord_feature__modifiedby_key_fkey R
map_coordinate._createdby_key map_coordinate__createdby_key_fkey R
map_coordinate._modifiedby_key map_coordinate__modifiedby_key_fkey R
mgi_note._createdby_key mgi_note__createdby_key_fkey R
mgi_note._modifiedby_key mgi_note__modifiedby_key_fkey R
mgi_notechunk._createdby_key mgi_notechunk__createdby_key_fkey R
mgi_notechunk._modifiedby_key mgi_notechunk__modifiedby_key_fkey R
mgi_notetype._createdby_key mgi_notetype__createdby_key_fkey R
mgi_notetype._modifiedby_key mgi_notetype__modifiedby_key_fkey R
mgi_organism._createdby_key mgi_organism__createdby_key_fkey R
mgi_organism._modifiedby_key mgi_organism__modifiedby_key_fkey R
mgi_organism_mgitype._createdby_key mgi_organism_mgitype__createdby_key_fkey R
mgi_organism_mgitype._modifiedby_key mgi_organism_mgitype__modifiedby_key_fkey R
mgi_property._createdby_key mgi_property__createdby_key_fkey R
mgi_property._modifiedby_key mgi_property__modifiedby_key_fkey R
mgi_propertytype._createdby_key mgi_propertytype__createdby_key_fkey R
mgi_propertytype._modifiedby_key mgi_propertytype__modifiedby_key_fkey R
mgi_refassoctype._createdby_key mgi_refassoctype__createdby_key_fkey R
mgi_refassoctype._modifiedby_key mgi_refassoctype__modifiedby_key_fkey R
mgi_reference_assoc._createdby_key mgi_reference_assoc__createdby_key_fkey R
mgi_reference_assoc._modifiedby_key mgi_reference_assoc__modifiedby_key_fkey R
mgi_relationship._createdby_key mgi_relationship__createdby_key_fkey R
mgi_relationship._modifiedby_key mgi_relationship__modifiedby_key_fkey R
mgi_relationship_category._createdby_key mgi_relationship_category__createdby_key_fkey R
mgi_relationship_category._modifiedby_key mgi_relationship_category__modifiedby_key_fkey R
mgi_relationship_property._createdby_key mgi_relationship_property__createdby_key_fkey R
mgi_relationship_property._modifiedby_key mgi_relationship_property__modifiedby_key_fkey R
mgi_roletask._createdby_key mgi_roletask__createdby_key_fkey R
mgi_roletask._modifiedby_key mgi_roletask__modifiedby_key_fkey R
mgi_set._createdby_key mgi_set__createdby_key_fkey R
mgi_set._modifiedby_key mgi_set__modifiedby_key_fkey R
mgi_setmember._createdby_key mgi_setmember__createdby_key_fkey R
mgi_setmember._modifiedby_key mgi_setmember__modifiedby_key_fkey R
mgi_setmember_emapa._createdby_key mgi_setmember_emapa__createdby_key_fkey R
mgi_setmember_emapa._modifiedby_key mgi_setmember_emapa__modifiedby_key_fkey R
mgi_synonym._createdby_key mgi_synonym__createdby_key_fkey R
mgi_synonym._modifiedby_key mgi_synonym__modifiedby_key_fkey R
mgi_synonymtype._createdby_key mgi_synonymtype__createdby_key_fkey R
mgi_synonymtype._modifiedby_key mgi_synonymtype__modifiedby_key_fkey R
mgi_translation._createdby_key mgi_translation__createdby_key_fkey R
mgi_translation._modifiedby_key mgi_translation__modifiedby_key_fkey R
mgi_translationtype._createdby_key mgi_translationtype__createdby_key_fkey R
mgi_translationtype._modifiedby_key mgi_translationtype__modifiedby_key_fkey R
mgi_user._createdby_key mgi_user__createdby_key_fkey R
mgi_user._modifiedby_key mgi_user__modifiedby_key_fkey R
mgi_user_active_view._user_key Implied Constraint R
mgi_userrole._createdby_key mgi_userrole__createdby_key_fkey R
mgi_userrole._modifiedby_key mgi_userrole__modifiedby_key_fkey R
mgi_userrole._user_key Implied Constraint R
mgi_userrole_view._user_key Implied Constraint R
mgi_usertask_view._user_key Implied Constraint R
mrk_biotypemapping._createdby_key mrk_biotypemapping__createdby_key_fkey R
mrk_biotypemapping._modifiedby_key mrk_biotypemapping__modifiedby_key_fkey R
mrk_chromosome._createdby_key mrk_chromosome__createdby_key_fkey R
mrk_chromosome._modifiedby_key mrk_chromosome__modifiedby_key_fkey R
mrk_cluster._createdby_key mrk_cluster__createdby_key_fkey R
mrk_cluster._modifiedby_key mrk_cluster__modifiedby_key_fkey R
mrk_history._createdby_key mrk_history__createdby_key_fkey R
mrk_history._modifiedby_key mrk_history__modifiedby_key_fkey R
mrk_location_cache._createdby_key mrk_location_cache__createdby_key_fkey R
mrk_location_cache._modifiedby_key mrk_location_cache__modifiedby_key_fkey R
mrk_marker._createdby_key mrk_marker__createdby_key_fkey R
mrk_marker._modifiedby_key mrk_marker__modifiedby_key_fkey R
mrk_mcv_cache._createdby_key mrk_mcv_cache__createdby_key_fkey R
mrk_mcv_cache._modifiedby_key mrk_mcv_cache__modifiedby_key_fkey R
mrk_mcv_count_cache._createdby_key mrk_mcv_count_cache__createdby_key_fkey R
mrk_mcv_count_cache._modifiedby_key mrk_mcv_count_cache__modifiedby_key_fkey R
prb_alias._createdby_key prb_alias__createdby_key_fkey R
prb_alias._modifiedby_key prb_alias__modifiedby_key_fkey R
prb_allele._createdby_key prb_allele__createdby_key_fkey R
prb_allele._modifiedby_key prb_allele__modifiedby_key_fkey R
prb_allele_strain._createdby_key prb_allele_strain__createdby_key_fkey R
prb_allele_strain._modifiedby_key prb_allele_strain__modifiedby_key_fkey R
prb_marker._createdby_key prb_marker__createdby_key_fkey R
prb_marker._modifiedby_key prb_marker__modifiedby_key_fkey R
prb_probe._createdby_key prb_probe__createdby_key_fkey R
prb_probe._modifiedby_key prb_probe__modifiedby_key_fkey R
prb_reference._createdby_key prb_reference__createdby_key_fkey R
prb_reference._modifiedby_key prb_reference__modifiedby_key_fkey R
prb_rflv._createdby_key prb_rflv__createdby_key_fkey R
prb_rflv._modifiedby_key prb_rflv__modifiedby_key_fkey R
prb_source._createdby_key prb_source__createdby_key_fkey R
prb_source._modifiedby_key prb_source__modifiedby_key_fkey R
prb_strain._createdby_key prb_strain__createdby_key_fkey R
prb_strain._modifiedby_key prb_strain__modifiedby_key_fkey R
prb_strain_genotype._createdby_key prb_strain_genotype__createdby_key_fkey R
prb_strain_genotype._modifiedby_key prb_strain_genotype__modifiedby_key_fkey R
prb_strain_marker._createdby_key prb_strain_marker__createdby_key_fkey R
prb_strain_marker._modifiedby_key prb_strain_marker__modifiedby_key_fkey R
seq_allele_assoc._createdby_key seq_allele_assoc__createdby_key_fkey R
seq_allele_assoc._modifiedby_key seq_allele_assoc__modifiedby_key_fkey R
seq_coord_cache._createdby_key seq_coord_cache__createdby_key_fkey R
seq_coord_cache._modifiedby_key seq_coord_cache__modifiedby_key_fkey R
seq_genemodel._createdby_key seq_genemodel__createdby_key_fkey R
seq_genemodel._modifiedby_key seq_genemodel__modifiedby_key_fkey R
seq_genetrap._createdby_key seq_genetrap__createdby_key_fkey R
seq_genetrap._modifiedby_key seq_genetrap__modifiedby_key_fkey R
seq_marker_cache._createdby_key seq_marker_cache__createdby_key_fkey R
seq_marker_cache._modifiedby_key seq_marker_cache__modifiedby_key_fkey R
seq_probe_cache._createdby_key seq_probe_cache__createdby_key_fkey R
seq_probe_cache._modifiedby_key seq_probe_cache__modifiedby_key_fkey R
seq_sequence._createdby_key seq_sequence__createdby_key_fkey R
seq_sequence._modifiedby_key seq_sequence__modifiedby_key_fkey R
seq_sequence_assoc._createdby_key seq_sequence_assoc__createdby_key_fkey R
seq_sequence_assoc._modifiedby_key seq_sequence_assoc__modifiedby_key_fkey R
seq_sequence_raw._createdby_key seq_sequence_raw__createdby_key_fkey R
seq_sequence_raw._modifiedby_key seq_sequence_raw__modifiedby_key_fkey R
seq_source_assoc._createdby_key seq_source_assoc__createdby_key_fkey R
seq_source_assoc._modifiedby_key seq_source_assoc__modifiedby_key_fkey R
voc_annotheader._approvedby_key voc_annotheader__approvedby_key_fkey R
voc_annotheader._createdby_key voc_annotheader__createdby_key_fkey R
voc_annotheader._modifiedby_key voc_annotheader__modifiedby_key_fkey R
voc_evidence._createdby_key voc_evidence__createdby_key_fkey R
voc_evidence._modifiedby_key voc_evidence__modifiedby_key_fkey R
voc_evidence_property._createdby_key voc_evidence_property__createdby_key_fkey R
voc_evidence_property._modifiedby_key voc_evidence_property__modifiedby_key_fkey R
voc_term._createdby_key voc_term__createdby_key_fkey R
voc_term._modifiedby_key voc_term__modifiedby_key_fkey R
voc_term_emapa._createdby_key voc_term_emapa__createdby_key_fkey R
voc_term_emapa._modifiedby_key voc_term_emapa__modifiedby_key_fkey R
voc_term_emaps._createdby_key voc_term_emaps__createdby_key_fkey R
voc_term_emaps._modifiedby_key voc_term_emaps__modifiedby_key_fkey R
primary key
_usertype_key int4 10
voc_term._term_key mgi_user__usertype_key_fkey R
foreign key to VOC_Term where _Vocab_key = 23 (User Type)
_userstatus_key int4 10
voc_term._term_key mgi_user__userstatus_key_fkey R
foreign key to VOC_Term where _Vocab_key = 22 (User Status)
login text 2147483647 database login
name text 2147483647 user name
orcid text 2147483647  √  null ORC ids (see orcid.org)
_group_key int4 10  √  null
voc_term._term_key mgi_user__group_key_fkey R
foreign key to VOC_Term where _Vocab_key = 127 (Workflow Group)
_createdby_key int4 10 1001
mgi_user._user_key mgi_user__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key mgi_user__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 271 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_user_key Primary key, Used to cluster data Asc mgi_user_pkey
_createdby_key Performance Asc mgi_user_idx_createdby_key
_group_key Performance Asc mgi_user_idx_group_key
login Performance Asc mgi_user_idx_login
_modifiedby_key Performance Asc mgi_user_idx_modifiedby_key
_userstatus_key Performance Asc mgi_user_idx_userstatus_key
_usertype_key Performance Asc mgi_user_idx_usertype_key

Close relationships  within of separation: