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
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_user_key int4 10
acc_accession
acc_accession
acc_accessionreference
acc_accessionreference
acc_actualdb
acc_actualdb
acc_logicaldb
acc_logicaldb
acc_mgitype
acc_mgitype
all_allele
all_allele
all_allele
all_allele_cellline
all_allele_cellline
all_cellline
all_cellline
all_cellline_derivation
all_cellline_derivation
all_cre_cache
all_cre_cache
all_knockout_cache
all_knockout_cache
all_variant
all_variant
all_variant_sequence
all_variant_sequence
bib_refs
bib_refs
bib_workflow_data
bib_workflow_data
bib_workflow_relevance
bib_workflow_relevance
bib_workflow_status
bib_workflow_status
bib_workflow_tag
bib_workflow_tag
go_tracking
go_tracking
go_tracking
gxd_allelegenotype
gxd_allelegenotype
gxd_allelepair
gxd_allelepair
gxd_antibody
gxd_antibody
gxd_antigen
gxd_antigen
gxd_assay
gxd_assay
gxd_genotype
gxd_genotype
gxd_htexperiment
gxd_htexperiment
gxd_htexperiment
gxd_htexperiment
gxd_htexperiment
gxd_htrawsample
gxd_htrawsample
gxd_htsample
gxd_htsample
gxd_htsample_rnaseq
gxd_htsample_rnaseq
gxd_htsample_rnaseqcombined
gxd_htsample_rnaseqcombined
gxd_htsample_rnaseqset
gxd_htsample_rnaseqset
gxd_htsample_rnaseqset_cache
gxd_htsample_rnaseqset_cache
gxd_htsample_rnaseqsetmember
gxd_htsample_rnaseqsetmember
gxd_index
gxd_index
gxd_index_stages
gxd_index_stages
img_image
img_image
img_imagepane_assoc
img_imagepane_assoc
map_coord_collection
map_coord_collection
map_coord_feature
map_coord_feature
map_coordinate
map_coordinate
mgi_keyvalue
mgi_keyvalue
mgi_note
mgi_note
mgi_notetype
mgi_notetype
mgi_organism
mgi_organism
mgi_organism_mgitype
mgi_organism_mgitype
mgi_property
mgi_property
mgi_propertytype
mgi_propertytype
mgi_refassoctype
mgi_refassoctype
mgi_reference_assoc
mgi_reference_assoc
mgi_relationship
mgi_relationship
mgi_relationship_category
mgi_relationship_category
mgi_relationship_property
mgi_relationship_property
mgi_set
mgi_set
mgi_setmember
mgi_setmember
mgi_setmember_emapa
mgi_setmember_emapa
mgi_synonym
mgi_synonym
mgi_synonymtype
mgi_synonymtype
mgi_translation
mgi_translation
mgi_translationtype
mgi_translationtype
mgi_user
mgi_user
mrk_biotypemapping
mrk_biotypemapping
mrk_chromosome
mrk_chromosome
mrk_cluster
mrk_cluster
mrk_history
mrk_history
mrk_location_cache
mrk_location_cache
mrk_marker
mrk_marker
mrk_mcv_cache
mrk_mcv_cache
mrk_mcv_count_cache
mrk_mcv_count_cache
mrk_strainmarker
mrk_strainmarker
prb_alias
prb_alias
prb_allele
prb_allele
prb_allele_strain
prb_allele_strain
prb_marker
prb_marker
prb_probe
prb_probe
prb_reference
prb_reference
prb_rflv
prb_rflv
prb_source
prb_source
prb_strain
prb_strain
prb_strain_genotype
prb_strain_genotype
prb_strain_marker
prb_strain_marker
seq_allele_assoc
seq_allele_assoc
seq_coord_cache
seq_coord_cache
seq_genemodel
seq_genemodel
seq_genetrap
seq_genetrap
seq_marker_cache
seq_marker_cache
seq_probe_cache
seq_probe_cache
seq_sequence
seq_sequence
seq_sequence_assoc
seq_sequence_assoc
seq_sequence_raw
seq_sequence_raw
seq_source_assoc
seq_source_assoc
voc_annotheader
voc_annotheader
voc_annotheader
voc_evidence
voc_evidence
voc_evidence_property
voc_evidence_property
voc_term
voc_term
voc_term_emapa
voc_term_emapa
voc_term_emaps
voc_term_emaps
primary key
_usertype_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 23 (User Type)
_userstatus_key int4 10
voc_term
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
foreign key to VOC_Term where _Vocab_key = 127 (Workflow Group)
_createdby_key int4 10 1001
mgi_user
user who created the record
_modifiedby_key int4 10 1001
mgi_user
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 314 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort
_user_key Primary key Asc
_createdby_key Performance Asc
_group_key Performance Asc
login Performance Asc
_modifiedby_key Performance Asc
_userstatus_key Performance Asc
_usertype_key Performance Asc

Close relationships  within of separation: