Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.acc_logicaldb
Defines a logical entity to which to attach accession numbers. Examples include: Sequence DB, MGI, RIKEN, etc.. After a logical entity is defined, multiple URLs (actual database objects) may be attached to the logical object. Master table of ACC_ActualDB.

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
_logicaldb_key int4 10
acc_accession._logicaldb_key acc_accession__logicaldb_key_fkey R
acc_actualdb._logicaldb_key acc_actualdb__logicaldb_key_fkey C
acc_logicaldb_view._logicaldb_key Implied Constraint R
acc_view._logicaldb_key Implied Constraint R
all_acc_view._logicaldb_key Implied Constraint R
all_cellline_acc_view._logicaldb_key Implied Constraint R
all_derivation_summary_view._logicaldb_key Implied Constraint R
all_summary_view._logicaldb_key Implied Constraint R
bib_acc_view._logicaldb_key Implied Constraint R
bib_summary_all_view._logicaldb_key Implied Constraint R
gxd_antibody_acc_view._logicaldb_key Implied Constraint R
gxd_antigen_acc_view._logicaldb_key Implied Constraint R
gxd_antigen_summary_view._logicaldb_key Implied Constraint R
gxd_assay_acc_view._logicaldb_key Implied Constraint R
gxd_genotype_acc_view._logicaldb_key Implied Constraint R
gxd_genotype_summary_view._logicaldb_key Implied Constraint R
img_image_acc_view._logicaldb_key Implied Constraint R
img_image_summary_view._logicaldb_key Implied Constraint R
mgi_organism_acc_view._logicaldb_key Implied Constraint R
mgi_organism_summary_view._logicaldb_key Implied Constraint R
mld_acc_view._logicaldb_key Implied Constraint R
mld_summary_view._logicaldb_key Implied Constraint R
mrk_acc_view._logicaldb_key Implied Constraint R
mrk_accnoref_view._logicaldb_key Implied Constraint R
mrk_accref1_view._logicaldb_key Implied Constraint R
mrk_accref2_view._logicaldb_key Implied Constraint R
mrk_accref3_view._logicaldb_key Implied Constraint R
mrk_accref_view._logicaldb_key Implied Constraint R
mrk_summary_view._logicaldb_key Implied Constraint R
prb_acc_view._logicaldb_key Implied Constraint R
prb_accnoref_view._logicaldb_key Implied Constraint R
prb_accref_view._logicaldb_key Implied Constraint R
prb_accrefnoseq_view._logicaldb_key Implied Constraint R
prb_source_acc_view._logicaldb_key Implied Constraint R
prb_source_summary_view._logicaldb_key Implied Constraint R
prb_strain_acc_view._logicaldb_key Implied Constraint R
prb_strain_summary_view._logicaldb_key Implied Constraint R
prb_tissue_summary_view._logicaldb_key Implied Constraint R
seq_allele_assoc_view._logicaldb_key Implied Constraint R
seq_marker_cache._logicaldb_key Implied Constraint R
seq_sequence_acc_view._logicaldb_key Implied Constraint R
seq_summary_view._logicaldb_key Implied Constraint R
voc_annot_view._logicaldb_key Implied Constraint R
voc_term_acc_view._logicaldb_key Implied Constraint R
voc_term_summary_view._logicaldb_key Implied Constraint R
voc_term_view._logicaldb_key Implied Constraint R
voc_vocab._logicaldb_key voc_vocab__logicaldb_key_fkey R
voc_vocab_view._logicaldb_key Implied Constraint R
primary key
name text 2147483647 name of the logical entity
description text 2147483647  √  null brief description of the logical entity
_organism_key int4 10  √  null
mgi_organism._organism_key acc_logicaldb__organism_key_fkey R
organism (foreign key to MGI_Organism)
_createdby_key int4 10 1001
mgi_user._user_key acc_logicaldb__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key acc_logicaldb__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 193 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_logicaldb_key Primary key, Used to cluster data Asc acc_logicaldb_pkey
name + _logicaldb_key Must be unique Asc/Asc acc_logicaldb_idx_name
_organism_key Performance Asc acc_logicaldb_idx_organism_key

Close relationships  within of separation: