Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.dag_node
A record in this table represents a specific Node within a DAG. The _Object_key/DAG_DAG._MGIType_key combination
identifies the specific Node object. In the case of a GO DAG, this is a specific Vocabulary Term.
The DAG_DAG._MGIType_key identifies the type of object (a Vocabulary Term) and the _Object_key identifies the
object itself.

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
_node_key int4 10
dag_closure._ancestor_key dag_closure__ancestor_key_fkey C
dag_closure._descendent_key dag_closure__descendent_key_fkey C
dag_edge._child_key dag_edge__child_key_fkey C
dag_edge._parent_key dag_edge__parent_key_fkey C
dag_node_view._node_key Implied Constraint R
primary key
_dag_key int4 10
dag_dag._dag_key dag_node__dag_key_fkey C
foreign key to DAG_DAG
_object_key int4 10 foreign key to any object defined in ACC_MGIType
_label_key int4 10
dag_label._label_key dag_node__label_key_fkey R
foreign key to DAG_Label
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 125,736 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_node_key Primary key, Used to cluster data Asc dag_node_pkey
_dag_key + _object_key Performance Asc/Asc dag_node_idx_clustered
_label_key Performance Asc dag_node_idx_label_key
_object_key Performance Asc dag_node_idx_object_key

Close relationships  within of separation: