Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.mgi_user 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 R
acc_accession._modifiedby_key acc_accession__modifiedby_key R
acc_accessionreference._createdby_key acc_accessionreference__createdby_key R
acc_accessionreference._modifiedby_key acc_accessionreference__modifiedby_key R
acc_actualdb._createdby_key acc_actualdb__createdby_key R
acc_actualdb._modifiedby_key acc_actualdb__modifiedby_key R
acc_logicaldb._createdby_key acc_logicaldb__createdby_key R
acc_logicaldb._modifiedby_key acc_logicaldb__modifiedby_key R
acc_mgitype._createdby_key acc_mgitype__createdby_key R
acc_mgitype._modifiedby_key acc_mgitype__modifiedby_key R
all_allele._approvedby_key all_allele__approvedby_key R
all_allele._createdby_key all_allele__createdby_key R
all_allele._modifiedby_key all_allele__modifiedby_key R
all_allele_cellline._createdby_key all_allele_cellline__createdby_key R
all_allele_cellline._modifiedby_key all_allele_cellline__modifiedby_key R
all_cellline._createdby_key all_cellline__createdby_key R
all_cellline._modifiedby_key all_cellline__modifiedby_key R
all_cellline_derivation._createdby_key all_cellline_derivation__createdby_key R
all_cellline_derivation._modifiedby_key all_cellline_derivation__modifiedby_key R
all_cre_cache._createdby_key all_cre_cache__createdby_key R
all_cre_cache._modifiedby_key all_cre_cache__modifiedby_key R
all_knockout_cache._createdby_key all_knockout_cache__createdby_key R
all_knockout_cache._modifiedby_key all_knockout_cache__modifiedby_key R
all_marker_assoc._createdby_key all_marker_assoc__createdby_key R
all_marker_assoc._modifiedby_key all_marker_assoc__modifiedby_key R
bib_dataset._createdby_key bib_dataset__createdby_key R
bib_dataset._modifiedby_key bib_dataset__modifiedby_key R
bib_dataset_assoc._createdby_key bib_dataset_assoc__createdby_key R
bib_dataset_assoc._modifiedby_key bib_dataset_assoc__modifiedby_key R
bib_refs._createdby_key bib_refs__createdby_key R
bib_refs._modifiedby_key bib_refs__modifiedby_key R
go_tracking._completedby_key go_tracking__completedby_key R
go_tracking._createdby_key go_tracking__createdby_key R
go_tracking._modifiedby_key go_tracking__modifiedby_key R
gxd_allelegenotype._createdby_key gxd_allelegenotype__createdby_key R
gxd_allelegenotype._modifiedby_key gxd_allelegenotype__modifiedby_key R
gxd_allelepair._createdby_key gxd_allelepair__createdby_key R
gxd_allelepair._modifiedby_key gxd_allelepair__modifiedby_key R
gxd_antibody._createdby_key gxd_antibody__createdby_key R
gxd_antibody._modifiedby_key gxd_antibody__modifiedby_key R
gxd_antigen._createdby_key gxd_antigen__createdby_key R
gxd_antigen._modifiedby_key gxd_antigen__modifiedby_key R
gxd_assay._createdby_key gxd_assay__createdby_key R
gxd_assay._modifiedby_key gxd_assay__modifiedby_key R
gxd_genotype._createdby_key gxd_genotype__createdby_key R
gxd_genotype._modifiedby_key gxd_genotype__modifiedby_key R
gxd_index._createdby_key gxd_index__createdby_key R
gxd_index._modifiedby_key gxd_index__modifiedby_key R
gxd_index_stages._createdby_key gxd_index_stages__createdby_key R
gxd_index_stages._modifiedby_key gxd_index_stages__modifiedby_key R
img_image._createdby_key img_image__createdby_key R
img_image._modifiedby_key img_image__modifiedby_key R
img_imagepane_assoc._createdby_key img_imagepane_assoc__createdby_key R
img_imagepane_assoc._modifiedby_key img_imagepane_assoc__modifiedby_key R
map_coord_collection._createdby_key map_coord_collection__createdby_key R
map_coord_collection._modifiedby_key map_coord_collection__modifiedby_key R
map_coord_feature._createdby_key map_coord_feature__createdby_key R
map_coord_feature._modifiedby_key map_coord_feature__modifiedby_key R
map_coordinate._createdby_key map_coordinate__createdby_key R
map_coordinate._modifiedby_key map_coordinate__modifiedby_key R
mgi_attributehistory._createdby_key mgi_attributehistory__createdby_key R
mgi_attributehistory._modifiedby_key mgi_attributehistory__modifiedby_key R
mgi_note._createdby_key mgi_note__createdby_key R
mgi_note._modifiedby_key mgi_note__modifiedby_key R
mgi_notechunk._createdby_key mgi_notechunk__createdby_key R
mgi_notechunk._modifiedby_key mgi_notechunk__modifiedby_key R
mgi_notetype._createdby_key mgi_notetype__createdby_key R
mgi_notetype._modifiedby_key mgi_notetype__modifiedby_key R
mgi_organism._createdby_key mgi_organism__createdby_key R
mgi_organism._modifiedby_key mgi_organism__modifiedby_key R
mgi_organism_mgitype._createdby_key mgi_organism_mgitype__createdby_key R
mgi_organism_mgitype._modifiedby_key mgi_organism_mgitype__modifiedby_key R
mgi_refassoctype._createdby_key mgi_refassoctype__createdby_key R
mgi_refassoctype._modifiedby_key mgi_refassoctype__modifiedby_key R
mgi_reference_assoc._createdby_key mgi_reference_assoc__createdby_key R
mgi_reference_assoc._modifiedby_key mgi_reference_assoc__modifiedby_key R
mgi_roletask._createdby_key mgi_roletask__createdby_key R
mgi_roletask._modifiedby_key mgi_roletask__modifiedby_key R
mgi_set._createdby_key mgi_set__createdby_key R
mgi_set._modifiedby_key mgi_set__modifiedby_key R
mgi_setmember._createdby_key mgi_setmember__createdby_key R
mgi_setmember._modifiedby_key mgi_setmember__modifiedby_key R
mgi_synonym._createdby_key mgi_synonym__createdby_key R
mgi_synonym._modifiedby_key mgi_synonym__modifiedby_key R
mgi_synonymtype._createdby_key mgi_synonymtype__createdby_key R
mgi_synonymtype._modifiedby_key mgi_synonymtype__modifiedby_key R
mgi_translation._createdby_key mgi_translation__createdby_key R
mgi_translation._modifiedby_key mgi_translation__modifiedby_key R
mgi_translationtype._createdby_key mgi_translationtype__createdby_key R
mgi_translationtype._modifiedby_key mgi_translationtype__modifiedby_key R
mgi_user._createdby_key mgi_user__createdby_key R
mgi_user._modifiedby_key mgi_user__modifiedby_key R
mgi_userrole._createdby_key mgi_userrole__createdby_key R
mgi_userrole._modifiedby_key mgi_userrole__modifiedby_key R
mgi_userrole._user_key Implied Constraint R
mgi_vocassociation._createdby_key mgi_vocassociation__createdby_key R
mgi_vocassociation._modifiedby_key mgi_vocassociation__modifiedby_key R
mgi_vocassociationtype._createdby_key mgi_vocassociationtype__createdby_key R
mgi_vocassociationtype._modifiedby_key mgi_vocassociationtype__modifiedby_key R
mrk_chromosome._createdby_key mrk_chromosome__createdby_key R
mrk_chromosome._modifiedby_key mrk_chromosome__modifiedby_key R
mrk_history._createdby_key mrk_history__createdby_key R
mrk_history._modifiedby_key mrk_history__modifiedby_key R
mrk_location_cache._createdby_key mrk_location_cache__createdby_key R
mrk_location_cache._modifiedby_key mrk_location_cache__modifiedby_key R
mrk_marker._createdby_key mrk_marker__createdby_key R
mrk_marker._modifiedby_key mrk_marker__modifiedby_key R
mrk_mcv_cache._createdby_key mrk_mcv_cache__createdby_key R
mrk_mcv_cache._modifiedby_key mrk_mcv_cache__modifiedby_key R
mrk_mcv_count_cache._createdby_key mrk_mcv_count_cache__createdby_key R
mrk_mcv_count_cache._modifiedby_key mrk_mcv_count_cache__modifiedby_key R
prb_alias._createdby_key prb_alias__createdby_key R
prb_alias._modifiedby_key prb_alias__modifiedby_key R
prb_allele._createdby_key prb_allele__createdby_key R
prb_allele._modifiedby_key prb_allele__modifiedby_key R
prb_allele_strain._createdby_key prb_allele_strain__createdby_key R
prb_allele_strain._modifiedby_key prb_allele_strain__modifiedby_key R
prb_marker._createdby_key prb_marker__createdby_key R
prb_marker._modifiedby_key prb_marker__modifiedby_key R
prb_probe._createdby_key prb_probe__createdby_key R
prb_probe._modifiedby_key prb_probe__modifiedby_key R
prb_reference._createdby_key prb_reference__createdby_key R
prb_reference._modifiedby_key prb_reference__modifiedby_key R
prb_rflv._createdby_key prb_rflv__createdby_key R
prb_rflv._modifiedby_key prb_rflv__modifiedby_key R
prb_source._createdby_key prb_source__createdby_key R
prb_source._modifiedby_key prb_source__modifiedby_key R
prb_strain._createdby_key prb_strain__createdby_key R
prb_strain._modifiedby_key prb_strain__modifiedby_key R
prb_strain_genotype._createdby_key prb_strain_genotype__createdby_key R
prb_strain_genotype._modifiedby_key prb_strain_genotype__modifiedby_key R
prb_strain_marker._createdby_key prb_strain_marker__createdby_key R
prb_strain_marker._modifiedby_key prb_strain_marker__modifiedby_key R
seq_allele_assoc._createdby_key seq_allele_assoc__createdby_key R
seq_allele_assoc._modifiedby_key seq_allele_assoc__modifiedby_key R
seq_coord_cache._createdby_key seq_coord_cache__createdby_key R
seq_coord_cache._modifiedby_key seq_coord_cache__modifiedby_key R
seq_description_cache._createdby_key seq_description_cache__createdby_key R
seq_description_cache._modifiedby_key seq_description_cache__modifiedby_key R
seq_genemodel._createdby_key seq_genemodel__createdby_key R
seq_genemodel._modifiedby_key seq_genemodel__modifiedby_key R
seq_genetrap._createdby_key seq_genetrap__createdby_key R
seq_genetrap._modifiedby_key seq_genetrap__modifiedby_key R
seq_marker_cache._createdby_key seq_marker_cache__createdby_key R
seq_marker_cache._modifiedby_key seq_marker_cache__modifiedby_key R
seq_probe_cache._createdby_key seq_probe_cache__createdby_key R
seq_probe_cache._modifiedby_key seq_probe_cache__modifiedby_key R
seq_sequence._createdby_key seq_sequence__createdby_key R
seq_sequence._modifiedby_key seq_sequence__modifiedby_key R
seq_sequence_assoc._createdby_key seq_sequence_assoc__createdby_key R
seq_sequence_assoc._modifiedby_key seq_sequence_assoc__modifiedby_key R
seq_sequence_raw._createdby_key seq_sequence_raw__createdby_key R
seq_sequence_raw._modifiedby_key seq_sequence_raw__modifiedby_key R
seq_source_assoc._createdby_key seq_source_assoc__createdby_key R
seq_source_assoc._modifiedby_key seq_source_assoc__modifiedby_key R
voc_annotheader._approvedby_key voc_annotheader__approvedby_key R
voc_annotheader._createdby_key voc_annotheader__createdby_key R
voc_annotheader._modifiedby_key voc_annotheader__modifiedby_key R
voc_evidence._createdby_key voc_evidence__createdby_key R
voc_evidence._modifiedby_key voc_evidence__modifiedby_key R
voc_evidence_property._createdby_key voc_evidence_property__createdby_key R
voc_evidence_property._modifiedby_key voc_evidence_property__modifiedby_key R
voc_term._createdby_key voc_term__createdby_key R
voc_term._modifiedby_key voc_term__modifiedby_key R
_usertype_key int4 10
voc_term._term_key mgi_user__usertype_key R
_userstatus_key int4 10
voc_term._term_key mgi_user__userstatus_key R
login varchar 30
name varchar 255
_createdby_key int4 10
mgi_user._user_key mgi_user__createdby_key R
_modifiedby_key int4 10
mgi_user._user_key mgi_user__modifiedby_key R
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 214 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_user_key Primary key Asc mgi_user_pkey
_user_key Must be unique Asc mgi_user_idx_user_key
_createdby_key Performance Asc mgi_user_idx_createdby_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: