Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.dag_closure
A record in this table represents an ancestor/descendent pair within a DAG. It caches data for performance reasons. Two
common queries of a DAG are:

1. retrieve all the descendents of a node
2. retrieve all the ancestors of a node

This table provides a mechanism for performing such queries within one SQL statement.

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
_dag_key int4 10
dag_dag._dag_key dag_closure__dag_key_fkey C
foreign key to DAG_DAG
_mgitype_key int4 10
acc_mgitype._mgitype_key dag_closure__mgitype_key_fkey R
foreign key to ACC_MGIType
_ancestor_key int4 10
dag_node._node_key dag_closure__ancestor_key_fkey C
foreign key to DAG_Node._Node_key
_descendent_key int4 10
dag_node._node_key dag_closure__descendent_key_fkey C
foreign key to DAG_Node._Node_key
_ancestorobject_key int4 10 the MGI object to which the Ancestor node refers
_descendentobject_key int4 10 the MGI object to which the Descendent node refers
_ancestorlabel_key int4 10
dag_label._label_key dag_closure__ancestorlabel_key_fkey R
foreign key to DAG_Label; the label of the Ancestor
_descendentlabel_key int4 10
dag_label._label_key dag_closure__descendentlabel_key_fkey R
foreign key to DAG_Label; the label of the Descendent
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 1,801,972 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_dag_key + _ancestor_key + _descendent_key Primary key, Used to cluster data Asc/Asc/Asc dag_closure_pkey
_ancestor_key Performance Asc dag_closure_idx_ancestor_key
_ancestorlabel_key Performance Asc dag_closure_idx_ancestorlabel_key
_ancestorobject_key + _descendentobject_key + _dag_key Performance Asc/Asc/Asc dag_closure_idx_clustered
_descendent_key Performance Asc dag_closure_idx_descendent_key
_descendentlabel_key Performance Asc dag_closure_idx_descendentlabel_key
_descendentobject_key + _ancestorobject_key + _dag_key Performance Asc/Asc/Asc dag_closure_idx_descendentobject_key
_mgitype_key Performance Asc dag_closure_idx_mgitype_key

Close relationships  within of separation: