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
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 serial 10  √  nextval('acc_logicaldb_seq'::regclass)
acc_accession._logicaldb_key acc_accession__logicaldb_key_fkey R
acc_actualdb._logicaldb_key acc_actualdb__logicaldb_key_fkey C
voc_vocab._logicaldb_key voc_vocab__logicaldb_key_fkey 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 167 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_logicaldb_key Primary key 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: